ora- 600 and ora -03113 2005-10-05 - By Chirag DBA
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
>
> 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
>
<div>This error has started from last night and DB is being shutdown for cold
backup.</div>
<div>We got 600 at night only, while shutting down the DB. (through scripts).<
/div>
<div> </div>
<div>and today morning users started complaining abt the performance and I
changed the SGA.</div>
<div>I put db_block_buffers too hight for sure. </div>
<div> </div>
<div>I get ora-600 (See ora-600.ora-code.com) only then and not after that. Right now we are getting 0ra
-03113.</div>
<div> </div>
<div>hopefully making db_block_buffers will help.</div>
<div> </div>
<div>regards - chirag </div>
<div> </div>
<div><br><br> </div>
<div><span class="gmail_quote">On 10/5/05, <b class="gmail_sendername">R J
Zijlstra</b> <<a href="mailto:rmsah@(protected)">rmsah@(protected)</a>> wrote
:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<p><font face="Arial" color="navy" size="2"><span lang="NL" style="FONT-SIZE:
10pt; COLOR: navy; FONT-FAMILY: Arial">Hi, Google:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span lang="NL" style="FONT-SIZE:
10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" color="navy" size="2"><span lang="NL" style="FONT-SIZE:
10pt; COLOR: navy; FONT-FAMILY: Arial"> <a onclick="return top.js
.OpenExtLink(window,event,this)" href="http://www.lazydba.com/oracledba.pl?0:
:35054" target="_blank">
http://www.lazydba.com/oracledba.pl?0::35054</a></span></font></p>
<p><font face="Arial" color="navy" size="2"><span lang="NL" style="FONT-SIZE:
10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" color="navy" size="2"><span lang="NL" style="FONT-SIZE:
10pt; COLOR: navy; FONT-FAMILY: Arial">Thank you</span></font></p>
<p><font face="Arial" color="navy" size="2"><span lang="NL" style="FONT-SIZE:
10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman"
size="3"><span style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="2">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE:
10pt; FONT-FAMILY: Tahoma">From:</span></font></b><font face="Tahoma" size="2">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <a onclick="return top.js
.OpenExtLink(window,event,this)" href="mailto:oracle-l-bounce@(protected)"
target="_blank">
oracle-l-bounce@(protected)</a> [mailto:<a onclick="return top.js.OpenExtLink
(window,event,this)" 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<span class="q"><br><b><span style="FONT
-WEIGHT: bold">To:</span></b> Oracle-L Freelists<br><b><span style="FONT-WEIGHT:
bold">
Subject:</span></b> ora- 600 and ora -03113</span></span></font></p></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> <
/span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Hi <
/span></font></p></div>
<div><span class="e" id="q_106c1c67112325eb_3">
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> <
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I
changed my SGA size from 300mb to 1.5GB.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> <
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Users
are getting ora-03113 (See ora-03113.ora-code.com) end-of-file comminication channed.</span></font></p></div
>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> <
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Got this
error after starting the Database. It is <a onclick="return top.js.OpenExtLink
(window,event,this)" href="http://9.2.0.2/" target="_blank">9.2.0.2
</a> on solaris.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> <
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">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> object line object</span></font><
/p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> <
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Any idea
?</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> <
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">reards -
chirag </span></font></p></div></span></div></div></blockquote></div><br>
|
|
