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

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Thu, 24 Nov 2005 14:33:14 GMT
Message-ID: <Xns971842C6A4768SunnySD@70.168.83.30>

"Thorsten Jens" <thojens_at_gmx.de> wrote in news:1132842105.886226.229040_at_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
>
>

On some version(s) of Oracle the default installation precludes users not part of the "dba" group access to needed file due to lack of permission on higher level DIRECTORIES. Received on Thu Nov 24 2005 - 08:33:14 CST