ORACLE_SID

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 »

How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect

by Ed Chen
March 20, 2021September 24, 2021

ORA-12505 Before migrating to a multitenant environment, some users used to use SID to connect to the source database. The connect identifier may look like… Read More »

How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 23, 2021January 24, 2021

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 DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 20, 2021July 12, 2021

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 Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.

by Ed Chen
December 23, 2020March 16, 2021

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 Connect a PDB Directly by OS Authentication

by Ed Chen
December 23, 2020March 26, 2021

OS Authentication We usually connect to the database by / AS SYSDBA without providing any password for maintenance works, such as startup, shutdown and backup.… Read More »

SHUTDOWN IMMEDIATE Hangs

by Ed Chen
September 4, 2019October 1, 2021

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 »

How to Resolve SPFILE in DB_UNKNOWN

by Ed Chen
June 23, 2019September 29, 2021

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 Move ORACLE HOME

by Ed Chen
January 23, 2019October 10, 2021

Allow me to ask you a question before going further: why would you like to move ORACLE HOME to another place? You may leave your… Read More »

How Listener Configure SID_LIST_LISTENER

by Ed Chen
August 3, 2018September 19, 2021

SID_LIST_LISTENER Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service… Read More »