Re: Remote connection failure

From: Henk Jan Barendregt <hjb_at_xs4all.nl>
Date: Sat, 02 Jun 2001 05:58:59 +0100
Message-ID: <3B187293.D5056E41@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 Fri Jun 01 2001 - 23:58:59 CDT