Monday, November 3, 2014

Possible Reasons for “TNS-01182: Listener rejected registration of service”

Symptom:

03-NOV-2014 20:26:02 * service_register_NSGR * 1182
TNS-01182: Listener rejected registration of service ""

Possible Reasons:

1. VALID_NODE_CHECKING_REGISTRATION_listenername=ON (By default All remote registrations will fail)

2. REGISTRATION_INVITED_NODES_listenername or REGISTRATION_EXCLUDED_NODES_listenername is in use

3. DYNAMIC_REGISTRATION_listenername is off

For example:

DYNAMIC_REGISTRATION_LISTENER=OFF