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

Thread: TNS Could not resolve service name

  1. #1
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    I am not able to connect to database from the client. When I check with tnsping SID, it is ok. But when I try to login from sqlplus, it shows me the following error:

    ORA-12154: TNS:could not resolve service name

    What could be the problem?
    Agasimani
    OCP(10g/9i/8i/8)

  2. #2
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    Make sure the tnsnames.ora and listener.ora files have an entry for the database your trying to connect to (you may have to restart the listener to pick up the new config.

    Cheers

    Moff.

  3. #3
    Join Date
    Dec 2000
    Posts
    10
    Hello,

    Do you have 2 or more oracle version on your server? If yes, maybe your application don't use the good tnsname.ora.

    Regards,
    Steph.

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