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@(protected)] Sent: Wednesday, June 29, 2005 5:43 PM To: Roger Xu; oracle-l@(protected) Subject: RE: fatal: libodm9.so: open failed [ORA-12547 (See ORA-12547.ora-code.com): 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@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Roger Xu Sent: Wednesday, June 29, 2005 6:35 PM To: Oracle-L@(protected) Org (E-mail) Subject: fatal: libodm9.so: open failed [ORA-12547 (See ORA-12547.ora-code.com): 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 (See ORA-12547.ora-code.com): 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@(protected)
For technical support please email tech_support@(protected) 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@(protected) <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN class=963163515-30062005>It is almost like a cloned instance. In fact, we backup/restored all the oracle related filesystems and reinstalled Solaris 8 from scratch.</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN class=963163515-30062005>I am not quite sure about <FONT color=#000000><STRONG>Oracle</STRONG> Data Mining (<B>ODM).</B></FONT></SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN class=963163515-30062005></SPAN></FONT></FONT></FONT> </DIV> <DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN class=963163515-30062005># </SPAN>pwd<BR>/oracle/SB1/920_64/lib<BR><SPAN class=963163515-30062005># </SPAN>ls -l libodm*.so<BR>lrwxrwxrwx 1 oradv1 dba 11 Jun 28 19:42 libodm9.so -> libodmd9.so<BR>-rwxrwxrwx 1 orasb1 dba 9064 Aug 13 2003 libodmd9.so</FONT></FONT></FONT></DIV> <BLOCKQUOTE> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-- --Original Message-- --<BR><B>From:</B> Hameed, Amir [mailto:Amir.Hameed@(protected)]<BR><B>Sent:</B> Wednesday, June 29, 2005 5:43 PM<BR><B>To:</B> Roger Xu; oracle-l@(protected)<BR><B>Subject:</B> RE: fatal: libodm9.so: open failed [ORA-12547 (See ORA-12547.ora-code.com): TNS:lost contact ]<BR><BR></FONT></DIV> <DIV dir=ltr align=left><SPAN class=075424022-29062005><FONT face="Comic Sans MS" color=#800000 size=2>Is this a new instance or cloned from one where ODM was enabled? Check to see if you have a line $ORACLE_HOME/lib/<FONT size=2>libodm9.so pointing to $ORACLE_HOME/lib/<FONT size=2><FONT size=2>libodmd9.so</FONT></FONT></FONT></FONT></SPAN></DIV> <DIV><FONT face="Comic Sans MS" color=#800000 size=2></FONT> </DIV> <DIV><SPAN class=075424022-29062005><FONT face="Comic Sans MS" color=#800000 size=2>Amir</FONT></SPAN><BR></DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> <FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Roger Xu<BR><B>Sent:</B> Wednesday, June 29, 2005 6:35 PM<BR><B>To:</B> Oracle-L@(protected) Org (E-mail)<BR><B>Subject:</B> fatal: libodm9.so: open failed [ORA-12547 (See ORA-12547.ora-code.com): TNS:lost contact ]<BR></FONT><BR></DIV> <DIV></DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=633172622-29062005>Hi Gurus,</SPAN></FONT></FONT></DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=633172622-29062005></SPAN></FONT></FONT> </DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=633172622-29062005>Please see the following screen capture:</SPAN></FONT></FONT></DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=633172622-29062005></SPAN></FONT></FONT> </DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=633172622-29062005></SPAN>abcsb1:sb1adm 202% sqlplus</FONT></FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jun 29 17:25:41 2005</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>Enter user-name: SYSTEM<BR>Enter password:<BR>ld.so.1: oracleSB1: fatal: libodm9.so: open failed: No such file or directory<BR>ERROR:<BR>ORA-12547 (See ORA-12547.ora-code.com): TNS:lost contact</FONT></DIV> <DIV> </DIV> <DIV><BR><FONT face=Arial size=2>Enter user-name:</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><SPAN class=633172622-29062005><FONT face=Arial size=2>Here is the errors showed in </FONT></SPAN><FONT face=Arial size=2>sqlnet.log</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>******************************************************************** ***<BR>Fatal NI connect error 12547, connecting to:<BR> (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/SB1/920 _64/bin/oracle)(ARGV0=oracleSB1)(ARGS='<BR>(DESCRIPTION=(LOCAL=YES)(ADDRESS= (PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ab<BR>csb1) (USER=sb1adm))))</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2> VERSION INFORMATION:<BR> TNS for Solaris: Version 9.2.0.4.0 - Production<BR>   ; Oracle Bequeath NT Protocol Adapter for Solaris: Version 9.2.0.4.0 - Production<BR> Time: 29-JUN-2005 17:25:49<BR> Tracing not turned on.<BR> Tns error struct:<BR> nr err code: 0<BR> ns main err code: 12547<BR> TNS-12547: TNS:lost contact<BR> ns secondary err code: 12560<BR> nt main err code: 517<BR> TNS-00517: Lost contact</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT size=+0><SPAN class=633172622-29062005><FONT face=Arial size=2>Anyone had this kind of error before? And what would be my fix?</FONT></SPAN></FONT></DIV> <DIV><FONT size=+0><SPAN class=633172622-29062005><FONT face=Arial size=2></FONT></SPAN></FONT> </DIV> <DIV><FONT size=+0><SPAN class=633172622-29062005><FONT face=Arial size=2>Thanks,</FONT></SPAN></FONT></DIV> <DIV><FONT size=+0><SPAN class=633172622-29062005><FONT face=Arial size=2></FONT></SPAN></FONT> </DIV> <DIV><FONT size=+0><SPAN class=633172622-29062005><FONT face=Arial size=2>Roger</FONT></SPAN></DIV> <DIV><FONT face=Arial><BR><FONT size=2></FONT></FONT></DIV></FONT><BR>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. <BR>__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____<BR >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@(protected)<BR></BLOCKQUOTE><BR>For technical support please email tech_support@(protected) or you can<BR>call (972)721-8257. <BR>This email has been scanned for all viruses by the MessageLabs Email Security System.<BR></BLOCKQUOTE> <BR> 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. <BR> __ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____<BR> 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@(protected)<BR> </BODY></HTML>
