# $ relink oracle 即可 。
具体原因：
Veirfy that your LIBPATH also includes $ORACLE_HOME/lib and
relink the oracle software. Shutdown all running oracle services before
relinking the oracle software
Note.209272.1
Title: Cannot connect to 9.2 database – Dependent module libjox9.a(shr.o) could not be loaded
Note.219211.1
Title: Bequeath Sqlplus Connection Fails with TNS-12547
=====================================================
Active
alain moizeau 14-Feb-06 08:30
other user can not connect database using sqlplus
: 9.2.0.7
: unix aix 5L
: ORA-12547: TNS:lost contact
: sqlplus
: 9.2.0.7
other user can not connect database using sqlplus
Hi,
other user can not connect database using sqlplus
I have same problem and followd all documents but not success. If I login as oracle on unix and run sqlplus system/manager it connects right a way but doing same with other user gives me following error.
sqlplus system/manager
exec() : 0509-036 Impossible de charger le programme oracleMH30SDRH
en raison des erreurs suivantes :
0509-150 Le module dépendant libjox9.a(shr.o) n'a pas pu être chargé.
0509-022 Impossible de charger le module libjox9.a(shr.o).
0509-026 Erreur système : Un fichier ou un répertoire du chemin d'accès n'existe pas.
ERROR:
ORA-12547: TNS:lost contact
LIBPATH=/usr/oracle/9.2.0.7/lib32:/usr/oracle/9.2.0.7/lib
ORACLE_SID=MH30SDRH
ORA_NLS33=/usr/oracle/9.2.0.7/ocommon/nls/admin/data
ORACLE_HOME=/usr/oracle/9.2.0.7
WHEN the user connect with SQLPLUS system/manager@MH30SDRH, its right
When export TWO_TASK=MH30SDRH
sqlplus system/manager
SQL*Plus: Release 9.2.0.7.0 – Production on Tue Feb 14 09:31:00 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 – 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.7.0 – Production
which is the problem
thanks
Alain MOIZEAU
amoizeau@adelior.com
Oracle, Björn Zetterberg 14-Feb-06 08:48
Re : other user can not connect database using sqlplus
Veirfy that your LIBPATH also includes $ORACLE_HOME/lib and
relink the oracle software. Shutdown all running oracle services before
relinking the oracle software
Note.209272.1
Title: Cannot connect to 9.2 database – Dependent module libjox9.a(shr.o) could not be loaded
Note.219211.1
Title: Bequeath Sqlplus Connection Fails with TNS-12547 —
alain moizeau 14-Feb-06 09:13
Re : other user can not connect database using sqlplus
Hi,
Yes,
i already relink, its all right
and my LIBPATH also includes $ORACLE_HOME/lib
thanks for others ideas
alain moizeau
# # #
The cause of ORA-12457 is stated below. It is also pointed out that ORA-12547 should not be considered a fatal error, but when ORA-12547 is thrown, "the fatal error during link is due to using the incorrect ld executable during install of the patchset. When using the correct ld –> , the error is not fatal, and link phase completes." >
>