Wednesday, 17 February 2016

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

While i am trying to bring up the database i am getting below error.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_DATABASE''
SQL> exit

DB environment: Oracle database 11.2.0.4 . Standalone database

There are few possible reason for the error.:

      1.If  your database is running with default listener i.e LISTENER and you set            LOCAL_LISTENER . Since you're using only one default listener you don't need to have local_listener set. Hence, you can remove the local_listener entry from your pfile/spfile initialization parameters and re-start your listener.

       2. You configured a listener and that is not the default listener. You have set the same local     listener  entry details in the PFILE/SPFILE but the same local listener entry is not added in the TNSNAMES.ORA file. Please add the below details in the tnsnames.ora files.

LISTENER_DATABASE =
 (ADDRESS = (PROTOCOL = TCP)(HOST = zwdtoralin1)(PORT = 1523))

3.There are more than one listener is running in your database server  and your current
 database is pointing to other listener . Check the profile and update the correct TNS_ADMIN location . So the database will connect the correct listener .






No comments:

Post a Comment