Re: Problem connecting to Ora 7.3.4 from 8.0.5

From: Andrew Basson <RCav8_at_iafrica.com>
Date: Fri, 15 Oct 1999 08:19:40 +0200
Message-ID: <7u6h6u$1oa6$1@nnrp01.ops.uunet.co.za>

Hi Helen,

I'm not sure if we are running SQL*Net 2 on the Ora 8 server. I will check this.

I can connect to the Ora7 server using Net8 from a winNT client.

I am using TCP/IP, and the tnsping for the "alias" works great.

Thanks for the advice. Andrew.

Helen Macduff <Helen.Ward_at_alcatel.com.au> wrote in message
news:38068648.317CB22_at_alcatel.com.au...

> It shouldnt be a oracle problem. I assume you are using TCP/IP as the
> underlying protocol to sqlnet. Are you running SQLNET 2 on both
> machines.
>
> The entry in the tnsnames.ora file is an alias.
>
> You should try tnsping 'alias from tnsnames.ora'
> then from within sqlplus connect 'valid user on oracle7'@'alias from
> tnsnames.ora'
> you would then be prompted for the password
>
>
Received on Fri Oct 15 1999 - 01:19:40 CDT