Monday, March 27, 2023

too many TNS-01182 errors reported after creating a Standby DB


The following error started to come frequently in the listener's log after the creation of a standby DB for the same DB:

 TNS-01182: Listener rejected registration of service ""


I've found that the local listener parameter was already configured on the primary DB and hence after the duplication of the standby the value of LOCAL_LISTENER parameter in the Standby was pointing to the Primary server IP, the thing which keep triggering TNS-01182 errors on the Primary server side.


Set the LOCAL_LISTENER parameter to point to the local IP of the Standby server, e.g. if the standby server IP is then the LOCAL_LISTENER value should be set to:

SQL> alter system set LOCAL_LISTENER='(ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))';

No comments:

Post a Comment