TNS connectivity problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: TNS connectivity problem

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    TNS connectivity problem

    Hi,
    I have problems connecting to the Oracle8i (8.1.0) server from oracle 8 (8.0.2) client.

    I am getting the error ORA-12154 TNS could not resolve service name.


    My tnsnames.ora on client is as following
    --------------------------------

    DEV1.SSS.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = SERVER-SSS)
    (PORT = 1521)
    )
    )
    (CONNECT_DATA = (SID = DEV1 )
    (GLOBAL_NAME = DEV1.SSS.COM)
    )
    )


    My listener.ora looks like this
    --------------------------------

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION=
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST=SERVER-SSS)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = DEV1.SSS.COM)
    (ORACLE_HOME = C:\oraHome8i)
    (SID_NAME = dev1)
    )
    )


    Is there anything else that i have to take care of when i am accessing 8i from 8 client.

    TNSPING80 Resolves; but the connection from sqlplus throws the error ORA-12154
    Last edited by bang_dba; 12-02-2003 at 05:47 AM.

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    What "Host String" are you using for sqlplus?

    Do you have NAMES.DEFAULT_DOMAIN set in sqlnet.ora on the client? That will be appended to the "Host String" if it does not contain a '.'

  3. #3
    Join Date
    Sep 2002
    Posts
    376
    Hi dapi,
    I have commented the NAMES.DEFAULT_DOMAIN

    and i am using the whole connect string.

    sql>connect abc/abc@DEV1.SSS.COM

  4. #4
    Join Date
    May 2002
    Posts
    2,645

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