Home » RDBMS Server » Server Administration » TNS could not resolve service name on Mac OS X
TNS could not resolve service name on Mac OS X [message #54088] Tue, 29 October 2002 02:09 Go to next message
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 Go to previous message
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
Previous Topic: Different Users, Same Schema, Different Data
Next Topic: password file "pwd got corrupted"
Goto Forum:
  


Current Time: Fri Sep 20 04:37:25 CDT 2024