Ed Chen Logic - To Make My Logic More Logical

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 14, 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 »

How to Disable SELinux

by Ed Chen
January 1, 2020January 1, 2020

Disable SELinux Let's see the current status of SELinux. [root@web ~]# sestatus SELinux status: enabled SELinuxfs mount: … Read More »

How to Resolve ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

by Ed Chen
December 28, 2019December 29, 2019

ORA-01452 ORA-01452 means that the unique index that you want to impose on columns cannot be created because of duplicate keys have been found. In… Read More »

How to Resolve ORA-01442: column to be modified to NOT NULL is already NOT NULL

by Ed Chen
December 25, 2019December 26, 2019

ORA-01442 ORA-01442 means that the target column is already NOT NULL, you don't have to add it again by modifying the column. I know sometimes… Read More »

How to Resolve ORA-01017 in Database Links

by Ed Chen
December 21, 2019December 25, 2019

ORA-01017 in Database Links Let's me show you how I reproduce ORA-01017 when connecting to a remote database via a database link, then I will… Read More »

How to Avoid PassPhrase Dialog

by Ed Chen
December 14, 2019December 19, 2019

If you have ever provided a passphrase while creating a private key for SSL configuration, then you are required to enter passphrase every time restarting… Read More »