Thursday, October 10, 2013

ORA-12514: TNS:listener does not currently know of service

Error: ORA-12514: TNS:listener does not currently know of service

Possible Cause:The database might not have been registered with a listener

Diagnosing the error:The following things should eb done to diagnoze the error
  1. Check what listener is running:
    > lsnrctl status
    
  2. Check LOCAL_LISTENER parameter
    SQL> show parameter local_listener
    
    Usually it is blank by default and thus at startup the database is dynamically registered with the listener that is currently running. If LOCAL_LISTENER does have a value, then it means that database is trying to register with the configuration of the listener listed in LOCAL_LISTENER

Possible Solution:Clearing the value of LOCAL_LISTENER:


SQL> alter system set local_listener='';
SQL>lsnrctl reload
or

SQL> alter system set local_listener='' scope=both sid='*';
SQL>lsnrctl reload

No comments:

Post a Comment