It is almost like a cloned instance. In fact, we backup/restored all the oracle related filesystems and reinstalled Solaris 8 from scratch. I am not quite sure about Oracle Data Mining (ODM). # pwd /oracle/SB1/920_64/lib # ls -l libodm*.so lrwxrwxrwx 1 oradv1 dba 11 Jun 28 19:42 libodm9.so -> libodmd9.so -rwxrwxrwx 1 orasb1 dba 9064 Aug 13 2003 libodmd9.so -----Original Message----- From: Hameed, Amir [mailto:Amir.Hameed@xxxxxxxxx] Sent: Wednesday, June 29, 2005 5:43 PM To: Roger Xu; oracle-l@xxxxxxxxxxxxx Subject: RE: fatal: libodm9.so: open failed [ORA-12547: TNS:lost contact ] Is this a new instance or cloned from one where ODM was enabled? Check to see if you have a line $ORACLE_HOME/lib/libodm9.so pointing to $ORACLE_HOME/lib/libodmd9.so Amir _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu Sent: Wednesday, June 29, 2005 6:35 PM To: Oracle-L@Freelists. Org (E-mail) Subject: fatal: libodm9.so: open failed [ORA-12547: TNS:lost contact ] Hi Gurus, Please see the following screen capture: abcsb1:sb1adm 202% sqlplus SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jun 29 17:25:41 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name: SYSTEM Enter password: ld.so.1: oracleSB1: fatal: libodm9.so: open failed: No such file or directory ERROR: ORA-12547: TNS:lost contact Enter user-name: Here is the errors showed in sqlnet.log *********************************************************************** Fatal NI connect error 12547, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/SB1/920_64/bin/oracle)(ARGV0=oracleSB1)(ARGS=' (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ab csb1)(USER=sb1adm)))) VERSION INFORMATION: TNS for Solaris: Version 9.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for Solaris: Version 9.2.0.4.0 - Production Time: 29-JUN-2005 17:25:49 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12547 TNS-12547: TNS:lost contact ns secondary err code: 12560 nt main err code: 517 TNS-00517: Lost contact Anyone had this kind of error before? And what would be my fix? Thanks, Roger This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@xxxxxxxxxxxx For technical support please email tech_support@xxxxxxxxxxx or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@xxxxxxxxxxxx