Try tnsping instance_name and see if that works.
If not check whether you can connect to the remote server from the os.
Check your tnsnames.ora file to make sure that the remote instance is listed
with the proper port number, host name , instance name and global name...
--
Ravi Alluru
Independent IS Consultant
796299 Alberta LTD
PH (403) 298-4805
Cell (403)607-8568
mailto:ravica_at_quixnet.net
"Henk Jan Barendregt" <hjb_at_xs4all.nl> wrote in message
news:3B17F031.5B081103_at_xs4all.nl...
> Hi,
>
> When i try to connect to the oracle server from a remote
> host using sqlplus i get the following error.
>
> ERROR:
> ORA-12154: TNS: could not resolve service name
>
> Network services have been setup and there is a listener
> running on the server.
>
> On the client (SparcStation) i have installed the client
> software an configured the connection. netasst picks up
> the server checked the login without problems.
> thats it. sqlplus still fails to get a connection.
> Any help ?
>
>
> regards,
>
> Henk Jan
Received on Fri Jun 01 2001 - 17:15:16 CDT
