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

Thread: Connection Problem

  1. #1
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    I have Oracle8i server. and oracle 7.3 client, I'm having problem connecting to server from SQL*PLUS I get following ERROR

    ERROR: ORA-12154: TNS:could not resolve service name

    I Know username/password and Service name is correct. I can go to server machine and login using same information.

    Please help what could be wrong.

    Thanks in Advance.

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    You "can connect from server" is not exactly same as "connecting from client"; You use two different sets of tnsnames.ora in these cases.

    Make sure your client machine's tnsnames.ora has the same entry (for the 8i database) as the server itself.

    Also check that you don't have multiple copies of tnsnames.ora on your client machine.

    - Rajeev

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