Maxim Demenko schrieb:
> Thorsten Jens schrieb:
>
>> erwiggins_at_gmail.com schrieb:
>>
>>
>>> Did you restore the oracle home from the tar as well? If so relink the
>>> oracle executables to the shared libs. Also as others have said make
>>> sure that these other users are in the "dba " group or whichever group
>>> is the owner of the libraries. Also look at the LD_LIBRARY_PATH and
>>> make sure that $ORACLE_HOME/lib is in there.
>>
>>
>>
>> I restored the entire /oracle ($ORACLE_BASE, thus including
>> $ORACLE_HOME) directory, including binaries, libs, datafiles, ...
>>
>> Both users are in the dba group. LD_LIBRARY_PATH should be ok, check
>> out my answer to Sybrand's post.
>>
>> Thorsten
>>
>
> Sorry, i've missed your original post.
> Could you try not only set LD_LIBRARY_PATH, but as well export it ?
> I'did try as nonprivileged user ( non dba group as well ) on one
> executable in $ORACLE_HOME/bin with read for all permissions, here what
> i got.
>
> $ ldd tstshmO
> libclntsh.so.9.0 => (file not found)
> libwtc9.so => (file not found)
> libnsl.so.1 => /usr/lib/libnsl.so.1
> libsocket.so.1 => /usr/lib/libsocket.so.1
> libdl.so.1 => /usr/lib/libdl.so.1
> libsched.so.1 => /usr/lib/libsched.so.1
> libc.so.1 => /usr/lib/libc.so.1
> libaio.so.1 => /usr/lib/libaio.so.1
> libposix4.so.1 => /usr/lib/libposix4.so.1
> libkstat.so.1 => /usr/lib/libkstat.so.1
> libm.so.1 => /usr/lib/libm.so.1
> libmp.so.2 => /usr/lib/libmp.so.2
> /usr/platform/SUNW,Ultra-80/lib/libc_psr.so.1
> # now set the LD_LIBRARY_PATH
> $ LD_LIRBRARY_PATH=$ORACLE_HOME/lib
> $ ldd tstshmO
> libclntsh.so.9.0 => (file not found)
> libwtc9.so => (file not found)
> libnsl.so.1 => /usr/lib/libnsl.so.1
> libsocket.so.1 => /usr/lib/libsocket.so.1
> libdl.so.1 => /usr/lib/libdl.so.1
> libsched.so.1 => /usr/lib/libsched.so.1
> libc.so.1 => /usr/lib/libc.so.1
> libaio.so.1 => /usr/lib/libaio.so.1
> libposix4.so.1 => /usr/lib/libposix4.so.1
> libkstat.so.1 => /usr/lib/libkstat.so.1
> libm.so.1 => /usr/lib/libm.so.1
> libmp.so.2 => /usr/lib/libmp.so.2
> /usr/platform/SUNW,Ultra-80/lib/libc_psr.so.1
> # now export it
> $ export LD_LIBRARY_PATH
> $ ldd tstshmO
> libclntsh.so.9.0 =>
> /u01/app/oracle/products/9.2.0.6/lib/libclntsh.so.9.0
> libwtc9.so => /u01/app/oracle/products/9.2.0.6/lib/libwtc9.so
> libnsl.so.1 => /usr/lib/libnsl.so.1
> libsocket.so.1 => /usr/lib/libsocket.so.1
> libdl.so.1 => /usr/lib/libdl.so.1
> libsched.so.1 => /usr/lib/libsched.so.1
> libc.so.1 => /usr/lib/libc.so.1
> libaio.so.1 => /usr/lib/libaio.so.1
> libposix4.so.1 => /usr/lib/libposix4.so.1
> libkstat.so.1 => /usr/lib/libkstat.so.1
> libm.so.1 => /usr/lib/libm.so.1
> libgen.so.1 => /usr/lib/libgen.so.1
> libmp.so.2 => /usr/lib/libmp.so.2
> /usr/platform/SUNW,Ultra-80/lib/libc_psr.so.1
>
>
> Best regards
>
> Maxim
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
if you issue it as *oraload* user ?
Best regards
Maxim
Received on Thu Nov 24 2005 - 07:53:00 CST
