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.
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.
Click Here to Expand Forum to Full Width