TNS could not resolve service name on Mac OS X [message #54088] |
Tue, 29 October 2002 02:09 |
Goryan
Messages: 2 Registered: April 2002
|
Junior Member |
|
|
Hi,
I have installed Oracle9i on Mac OS X. When I try to
connect using SQL*Plus to some remote DB it sayas
Could not resolve service name, but when I try the TNS
Ping it resolves the service name OK and it pings ok.
Why is this? tnsping ok, but sqlplus cannot resolve
the service name?
Thanx!
|
|
|
Re: TNS could not resolve service name on Mac OS X [message #54090 is a reply to message #54088] |
Tue, 29 October 2002 05:12 |
B
Messages: 327 Registered: August 1999
|
Senior Member |
|
|
tnsping just check if the entry of the tns is valid...
U should verify that's the remote listener is up ... that u 're using the right port with the right protocol.
Connect to remote server and connect to the database using sqlplus user/db@db
if it works copy the entry of the tns to ur own server
|
|
|