problem connecting to a 9i db with a 10g client
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: problem connecting to a 9i db with a 10g client

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    problem connecting to a 9i db with a 10g client

    I have a 9i database and I am trying to connect with a 10g client and am not able to. When I launch sqlplus and try to log in I get an ORA12154: TNS could not resolve the connect identifier specified. when I go through the Local Net Service naming configuration wizard to set the service name I test them and the test succeeds. but then when I try to log in with sqlplus I get the error. Any advice?

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Yes dear....u have to copy the updated tnsnames.ora to all the OracleHOmes directory under the network/admin forder your
    sqlplus is not pointing to the right home, i guess.

  3. #3
    Join Date
    Mar 2005
    Posts
    143
    I only have 1 oracle home. and the tnsnames.ora file is in the orahome\network\admin directory.

  4. #4
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Try to search the word tnsnames.ora in ur pc

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