本机SQLPLUS 的时候报错 ORA-12547: TNS: lost contact

Oracle 8.1.6.0

Linux AS2.1 .

出现过一次Server僵死, 然后就不行了。

$sqlplus "/as sysdba"

报错 ORA-12547: TNS: lost contact

[@more@]

后来查找metalink . 可能的几个原因排除，然后找到一个很相似的 。 果然奏效 。 $ 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 ===================================================== Displayed below are the messages of the selected thread. Thread Status: Active From: alain moizeau 14-Feb-06 08:30 Subject: other user can not connect database using sqlplus RDBMS Version: 9.2.0.7 Operating System and Version: unix aix 5L Error Number (if applicable): ORA-12547: TNS:lost contact Product (i.e. SQL*Loader, Import, etc.): sqlplus Product Version: 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 From: Oracle, Björn Zetterberg 14-Feb-06 08:48 Subject: 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 From: alain moizeau 14-Feb-06 09:13 Subject: 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 ============================================ ORA-12547: TNS: lost contact tips Oracle Error Tips by Stephanie F.

The Oracle docs note this on the ora-12547 error:

ORA-12547: TNS: lost contact

Cause: Partner has unexpectedly gone away, usually during process startup.

Action: Investigate partner application for abnormal termination. On an Interchange, this can happen if the machine is overloaded.

Oracle MetaLink documentation offers information on ORA-12547 regarding it's occurrence after installing 10.1.0.5.0 patchset. This information regards Oracle Enterprise; version 10.1.0.2 during attempts to connect to the database. The link fails during Install as seen below:

- Linking Oracle
rm -f /oracle/10g1/rdbms/lib/oracle
cc +DD64 -Wl,+s -Wl,+n +DD64 -o /oracle/10g1/rdbms/lib/oracle -L/oracle/10g1/rdbms/lib/ -L/oracle/10g1/lib/ /oracle/10g1/rdbms/lib/ssoident.o `if /usr/bin/getconf KERNEL_BITS | grep "64" > /dev/null ;
then echo "-Wl,+pi,16M -Wl,+pd,L -Wl,+padtext,16M -Wl,+paddata,1M" ;
else echo "" ; fi` -Wl,-E -Wl,-PF,linkorderfile +FPd /oracle/10g1/rdbms/lib/opimai.o /oracle/10g1/rdbms/lib/ssoraed.o /oracle/10g1/rdbms/lib/ttcsoi.o /oracle/10g1/rdbms/lib/defopt.o -Wl,+forceload -lperfsrv10 -Wl,+noforceload /oracle/10g1/lib/nautab.o /oracle/10g1/lib/naeet.o /oracle/10g1/lib/naect.o /oracle/10g1/lib/naedhs.o /oracle/10g1/rdbms/lib/config.o -lserver10 -lodm10 -lnnet10 -lskgxp10 -lhasgen10 -lcore10 -lskgxn2 -locr10 -locrb10 -locrutl10 -lhasgen10 -lcore10 -lskgxn2 -lclient10 -lvsn10 -lcommon10 -lgeneric10 -lknlopt `if /usr/ccs/bin/ar tv /oracle/10g1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap10" ; fi` -ldm10 -lslax10 -lpls10 -lplp10 -lserver10 -lclient10 -lvsn10 -lcommon10 -lgeneric10 -lknlopt -lslax10 -lpls10 -lplp10 -ljox10 -lserver10 /oracle/10g1/has/lib/libclsra10.a -ldbcfg10 -locijdbcst10 `cat /oracle/10g1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /oracle/10g1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lmm -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /oracle/10g1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /oracle/10g1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `if /usr/ccs/bin/ar tv /oracle/10g1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo10"; fi` -lctxc10 -lctx10 -lzx10 -lgx10 -lctx10 -lzx10 -lgx10 -lordimt10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lsnls10 -lunls10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /oracle/10g1/lib/sysliblist` -lm `cat /oracle/10g1/lib/sysliblist` -lm
ld: Can't open the fdp output file linkorderfile
1 errors.
*** Error exit code 1


Note the error:

------------------

ld: Can't open the fdp output file linkorderfile
1 errors.
*** Error exit code 1

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 --&gt /usr/ccs/bin/ld, the error is not fatal, and link phase completes."

Relinking fails with:

ld: Can't open the fdp output file linkorderfile
1 errors.
*** Error exit code 1

This MetaLink document on ORA-12547 also offers many different solutions to be able to fully troubleshoot error ORA-12547"

1. Change the Oracle users environment variable PATH to ensure that 'ld' is from /usr/ccs/bin

export PATH=/usr/ccs/bin:${PATH}

2. Verify the following commands return the correct path /usr/ccs/bin

which make

which ar

which as

which ld

3. If you chose to 'ignore' or 'continue' when prompted during the linking of the patchset then you can relink by doing the following:

script relink.log (this captures the relink output to a file)
env|sort

relink all > relink.out
exit (stops the scripting output)

4. Review the relink.log and relink.out for errors

5. If you responded to the linking error prompt with 'stop installation' then reinstall the patchset as noted in the patchset readme file.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-1006331/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-1006331/