RE: fatal: libodm9.so: open failed [ORA-12547: TNS:lost contact ]

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Thu, 30 Jun 2005 10:39:58 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F7051837FA@irv2kexch01.tx.bg.corp>

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_at_xerox.com] Sent: Wednesday, June 29, 2005 5:43 PM
To: Roger Xu; oracle-l_at_freelists.org
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu Sent: Wednesday, June 29, 2005 6:35 PM
To: Oracle-L_at_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

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_at_dp7uptx.com.

For technical support please email tech_support_at_dp7uptx.com or you can call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.

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_at_dp7uptx.com.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 30 2005 - 11:53:56 CDT