Home » Infrastructure » Linux » error ORA:00119 and ORA:00132
error ORA:00119 and ORA:00132 [message #241658] Wed, 30 May 2007 05:54 Go to next message
sushmi
Messages: 6
Registered: May 2007
Junior Member
I am getting the errors while starting up my database using command 'STARTUP'

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'SANE'

To troubleshoot it, i checked my both listener.ora and tnsnames.ora but could not find any error

Content of listener.ora
# listener.ora Network Configuration File: /database/oracle10g/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /database/oracle10g)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = server.sushmi.com)(PORT = 1522))
)
)


And content of tnsnames.ora

SANE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1522))
)
(CONNECT_DATA =

(SERVICE_NAME = sane)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
And in file 'initsane.ora' parameter LOCAL_LISTENER=SANE

Please help me in the matter i could not think more than this..
Re: error ORA:00119 and ORA:00132 [message #241664 is a reply to message #241658] Wed, 30 May 2007 06:15 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Check this thread on OTN

Re: error ORA:00119 and ORA:00132 [message #468524 is a reply to message #241658] Fri, 30 July 2010 09:30 Go to previous message
vickyfin
Messages: 1
Registered: May 2010
Location: Atlanta
Junior Member

Hey..just check your init<SIDNAME>.ora file you will see a parameter LOCAL_LISTENER so just remove it or else add the new listener path to that parameter this will work. Thanks Razz
Previous Topic: Installing Oracle 10g R2 on RHEL 5
Next Topic: virtual Server configuration in Linux
Goto Forum:
  


Current Time: Thu Mar 28 08:33:50 CDT 2024