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

Comments embedded.
Thorsten Jens wrote:
> 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

This is usually not a 'permissions' issue, but a pathing problem, notably an incomplete or unset LD_LIBRARY_PATH. I would verify that the location of libodm9.so ($ORACLE_HOME/lib) is in your LD_LIBRARY_PATH for the suspect user. From all indications it is not.

> ERROR:
> ORA-12547: TNS:lost contact
> ------------------------------------------------------------
>
> I can, however, connect using the user_at_identifier syntax:
> ------------------------------------------------------------
> oraload_at_xxx16 ~ $ sqlplus system_at_our_db
>
> SQL*Plus: Release 9.2.0.7.0 - Production on Tue Nov 22 12:37:43 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
> ------------------------------------------------------------
>
> I've searched a bit and found that this could be a permissions issue. I
> think the permissions I checked look fine, though:
> ------------------------------------------------------------
> oracle_at_xxx16 ~ $ ls -laF `which oracle sqlplus`
> $ORACLE_HOME/lib/libodm*
> -rwsr-s--x 1 oracle dba 69508136 Nov 20 16:45
> /oracle/product/9.2.0/bin/oracle*
> -rwxr-x--x 1 oracle dba 1058224 Nov 20 16:07
> /oracle/product/9.2.0/bin/sqlplus*
> -rw-r--r-- 1 oracle dba 9072 May 27 05:37
> /oracle/product/9.2.0/lib/libodm9.so
> -rw-r--r-- 1 oracle dba 9072 May 27 05:37
> /oracle/product/9.2.0/lib/libodmd9.so
> ------------------------------------------------------------
>

This has little, if anything, to do with an 'open failed: no such file or directory' error.

> Any ideas?
>
> Thorsten

David Fitzjarrell Received on Tue Nov 22 2005 - 11:59:39 CST