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

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 24 Nov 2005 15:42:29 +0100
Message-ID: <4385d1af$0$27901$9b4e6d93@newsread4.arcor-online.net>

Thorsten Jens schrieb:
> 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
>

Looks OK for me too.
( yesterday read in Tom Kyte blog "Debugging is fun, because it begins with a mystery." - can't resist to repeat it).

Sorry, i've really no more ideas, only to be sure, last question PATH are set and exported equally in both cases ? I mean `which oracle` could not return different oracle executable for oraload user as it is in case of oracle user ( silly suspiction , you have more than one ORACLE_HOME) ?

Best regards

Maxim Received on Thu Nov 24 2005 - 08:42:29 CST