Links
Home
Oracle DBA Forum
Frequent Oracle Errors
TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found'>ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated
fatal: libodm9.so: open failed [ORA-12547: TNS:lost contact ]

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

2005-06-29       - By Hameed, Amir

Reply:     1     2     3     4  

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/orac
le)(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)
 


<!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>&nbsp;</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>&nbsp;</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>&nbsp;</DIV>
 <DIV><FONT face=Arial><FONT size=2><SPAN
 class=633172622-29062005></SPAN>abcsb1:sb1adm 202% sqlplus</FONT></FONT></DIV>
 <DIV>&nbsp;</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>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2>Copyright (c) 1982, 2002, Oracle
 Corporation.&nbsp; All rights reserved.</FONT></DIV>
 <DIV>&nbsp;</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>&nbsp;</DIV>
 <DIV><BR><FONT face=Arial size=2>Enter user-name:</FONT></DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</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>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
 <DIV><FONT face=Arial
 size=2>**********************************************************************
*<BR>Fatal
 NI connect error 12547, connecting
 to:<BR>&nbsp;(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>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2>&nbsp; VERSION
 INFORMATION:<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TNS for Solaris:
 Version 9.2.0.4.0 - Production<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 Oracle Bequeath NT Protocol Adapter for Solaris: Version 9.2.0.4.0 -
 Production<BR>&nbsp; Time: 29-JUN-2005 17:25:49<BR>&nbsp; Tracing not turned
 on.<BR>&nbsp; Tns error struct:<BR>&nbsp;&nbsp;&nbsp; nr err code:
 0<BR>&nbsp;&nbsp;&nbsp; ns main err code: 12547<BR>&nbsp;&nbsp;&nbsp;
 TNS-12547: TNS:lost contact<BR>&nbsp;&nbsp;&nbsp; ns secondary err code:
 12560<BR>&nbsp;&nbsp;&nbsp; nt main err code: 517<BR>&nbsp;&nbsp;&nbsp;
 TNS-00517: Lost contact</FONT></DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
 <DIV><FONT face=Arial size=2></FONT>&nbsp;</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>&nbsp;</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>&nbsp;</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>