Skip to content

Archive for

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

Follow

Get every new post delivered to your Inbox.

Join 139 other followers