Re: Remote connection failure

When using SQLNET you must connect to the tns alias not ths SID.

Try
tnsping HENKJAN.BARENDREGT

Stephen C. Ashmore
Brainbench MVP for Oracle Administration

"Henk Jan Barendregt" <hjb_at_xs4all.nl> wrote in message news:3B187293.D5056E41_at_xs4all.nl...
> TurkBear wrote:
> >
> > 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;
>
> The connection with the server is ok.
> but tnsping cannot resolve the name. I used:
>
> $ tnsping oralin
>
> The contents of the tnsnames.ora is as follows:
>
> # TNSNAMES.ORA
> ConfigurationFile:/export/home/OraHome/network/admin/tnsnames.ora
> # Generated by Oracle Net8 Assistant
>
> HENKJAN.BARENDREGT =
> (DESCRIPTION =
> (SOURCE_ROUTE = OFF)
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = server.barendregt)(PORT =
> 1521))
> )
> (CONNECT_DATA =
> (SID = oralin)
> )
> )
>
>
>
>
> Thanks in advance,
>
> Henk Jan
Received on Sat Jun 02 2001 - 04:02:22 CDT