TNS:could not resolve the connect identifier-ORA-12154
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TNS:could not resolve the connect identifier-ORA-12154

  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Exclamation TNS:could not resolve the connect identifier-ORA-12154

    Hello everybody,

    This is my problem:
    We create in oracle 10g a database with tablespace and dbf all as TEST
    In the Microsoft ODBC administrator odbcad32:

    We have set this:
    System DSN:
    the driver: oracle 10g driver
    data source name: Test_DSN
    Description:test Database
    Server Name:TEST
    Client version: 10gR1 and later

    When we test the Connection whit this:
    Server Name:TEST
    user:system
    pass:sadmin
    (sadmin is the default pass for the database TEST)
    the user System is activated and has sadmin set as password.

    We get this error:
    'ORA-12154: TNS:could not resolve the connect identifier specified'

    We checked the following:
    tnsnames.ora contain this line:
    Test =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.151...)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = Test)
    )
    )

    We cannot find the problem.
    NB: we can connect with success using toad, we give this information:
    user :system
    pass:sadmin
    database:TEST

    Thanks for helping us, as we are waiting now, and time is running up.

    Oracle_user.
    Last edited by Oracle_user; 03-18-2009 at 09:11 AM. Reason: forgot something

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    your tnsnames file is wrong, or you have edited the wrong one

  3. #3
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    The driver could not find tnsnames.ora or could not find the alias in the tnsnames.ora. Most common reasons:
    - multiple oracle homes e.g. for the database and for the client (use ora home selector in ora SW menu to select the right one or put the alias to both the files )
    - wrong ORACLE_HOME set (check the registry)
    - tnsnames.ora in a wrong location (must be %ORACLE_HOME%/network/admin)
    - the TNS_ADMIN environment variable set (unset or set to the directory with tnsnames.ora)
    - the NAMES.DEFAULT_DOMAIN parameter set in the sqlnet.ora file (unset)
    Ales
    The whole difference between a little boy and an adult man is the price of toys

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