ORA-00119: invalid specification for system parameter LOCAL_LISTENER
Today morning, when i tried to startup our production database, it shows following errors
SQL> STARTUP
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BROKER’
I was struggled with these erros and finally i was fixed this errors with help of Mr.Surachart opun http://surachartopun.com . He given solutions and fixed easily. Thanks Mr.Surachart.
How was i did it?
My tnsnames file :
BROKER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BROKER)
)
)
and My listener.ora file.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress )(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
and now i tired to startup my db, the below error shown.
SQL> STARTUP
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BROKER’
So i fixed in tnsnames.ora file and then now its working.
LISTENER_BROKER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BROKER)
)
)
After i fixed this listener_broker in tnsnames.ora file, the database up sucessfully.
SQL> STARTUP
ORACLE instance started.
Total System Global Area 1912602624 bytes
Fixed Size 2005192 bytes
Variable Size 369100600 bytes
Database Buffers 1526726656 bytes
Redo Buffers 14770176 bytes
Database mounted.
Database opened.
SQL> select name from v$database;
NAME
———
BROKER
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BROKER’
This mean you use LOCAL_LISTENER=’LISTENER_BROKER’
So, First Step – you have to check LISTENER_BROKER(network name) in tnsnames.ora file
and Syntax…
-)
Thanks Sir.I agreed your comment.Sure, we want to check first in tnsnames.ora file.
it works man, thanks
Well, Thanks.
please tell me what i am doing wrong:
tnsnames.ora:
LISTENER_BID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bid01 )(PORT = 1527))
)
(CONNECT_DATA =
(SERVICE_NAME = bid01)
)
)
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = BID)
(ORACLE_HOME = ORACLE_HOME = I:\oracle\BID\102)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bid01 )(PORT = 1527))
(ADDRESS = (PROTOCOL = IPC)(KEY = BID))
(ADDRESS = (PROTOCOL = IPC)(KEY = BID.WORLD))
)
)
still getting:
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BID’
SQL>
??
thanks in advance
Thank you, its was a useful for me as well
hi sir iam getting error pls give solution
Hi Guys ! ..
The solution is mentioned in the error only ..
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BID’
Question is —– you are getting above error
Answer is ——Just Change the name in your connect discriptor to be called by LISTENER_BID only.
that will resolve your problem.
$tnsping LISTENER_BID
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.9)(PORT = 2222)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = BID)))
OK (0 msec)
$BID-SYS>startup
ORACLE instance started.
Total System Global Area 608174080 bytes
Fixed Size 1220844 bytes
Variable Size 171970324 bytes
Database Buffers 432013312 bytes
Redo Buffers 2969600 bytes
Database mounted.
Database opened.
BID-SYS>
OoooH Thanksss