messed up my listener :(

[jennifer2007]

Hi Friends,

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.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
SQL> exit
Disconnected
=========================

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.

Thanks

[davey23uk]

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.

[jennifer2007]

I'm confused dear where do I add it? in spfile or listener.ora or
tnsnames.ora


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
entry:

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora_db)(PORT = 1521))
(CONNECT_DATA =
(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

Thanks

[Bore]

SPFILE dear,
just remove it from the SPFILE, as long as the listener listens at 1521 port

Regards

[jennifer2007]

thanks hun