Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: No local connection via sqlplus (TNS:lost contact)

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

From: Thorsten Jens <thojens_at_gmx.de>
Date: 28 Nov 2005 00:11:23 -0800
Message-ID: <1133165483.285390.25370@o13g2000cwo.googlegroups.com>


Maxim Demenko schrieb:

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

Both $PATHs are correct and almost the same (both contain $ORACLE_HOME/bin as the first entry). There is only one $ORACLE_HOME, and only one 'oracle' binary.

Thorsten Received on Mon Nov 28 2005 - 02:11:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US