Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    6

    Unanswered: TNS error - seems odd !!

    Hi,

    I am facing a very peculiar situation. I am trying to connect to an Oracle database using the following TNS entry:

    DBXYZ =(DESCRIPTION =
    (ADDRESS_LIST =(ADDRESS =(COMMUNITY=TCP)(PROTOCOL=TCP)
    (Host=dbxyz.idc.org)(Port = 1521)
    ) )
    (CONNECT_DATA =(SID=DBXYZ)(ORACLE_HOME=/opt02/DBXYZ/oracle/product/8.1.7)
    ))

    I get the following error when I try to connect through TOAD/SQLPLUS:

    ORA-12154: TNS:could not resolve service name


    But whats so odd about this is that I am able to connect to the database using the same tns entry from a different machine.

    Any help is very much appreciated.

    Thanks!
    Last edited by machodude24; 05-08-07 at 05:06.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    How does your SQLNET.ORA looks like (compared to a different machine SQLNET.ORA)?

Posting Permissions

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