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

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 24 Nov 2005 13:52:51 +0100
Message-ID: <4385b7fb$0$20846$9b4e6d93@newsread2.arcor-online.net>

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 Received on Thu Nov 24 2005 - 06:52:51 CST