-
Hi all,
I am unable to connect to the Oracle server from a client. I am able to use SQL Plus in the server. But unable to connect from a client machine.
I get an error ORA-12545: Connect failed because target host or object does not exist
Can any of you help? I tried restarting the server. I thought there would be some network problem and so the host couldn't be found. But when I stop the listener I get the error No listener.. so the server is being addressed properly. The port is also right... I couldn't figure out any reason...
Help of any level would be greatly appreciated....
Thanks in advance...
Nandu
-
Check the tnsnames.ora file on your client machine to see whether it had been configured correctly.
Then try
tnsping servicename
then
sqlplus username/password@servicename
Sam