Re: Remote connection failure

The tnsnames.ora file on the client must have an error in it.. try tnsping to see if it resolves the alias correctly.. To really assist you, we need to see your tnsnames.ora file ( you can 'phony-up' the actual IP address stuff), but it helps to see what you have set up;

Henk Jan Barendregt <hjb_at_xs4all.nl> wrote:

>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 - 14:13:39 CDT