Today i face this issue after Oracle 11g upgrade and posting it for you as it is.
Problem:
The local_listener parameter has been set, the listener is running, but when attempting to start the instance an ORA-00119 is reported:
SQL*Plus: Release 11.2.0.2.0 Production on Fri Sep 28 11:34:29 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_SID
Reason :
Oracle only checks for listeners running on the default port (1521). It would have to spend all day trying every possible port number otherwise. You’ll need to give it some help to find your listener.
Solution:
Simply add an entry to the servers tnsnames.ora pointing at the listener. As mention below
LISTENER_SID.WORLD=
(DESCRIPTION =
tnsping LISTENER_SID.WORLD
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.2.0 – Production on 28-SEP-2012 13:13:36
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
/oracle/SID/112_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 2768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = sidb00) (PORT = 1527))) (CONNECT_DATA = (SID = SID) (GLOBAL_NAME = SID.WORLD)))
OK (20 msec)
Now it is working. Also wana add one more point.
make sure that parameter by name *.local_listener=’LISTENER_SID’ in pfile as it is mention.
I Hope this article helped to you. I am expecting your suggestions/feedback.
It will help to motivate me to write more articles….!!!!
Thanks & Regards,
Samadhan
https://samadhandba.wordpress.com/
“Key for suceess, always fight even knowing your defeat is certain….!!!!
samadhandba 