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

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

Threaded View

  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 08:11 AM. Reason: forgot something

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