Ed Chen Logic - To Make My Logic More Logical

How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup

by Ed Chen
March 18, 2020March 27, 2020

When I tried to open the standby database to READ ONLY for later real-time query of Active Data Guard (ADG), I got this error message.… Read More »

How to Resolve SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

by Ed Chen
February 8, 2020February 11, 2020

error while loading shared libraries After installing Oracle 10g RAC, we checked the configuration of the cluster database like this: [oracle@primary01 ~]$ srvctl config database… Read More »

How to Configure iSCSI Disk on Solaris

by Ed Chen
January 25, 2020February 3, 2020

For Linux database servers, you may check: How to Build 18c RAC - 1 of 4 - Preparing Two Database Servers. First of all, let's… Read More »

How to Resolve ORA-01722: invalid number

by Ed Chen
January 22, 2020January 31, 2020

ORA-01722 ORA-01722 means that the arithmetic operation in the statement failed to calculate because one of operands cannot be converted to a valid number implicitly.… Read More »

How to Resolve ORA-01017: invalid username/password; logon denied

by Ed Chen
January 18, 2020January 21, 2020

ORA-01017 ORA-01017 means that you either provided an incorrect username or password, so the database that you tried to connect denied you to logon. SQL>… Read More »

How to Resolve ORA-01000: maximum open cursors exceeded

by Ed Chen
January 15, 2020January 17, 2020

ORA-01000 Saw an error ORA-01000: maximum open cursors exceeded when executing a lot of statements. It seemed that the number of open cursors has reached… Read More »

How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied

by Ed Chen
January 11, 2020January 14, 2020

ORA-01045 means that the user who tried to connect to the database has no privilege to connect. Therefore, the database refused the user to logon.… Read More »

How to Empty an Oracle Database

by Ed Chen
January 8, 2020January 17, 2020

Empty a Database In my case, a phased out database server is going to transfer to another project team, my job is to remove all… Read More »

How to Resolve ORA-28001: the password has expired

by Ed Chen
January 4, 2020January 26, 2020

ORA-28001 ORA-28001 means that your password has been expired according to your profile. Normally, you should change the password, but you can still work around… Read More »

How to Resolve ORA-28000: The account is locked

by Ed Chen
January 1, 2020January 14, 2020

ORA-28000 ORA-28000 means that the account that you tried to use is locked because some privileged user disabled the ability of connection. Therefore, it's an… Read More »