Re: No local connection via sqlplus (TNS:lost contact)

From: Thorsten Jens <thojens_at_gmx.de>
Date: 24 Nov 2005 06:21:45 -0800
Message-ID: <1132842105.886226.229040@z14g2000cwz.googlegroups.com>

Maxim Demenko schrieb:

> In that case it could be hardly explained (from your previous post) :
> oraload_at_xxx ~ $ LD_LIBRARY_PATH=/oracle/product/9.2.0/lib ldd `which
> oracle`
> libodm9.so => (file not found)
> libskgxp9.so => (file not found)
> libskgxn9.so => (file not found)
> libjox9.so => (file not found)
>
> I could think only about 2 possible reasons
> 1) LD_LIBRARY_PATH is not *set* and *exported* to proper value ( this
> suggestion don't stand as you pointed, that is not the case)
> 2) oraload user has no access to those libraries ( again permissions )
> What is the output of
> ls -l /oracle/product/9.2.0/lib/libodm9.so \
> /oracle/product/9.2.0/lib/libskgxp9.so \
> /oracle/product/9.2.0/lib/libskgxn9.so \
> /oracle/product/9.2.0/lib/libjox9.so

Just to make sure again:

---

oraload_at_xxx ~ $ export | grep LD
declare -x LD_LIBRARY_PATH="/oracle/product/9.2.0/lib:/usr/lib"

---

Permissions:

---

oraload_at_xxx ~ $  ls -l /oracle/product/9.2.0/lib/libodm9.so \


> /oracle/product/9.2.0/lib/libskgxp9.so \

> /oracle/product/9.2.0/lib/libskgxn9.so \
> /oracle/product/9.2.0/lib/libjox9.so

-rw-r--r-- 1 oracle dba 7650528 May 27 2005 /oracle/product/9.2.0/lib/libjox9.so
-rwxr-xr-x 1 oracle dba 9072 May 27 2005 /oracle/product/9.2.0/lib/libodm9.so
-rw-r--r-- 1 oracle dba 38616 Apr 27 2002 /oracle/product/9.2.0/lib/libskgxn9.so
-rw-r--r-- 1 oracle dba 12264 Aug 26 01:24 /oracle/product/9.2.0/lib/libskgxp9.so

---

Again, looks OK to me.

Thorsten Received on Thu Nov 24 2005 - 08:21:45 CST