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
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 Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
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
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
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.
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 »How to Connect a PDB Directly by OS Authentication
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 »How Listener Configure SID_LIST_LISTENER