Where is DBCA Log Location
DBCA Log Location Two locations that you can see the trace log of Database Configuration Assistant (DBCA). DBCA log location The file path and name… Read More »Where is DBCA Log Location
ORACLE_SID
How to Resolve TNS-01201: Listener cannot find executable
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 »How to Resolve TNS-01201: Listener cannot find executable
How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
ORA-12505 ORA-12505 means that the SID you provided in the connect identifier does not match any SID registered with the listener. Basically, SID means $ORACLE_SID,… Read More »How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database
In previous post, we have talked about how to change DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about how to change… Read More »How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database
How to Change DB_UNIQUE_NAME of a Single-Instance Database
In previous post, we have talked about how to change DB_NAME of a single-instance database. In this post, we will talk about how to change… Read More »How to Change DB_UNIQUE_NAME of a Single-Instance Database
How to Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.
ORA-39195 ORA-39195 means that tables that you want to export does not exist in the current database, even though you qualify exported tables by schema… Read More »How to Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.
Connect to PDB as SYSDBA by ORACLE_PDB_SID
Connect as SYSDBA We usually connect to the database by / as SYSDBA without providing any password for maintenance works, such as startup, shutdown and… Read More »Connect to PDB as SYSDBA by ORACLE_PDB_SID
How Srvctl Stop Database
There're 4 levels that can stop a RAC database, each level has different effect on the RAC system. As for stopping a single-instance database, it… Read More »How Srvctl Stop Database
SHUTDOWN IMMEDIATE Hangs
SHUTDOWN IMMEDIATE Shutdown immediate may not go smoothly as you thought, it could seem to be stuck in an infinite waiting. If you wait and… Read More »SHUTDOWN IMMEDIATE Hangs
How to Resolve SPFILE in DB_UNKNOWN
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN… Read More »How to Resolve SPFILE in DB_UNKNOWN