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