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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.