Ed Chen Logic - To Make My Logic More Logical

How to Resolve ORA-44305: service is running

by Ed Chen
October 18, 2021September 17, 2021

ORA-44305 Tried to delete a service from the database, but it failed with ORA-44305. SQL> exec dbms_service.delete_service('ERPAPP2'); BEGIN dbms_service.delete_service('ERPAPP2'); END; * ERROR at line 1:… Read More »

How to Resolve ORA-65000: missing or invalid pluggable database name

by Ed Chen
October 15, 2021October 11, 2021

ORA-65000 Tried to close a pluggable database (PDB) and got error ORA-65000. SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter pluggable database close immediate; alter… Read More »

How to Resolve ORA-44786: Service operation cannot be completed

by Ed Chen
October 13, 2021October 13, 2021

ORA-44786 There're several error patterns about ORA-44786 when we operate on a service in a pluggable database (PDB). Stop Service Start Service A. Stop Service… Read More »

How to Resolve TNS-01201: Listener cannot find executable

by Ed Chen
October 11, 2021October 13, 2021

TNS-01201 After adding a static service to the local listener, I tried to start the listener, but it failed with TNS-01201. [oracle@test ~]$ vi $ORACLE_HOME/network/admin/listener.ora… Read More »

Correct Ways to Add Logfiles

by Ed Chen
October 8, 2021August 31, 2021

ALTER DATABASE ADD LOGFILE clause has two different functions, one is to add a new member to an existing group, the other is to create… Read More »

How to Resolve ORA-00357: too many members

by Ed Chen
October 6, 2021October 7, 2021

ORA-00357 Tried to add more member to an existing group, but it failed with ORA-00357. SQL> alter database add logfile member '+DATA/ORCLCDB/redo01g.log' to group 1;… Read More »

How to Resolve ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

by Ed Chen
October 4, 2021October 17, 2021

ORA-00245 Tried to create a standby controlfile from a RAC database, but it failed with ORA-00245 or ORA-245. [oracle@primary01 ~]$ sqlplus / as sysdba ...… Read More »

PuTTY Security Alert - Save or Replace Server Host RSA Key

Where is PuTTY Repository

by Ed Chen
October 1, 2021October 17, 2021

PuTTY Security Alert I guess you may have seen this alert like the above featured image while you were connecting to a server for the… Read More »

How to Resolve ORA-38707: Media recovery is not enabled

by Ed Chen
September 29, 2021October 17, 2021

ORA-38707 Tried to enable flashback of whole database, but it failed with ORA-38706 and ORA-38707. SQL> alter database flashback on; alter database flashback on *… Read More »

How to Resolve ORA-02065: illegal option for ALTER SYSTEM

by Ed Chen
September 27, 2021October 17, 2021

ORA-02065 Some may try to enable archivelog mode like the followings, but it failed with ORA-02065: SQL> alter system archivelog; alter system archivelog … Read More »