SID_LIST_LISTENER

How to Resolve ORA-12526: TNS:listener: all appropriate instances are in restricted mode

by Ed Chen
November 17, 2021June 11, 2022

ORA-12526 When we tried to connect to the database, it failed with ORA-12526 like the following. SQL> conn hr/hr@orcl ERROR: ORA-12526: TNS:listener: all appropriate instances… Read More »

How to Resolve TNS-01201: Listener cannot find executable

by Ed Chen
October 11, 2021June 8, 2022

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

by Ed Chen
January 23, 2019February 13, 2023

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 to Configure SID_LIST_LISTENER Static Listener

by Ed Chen
August 3, 2018December 11, 2022

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 to Add a Standalone Listener on Second IP to Grid

by Ed Chen
December 25, 2016August 5, 2020

Suppose you have added a second IP on OS. You want a second listener to listen port 1521 of the new IP address for the… Read More »

How to Resolve The listener supports no services

by Ed Chen
November 5, 2016January 17, 2023
34 Comments

The listener supports no services Let's see the current status of listener. [oracle@primary01 ~]$ lsnrctl status ... Listener Log File /u01/app/oracle/diag/tnslsnr/primary01/listener/alert/log.xml… Read More »

How to Create a 9i Database by DBCA with Silent Mode

by Ed Chen
December 3, 2012February 8, 2023

In my experience, to create a new database by DBCA with silent mode in a 9i database on Linux, you must issue the dbca command… Read More »

Building a Physical Standby Database (02/14) - Prepare configuration files on both sides

by Ed Chen
November 14, 2012February 13, 2023

Building a Physical Standby Database (01/14) - Install an empty database on standbyThere are four configuration files needs to be prepared on both sides, the… Read More »

How to Connect Idle, Nomount or Restricted Database Remotely

by Ed Chen
October 10, 2012December 11, 2022

Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »