| error ORA:00119 and ORA:00132 [message #241658] |
Wed, 30 May 2007 05:54  |
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..
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
