messed up my listener :(
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: messed up my listener :(

  1. #1
    Join Date
    Feb 2007
    Posts
    212

    messed up my listener :(

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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.

  3. #3
    Join Date
    Feb 2007
    Posts
    212
    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
    Last edited by jennifer2007; 05-21-2007 at 05:06 AM.

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    SPFILE dear,
    just remove it from the SPFILE, as long as the listener listens at 1521 port

    Regards

  5. #5
    Join Date
    Feb 2007
    Posts
    212
    thanks hun

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width