.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
ora- 600 and ora -03113

ora- 600 and ora -03113

2005-10-05       - By Mercadante, Thomas F (LABOR)
Reply:     1     2     3     4     5     6     7     8     9     10     >>  

The Ora-3113 (See Ora-3113.ora-code.com) is maybe because the database has not been cleanly shut
down yet.  Did you try:



Reset the init.ora params to what they were before you did anything.

Shutdown abort.

Startup.



__ ____ ____ ____ ____ ____ ____

From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Chirag DBA
Sent: Wednesday, October 05, 2005 1:25 PM
To: R J Zijlstra
Cc: Oracle-L Freelists
Subject: Re: ora- 600 and ora -03113



This error has started from last night and DB is being shutdown for cold
backup.

We got 600 at night only, while shutting down the DB. (through scripts).



and today morning users started complaining abt the performance and I
changed the SGA.

I put db_block_buffers too hight for sure.



I get ora-600 (See ora-600.ora-code.com) only then and not after that. Right now we are getting
0ra-03113.



hopefully making db_block_buffers will help.



regards - chirag







On 10/5/05, R J Zijlstra <rmsah@(protected)> wrote:

Hi, Google:



 http://www.lazydba.com/oracledba.pl?0::35054
<http://www.lazydba.com/oracledba.pl?0::35054>



Thank you



__ ____ ____ ____ ____ ____ ____

From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Chirag DBA
Sent: woensdag 5 oktober 2005 19:00
To: Oracle-L Freelists
Subject: ora- 600 and ora -03113



Hi



I changed my SGA size from 300mb to 1.5GB.



Users are getting ora-03113 (See ora-03113.ora-code.com) end-of-file comminication channed.



Got this error after starting the Database. It is 9.2.0.2
<http://9.2.0.2/> on solaris.



ksedmp: internal or fatal error
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [1113], [], [], [], [], [],
[], []
ORA-01089 (See ORA-01089.ora-code.com): immediate shutdown in progress - no operations are permitted
No current SQL statement being executed.
-- -- PL/SQL Call Stack -- --
 object      line  object



Any idea?



reards - chirag




<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http:
//www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Tahoma;
  panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:blue;
  text-decoration:underline;}
p
  {mso-margin-top-alt:auto;
  margin-right:0in;
  mso-margin-bottom-alt:auto;
  margin-left:0in;
  font-size:12.0pt;
  font-family:"Times New Roman";}
span.EmailStyle21
  {mso-style-type:personal-reply;
  font-family:Arial;
  color:navy;}
@(protected) Section1
  {size:8.5in 11.0in;
  margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=blue>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The Ora-3113 (See Ora-3113.ora-code.com) is maybe because the database
has not been cleanly shut down yet. &nbsp;Did you try:<o:p></o:p></span></font>
</p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Reset the init.ora params to what they
were before you did anything.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Shutdown abort.<o:p></o:p></span></font><
/p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Startup.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Chirag DBA<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, October 05, 2005
1:25 PM<br>
<b><span style='font-weight:bold'>To:</span></b> R J Zijlstra<br>
<b><span style='font-weight:bold'>Cc:</span></b> Oracle-L Freelists<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: ora- 600 and ora
-03113</span></font><o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>This error has started from last night and DB is being shutdown for
cold backup.<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>We got 600 at night only, while shutting down the DB. (through
scripts).<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>and today morning users started complaining abt the performance and I
changed the SGA.<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I put db_block_buffers too hight for sure. <o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I get ora-600 (See ora-600.ora-code.com) only then and not after that. Right now we are getting
0ra-03113.<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>hopefully making db_block_buffers will help.<o:p></o:p></span></font><
/p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>regards - chirag <o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br>
&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman">
<span
style='font-size:12.0pt'>On 10/5/05, <b><span style='font-weight:bold'>R J
Zijlstra</span></b> &lt;<a href="mailto:rmsah@(protected)">rmsah@(protected)</a>&gt;
wrote:</span></font></span> <o:p></o:p></p>

<div>

<p><font size=2 color=navy face=Arial><span lang=NL style='font-size:10.0pt;
font-family:Arial;color:navy'>Hi, Google:</span></font><o:p></o:p></p>

<p><font size=2 color=navy face=Arial><span lang=NL style='font-size:10.0pt;
font-family:Arial;color:navy'>&nbsp;</span></font><o:p></o:p></p>

<p><font size=2 color=navy face=Arial><span lang=NL style='font-size:10.0pt;
font-family:Arial;color:navy'>&nbsp;<a
href="http://www.lazydba.com/oracledba.pl?0::35054" target="_blank">
http://www.lazydba.com/oracledba.pl?0::35054</a></span></font><o:p></o:p></p>

<p><font size=2 color=navy face=Arial><span lang=NL style='font-size:10.0pt;
font-family:Arial;color:navy'>&nbsp;</span></font><o:p></o:p></p>

<p><font size=2 color=navy face=Arial><span lang=NL style='font-size:10.0pt;
font-family:Arial;color:navy'>Thank you</span></font><o:p></o:p></p>

<p><font size=2 color=navy face=Arial><span lang=NL style='font-size:10.0pt;
font-family:Arial;color:navy'>&nbsp;</span></font><o:p></o:p></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center>

</span></font></div>

<p><b><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
font-weight:bold'>From:</span></font></b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> <a
href="mailto:oracle-l-bounce@(protected)" target="_blank">oracle-l-bounce
@(protected)</a>
[mailto:<a href="mailto:oracle-l-bounce@(protected)" target="_blank">oracle-l
-bounce@(protected)</a>]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Chirag DBA<br>
<b><span style='font-weight:bold'>Sent:</span></b> woensdag 5 oktober 2005
19:00<br>
<span class=q><b><span style='font-weight:bold'>To:</span></b> Oracle-L
Freelists</span><br>
<span class=q><b><span style='font-weight:bold'>Subject:</span></b> ora- 600
and ora -03113</span></span></font><o:p></o:p></p>

</div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;<o
:p></o:p></span></font></p>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Hi <o:p><
/o:p></span></font></p>

</div>

<div><span id="q_106c1c67112325eb_3">

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;<o
:p></o:p></span></font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>I changed
my SGA size from 300mb to 1.5GB.<o:p></o:p></span></font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;<o
:p></o:p></span></font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Users are
getting ora-03113 (See ora-03113.ora-code.com) end-of-file comminication channed.<o:p></o:p></span></font><
/p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;<o
:p></o:p></span></font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Got this
error after starting the Database. It is <a href="http://9.2.0.2/"
target="_blank">9.2.0.2 </a>on solaris.<o:p></o:p></span></font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;<o
:p></o:p></span></font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>ksedmp:
internal or fatal error<br>
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [1113], [], [], [], [], [], [], []
<br>
ORA-01089 (See ORA-01089.ora-code.com): immediate shutdown in progress - no operations are permitted <br>
No current SQL statement being executed. <br>
-- -- PL/SQL Call Stack -- --<br>
&nbsp; object&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; line&nbsp; object<o:p></o:p></span>
</font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;<o
:p></o:p></span></font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Any idea?
<o:p></o:p></span></font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;<o
:p></o:p></span></font></p>

</div>

<div>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>reards -
chirag <o:p></o:p></span></font></p>

</div>

</div>

</div>

</div>

</span>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>