Re: Problem connecting to Ora 7.3.4 from 8.0.5

From: Helen Macduff <Helen.Ward_at_alcatel.com.au>
Date: Fri, 15 Oct 1999 11:41:28 +1000
Message-ID: <38068648.317CB22@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

Andrew Basson wrote:
>
> Hi,
>
> I am trying to connect to an Ora 7 server (on SCO/UNIX) from our Ora 8 (on
> RH6.0) server using sqlplus. I have added an entry for the server and sid in
> the Ora 8's tnsnames.ora file, and whenever I try to connect to the Ora 7
> box I get a TNS 12125 Error - can't resolve service name.
>
> Is there a known problem connecting to Ora7 from Ora8 clients/servers?
>
> tnsping from Ora8 to Ora7 works fine.
>
> TIA, Andrew
Received on Thu Oct 14 1999 - 20:41:28 CDT