messed up my listener :(
I have installed previously 2 databases in my WIN2003 SERVER, an XE, and ORCL(10GR2EE) and
the default listener was pointing to XE home. Now, I deinstalled XE db
and reconfigure/edit my listener to point to ORCL HOME. But when I tried to
restart my ORCL db...i got this error:
C:\Documents and Settings\Administrator.BI-NET>sqlplus sys/oracle as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 21 10:47:46 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
I forgot what line did i replace this LOCAL_LISTENER 'LISTENER_ORCL'
in my listener.ora. Can u help me the correct syntax of this parameter pls.
the local_listener parameter in the database isnt a valid one, either remove it or add an entry in the tnsnames file for that that.
I'm confused dear where do I add it? in spfile or listener.ora or
ORA-00132: syntax error or unresolved network name 'string'
Cause: Listener address has syntax error or cannot be resolved.
Action: If a network name is specified, check that it corresponds to an entry in TNSNAMES.ORA or other address repository as configured for your system. Make sure that the entry is syntactically correct.
I believe the network name is specified, and this this my tnsnames.ora
(ADDRESS = (PROTOCOL = TCP)(HOST = ora_db)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.world)
I believe i deleted some lines here that specified my LOCAL_LISTENER=LISTENER_ORCL and
I dont know how to return it back and what is the right syntax. Can u help me with the syntax pls
Last edited by jennifer2007; 05-21-2007 at 05:06 AM.
just remove it from the SPFILE, as long as the listener listens at 1521 port
Click Here to Expand Forum to Full Width