TNSPING works, SQLPLUS does not
Posted on 2007-11-13
Trying to get a client to have access to a new remote database we have set up. Same TNSNAME.ORA and SQLNET.ORA has been provided to over 100 clients and all have been abel to connect , except 1.
They can execute a TNSPING but get an ORA-12154 when using SQLPLUS.
I had him installed 10G Client Runtime ( he mistakenly started to install Instant Client). He previously had Oracle 8 Client.
I had him copy the same TNSNAMES.ORA file to all of his NETWORK/ADMIN directories - still did not work.
I had remove all of the other copeis and it still did not work.
I can connect using his UID/PWD from my machine so I know the database and listener are fine.
What shoudlI have him look for on his machine?