Administration

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

How Oracle Check Startup Time

by Ed Chen
September 17, 2021September 17, 2021

To check Oracle database startup time, we have to know the difference between instance startup time and database open time. Additionally, we also check the… Read More »

How to Resolve "No ADR base is set"

by Ed Chen
August 25, 2021October 10, 2021

No ADR base is set To manage Automatic Diagnostic Repository (ADR), we used to use ADRCI command line to interact with server. [oracle@primary01 oracle]$ adrci… Read More »

How to Resolve ORA-09925 Error Message

by Ed Chen
August 20, 2021October 3, 2021

ORA-09925: Unable to create audit trail file There're two error scenarios of ORA-09925 in this post, one is for single-instance databases, the other is for… Read More »

How to Resolve ORA-01149: cannot shutdown - file 1 has online backup set

by Ed Chen
July 7, 2021August 2, 2021

ORA-01149 ORA-01149 means that some data files are in backup mode, so you can't shutdown the database in this moment. SQL> shutdown immediate; ORA-01149: cannot… Read More »

How to Resolve ORA-20005: object statistics are locked (stattype = ALL)

by Ed Chen
June 19, 2021August 27, 2021

ORA-20005 When we tried to gather some statistics on a table which has never been analyzed, we saw ORA-20005 like this: SQL> exec dbms_stats.gather_table_stats(ownname =>… Read More »

How to Change NLS_LENGTH_SEMANTICS Temporarily

by Ed Chen
May 19, 2021March 23, 2021

NLS_LENGTH_SEMANTICS Let's see what NLS_LENGTH_SEMANTICS of the database currently set. SQL> conn hr/hr@orclpdb Connected. SQL> show parameter semantics; NAME … Read More »

How to Tell What State of Database

by Ed Chen
February 10, 2021February 3, 2021

We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »