Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: No local connection via sqlplus (TNS:lost contact)
"Thorsten Jens" <thojens_at_gmx.de> wrote in
news:1132659843.204214.268280_at_g47g2000cwa.googlegroups.com:
> Hi,
>
> I've recently had to restore our database from a (online) tar backup,
> and I've had problems connecting via sqlplus since then. Solaris
> 8/64bit Sparc, Oracle 9.2.0.6.0 was restored but was patched to
> 9.2.0.7.0 since then.
>
> Everything works fine as the 'oracle' user:
> ------------------------------------------------------------
> oracle_at_tnsw16 ~ $ echo $ORACLE_BASE, $ORACLE_HOME, $ORACLE_SID
> /oracle, /oracle/product/9.2.0, our_db
> oracle_at_xxx16 ~ $ sqlplus system
>
> SQL*Plus: Release 9.2.0.7.0 - Production on Tue Nov 22 12:34:58 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter password:
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.7.0 - Production
> ------------------------------------------------------------
>
> But as another user (who could connect like this before!), I get:
> ------------------------------------------------------------
> oraload_at_xxx16 ~ $ echo $ORACLE_BASE, $ORACLE_HOME, $ORACLE_SID
> /oracle, /oracle/product/9.2.0, our_db
> oraload_at_xxx16 ~ $ sqlplus system
>
> SQL*Plus: Release 9.2.0.7.0 - Production on Tue Nov 22 12:36:34 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter password:
> ld.so.1: oracle: fatal: libodm9.so: open failed: No such file or
> directory
> ERROR:
> ORA-12547: TNS:lost contact
> ------------------------------------------------------------
AFAIK, the "only" way SQL*Net could be reporting a problem is when TWO_TASK is set to some non-null value; which is wrong.
what happens when you
TWO_TASK=our_db
export TWO_TASK
Received on Thu Nov 24 2005 - 09:09:16 CST