ora- 600 and ora -03113 2005-10-05 - By Chirag DBA
Thats is what I am doing now. getting the original init.ora in process.
- chirag
On 10/5/05, Mercadante, Thomas F (LABOR) <
Thomas.Mercadante@(protected)> wrote:
>
> 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
>
> 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>Thats is what I am doing now. getting the original init.ora in process.<
/div>
<div> </div>
<div> - chirag<br><br> </div>
<div><span class="gmail_quote">On 10/5/05, <b class="gmail_sendername"
>Mercadante, Thomas F (LABOR)</b> <<a href="mailto:Thomas.Mercadante@(protected)
.state.ny.us">Thomas.Mercadante@(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 style="FONT-SIZE: 10pt; COLOR
: navy; FONT-FAMILY: Arial">The Ora-3113 (See Ora-3113.ora-code.com) is maybe because the database has not
been cleanly shut down yet. Did you try:</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR
: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR
: navy; FONT-FAMILY: Arial">Reset the init.ora params to what they were before
you did anything.</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR
: navy; FONT-FAMILY: Arial">Shutdown abort.</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR
: navy; FONT-FAMILY: Arial">Startup.</span></font></p>
<p><font face="Arial" color="navy" size="2"><span 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> 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></p></div>
<div><span class="e" id="q_106c1d64635712ae_1">
<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">This
error has started from last night and DB is being shutdown for cold backup.<
/span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">We got
600 at night only, while shutting down the DB. (through scripts).</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">and
today morning users started complaining abt the performance and I changed the
SGA.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I put db
_block_buffers too hight for sure. </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">I get
ora-600 (See ora-600.ora-code.com) only then and not after that. Right now we are getting 0ra-03113.</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"
>hopefully making db_block_buffers will help.</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">regards
- chirag </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"><br><br>
</span></font></p></div>
<div>
<p><span><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">On
10/5/05, <b><span style="FONT-WEIGHT: bold">R J Zijlstra</span></b> <<a
onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:rmsah
@(protected)" target="_blank">
rmsah@(protected)</a>> wrote:</span></font></span> </p>
<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<br><span><b><span style="FONT-WEIGHT:
bold">To:</span></b> Oracle-L Freelists</span><br><span><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>
<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></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> <
/span></font></p></span></div></div></blockquote></div><br>
|
|
