.ora-code.com

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 Roger Xu
Reply:     1     2     3     4  

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)
<!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 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><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><SPAN class=633172622-29062005><FONT face=Arial
size=2></FONT></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT><SPAN class=633172622-29062005><FONT face=Arial
size=2>Thanks,</FONT></SPAN></FONT></DIV>
<DIV><FONT><SPAN class=633172622-29062005><FONT face=Arial
size=2></FONT></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT><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>
</BODY></HTML>