Dynamic service fail to register the Scan Listener in RAC

Dynamic registration failed for Scan Listener in Oracle RAC Environment

If dynamic service is failed to register the scan listener then you follow the following steps to try the registration:

  1. Check the TNSADMIN parameter is set or point to correct location.
  2. Remove the tnsnames.ora entry for scan listener (note: first backup the tnsnames.ora, sqlnet.ora or listerner.ora file)
  3. Set the following entry in SQLNET.ORA file and need to restart the instance & listener so that PMON read first SQLNET.ora file for dynamic registration.
NAMES.DIRECTORY_PATH=(EZCONNECT,TNSNAMES)

4. If dynamic registration is not work, then create a manual entry in tnsnames.ora file for scan listener and set the REMOTE_LISTENER parameter on all nodes. Then fire the command alter system register for registration.

-- Make an entry in tnsnames.ora file of each node for scan listener:

DB_LISTENERS_SCAN=
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.01)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.02)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.03)(PORT = 1521))
    )

--- Update the remote_listener parameter point to scan listener for each node:

SQL>Alter system set REMOTE_LISTENER='DB_LISTENERS_SCAN' scope=both sid='*';
SQL>Alter system register;

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply