DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: messed up my listener :(

Threaded View

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

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