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:
- Check the TNSADMIN parameter is set or point to correct location.
- Remove the tnsnames.ora entry for scan listener (note: first backup the tnsnames.ora, sqlnet.ora or listerner.ora file)
- 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;