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

From: Thorsten Jens <thojens_at_gmx.de>
Date: 24 Nov 2005 02:22:46 -0800
Message-ID: <1132827765.978399.84000@o13g2000cwo.googlegroups.com>

Sybrand Bakker schrieb:

> On 22 Nov 2005 03:44:03 -0800, "Thorsten Jens" <thojens_at_gmx.de> wrote:
>
> >Any ideas?
>
> LD_LIBRARY_PATH or LIBPATH issue?

(to you and all the people who pointed me to LD_LIBRARY_PATH) PATH and LD_LIBRARY_PATH are the same for both users, LIBPATH is set for neither of them! Even specifying LD_LIBRARY_PATH directly brings no improvement. Check this out:

---

oracle_at_xxx ~ $ LD_LIBRARY_PATH=/oracle/product/9.2.0/lib ldd `which oracle`

        libodm9.so =>    /oracle/product/9.2.0/lib/libodm9.so
        libskgxp9.so =>  /oracle/product/9.2.0/lib/libskgxp9.so
        libskgxn9.so =>  /oracle/product/9.2.0/lib/libskgxn9.so
        libjox9.so =>    /oracle/product/9.2.0/lib/libjox9.so
        libnsl.so.1 =>   /usr/lib/64/libnsl.so.1
        libsocket.so.1 =>        /usr/lib/64/libsocket.so.1
        libgen.so.1 =>   /usr/lib/64/libgen.so.1
        libdl.so.1 =>    /usr/lib/64/libdl.so.1
        libc.so.1 =>     /usr/lib/64/libc.so.1
        libaio.so.1 =>   /usr/lib/64/libaio.so.1
        librt.so.1 =>    /usr/lib/64/librt.so.1
        libkstat.so.1 =>         /usr/lib/64/libkstat.so.1
        libm.so.1 =>     /usr/lib/64/libm.so.1
        libmp.so.2 =>    /usr/lib/64/libmp.so.2
        /usr/platform/SUNW,Sun-Fire/lib/sparcv9/libc_psr.so.1
------------------------------------------------------------

Copy and pasting the exact same line to the other user:

---

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)
        libnsl.so.1 =>   /usr/lib/64/libnsl.so.1
        libsocket.so.1 =>        /usr/lib/64/libsocket.so.1
        libgen.so.1 =>   /usr/lib/64/libgen.so.1
        libdl.so.1 =>    /usr/lib/64/libdl.so.1
        libc.so.1 =>     /usr/lib/64/libc.so.1
        libaio.so.1 =>   /usr/lib/64/libaio.so.1
        librt.so.1 =>    /usr/lib/64/librt.so.1
        libkstat.so.1 =>         /usr/lib/64/libkstat.so.1
        libm.so.1 =>     /usr/lib/64/libm.so.1
        libmp.so.2 =>    /usr/lib/64/libmp.so.2
        /usr/platform/SUNW,Sun-Fire/lib/sparcv9/libc_psr.so.1
------------------------------------------------------------

I trussed those two calls, and the error for 'oraload' seems to be this one:

---

23123:  access("/oracle/product/9.2.0/bin/oracle", 1)   = 0
23123:  getuid()                                        = 1016 [1016]
23123:  fork()                                          = 23124
23124:  fork()          (returning as child ...)        = 23123
23124:  execve("/oracle/product/9.2.0/bin/oracle", 0xFFBEF958,
0x00025480)
23124:          *** cannot trace across exec() of

/oracle/product/9.2.0/bin/oracle ***

---

The execve call succeeds for the 'oracle' user. Any idea on this one?

Thanks,
Thorsten Received on Thu Nov 24 2005 - 04:22:46 CST