Skip to content
Advertisements

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

Advertisements
10 Comments Post a comment
  1. 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…

    -)

    April 4, 2010
    • Thanks Sir.I agreed your comment.Sure, we want to check first in tnsnames.ora file.

      April 4, 2010
  2. cesar #

    it works man, thanks

    November 22, 2010
  3. peter #

    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

    February 18, 2011
  4. Ravi Kumar #

    Thank you, its was a useful for me as well

    June 19, 2011
  5. error:ora-00119: invalid specification for system parameter LOCAL_LISTENER #

    hi sir iam getting error pls give solution

    June 3, 2012
  6. mir mohd ali #

    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>

    October 13, 2014
  7. Romulo #

    OoooH Thanksss

    September 11, 2015

Trackbacks & Pingbacks

  1. 2010 in review « DBA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: