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:
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)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2800.1498" name=GENERATOR></HEAD> <BODY> <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></BODY></HTML>