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.
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