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: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Thu, 24 Nov 2005 15:09:16 GMT
Message-ID: <Xns971848E394F31SunnySD@70.168.83.30>


"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

Original text of this message

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