Today i face this issue after Oracle 11g upgrade and posting it for you as it is.
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 18.104.22.168.0 Production on Fri Sep 28 11:34:29 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
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
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.
Simply add an entry to the servers tnsnames.ora pointing at the listener. As mention below
TNS Ping Utility for IBM/AIX RISC System/6000: Version 22.214.171.124.0 – Production on 28-SEP-2012 13:13:36
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
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,
“Key for suceess, always fight even knowing your defeat is certain….!!!!