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

IANAL_VISTA schrieb:

> "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

Ahhh, here we go: This makes everything work correctly again using the 'oraload' user. TWO_TASK was not set before, setting it to our_db makes the connect go through. Has there been in change in 9.2.0.7 regarding that?

Thorsten Received on Mon Nov 28 2005 - 02:15:57 CST