Re: SQLNet for Linux cannot connect at Oracle7 instance

From: Yass Khogaly <ykhogaly_at_us.oracle.com>
Date: Fri, 3 Dec 1999 08:41:56 -0800
Message-ID: <828oa9$feg$1@inet16.us.oracle.com>

Ensure listener is shut.
echo > /tmp/listener.trc
echo > /tmp/listener2.log
EDit listener.ora , set TRACE_LEVEL_LISTENER=16
Is TNS_ADMIN set?
Start the listener and let it fail ONCE.
Script the following: env more /etc/hosts ping basil and ip address nslookup basil hostname
Edit the listener.ora file to:
write to a DIFFERENT trace and log file
Replace hostname with IP address.
Start the listener again and let if fail ONCE.
Send in the script file from 7, and ALL four trace/log files (please choose sensible names to help me identify them eg hostname.trc, ipaddr.trc
Has the IP address been changed? Dont think so?
How many network cards have they got.?
Check /etc/resolv.conf. for missing the "domain" entry, and there's some other entries which shouldn't be there (/etc/hosts type entries).

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

Francesco Dini <dini.f_at_adr.it> wrote in message news:3847CBAA.2F558981_at_adr.it...
> 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
>
>
Received on Fri Dec 03 1999 - 10:41:56 CST