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

 Problem:

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 ""
 

Analysis:

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.

Solution:

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

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