No local connection via sqlplus (TNS:lost contact)

From: Thorsten Jens <thojens_at_gmx.de>
Date: 22 Nov 2005 03:44:03 -0800
Message-ID: <1132659843.204214.268280@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

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

Enter password:
ld.so.1: oracle: fatal: libodm9.so: open failed: No such file or directory
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

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

Any ideas?

Thorsten Received on Tue Nov 22 2005 - 05:44:03 CST