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

From: Thorsten Jens <thojens_at_gmx.de>
Date: 24 Nov 2005 02:26:01 -0800
Message-ID: <1132827961.165387.224670@f14g2000cwb.googlegroups.com>

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 Received on Thu Nov 24 2005 - 04:26:01 CST