Re: SQLNet for Linux cannot connect at Oracle7 instance

Hi,
1. Oracle 7 uses sql*net and on the client reads a file

   c:\oracle_home\network\admin\tnsnames.ora to see the SID, port etc. 2. Oracle 8 uses net8 and on the client reads a file

   c:\oracle_home\net80\admin\tnsnames.ora to see the same stuff. 3. All you have to do is rename tnsnames.ora in

   c:\oracle_home\net80\admin\ to tnsnames.old and copy the file from    the other directory ( c:\oracle_home\network\admin\tnsnames.ora) into    c:\oracle_home\net80\admin\.
This is because your SID,HOST,PORT etc is in the network directory and oracle 7 sqlplus goes and looks there but your oracle 8 client looks for the SID etc in the net80 directory. Therefore you need to replicate the entry from network directory to net80 directory (we're doing this by copying the file there.
Do let me know when it works.
All the best
Vijay
In article <3847CBAA.2F558981_at_adr.it>,
  Francesco Dini <dini.f_at_adr.it> wrote:
> I have installed Oracle Client and SQLNet 8 on my Linux Red Hat 6.1
> Red Hat Linux release 6.1 (Cartman)
> Kernel 2.2.12-20 on an i586
>
> but I can connect only at Oracle8 Server while if I try to connect at
> Oracle7 I obtain the ORA-12545 error. Note that tnsping respond well:
>
> @smc-test.adr.it:/oracle->> tnsping chsa
>
> TNS Ping Utility for Linux: Version 8.0.5.0.0 - Production on
03-DEC-99
> 11:59:29
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Attempting to contact
> (ADDRESS=(PROTOCOL=TCP)(Host=10.10.1.4)(Port=1521))
> OK (100 msec)
> @smc-test.adr.it:/oracle->>
> @smc-test.adr.it:/oracle->> sqlplus ced/weah_at_chsa
>
> SQL*Plus: Release 8.0.5.0.0 - Production on Fri Dec 3 12:0:7 1999
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12545: Connect failed because target host or object does not exist
>
> the user and password are correct.
> What's mean it ?
> Kekko
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Dec 04 1999 - 05:41:51 CST