RE: ora- 600 and ora -03113
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <chiragdba@xxxxxxxxx>
- Date: Wed, 5 Oct 2005 13:31:15 -0400
The Ora-3113 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 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@xxxxxxxxx> 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 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: internal error code, arguments: [1113], [], [], [], [], [],
[], []
ORA-01089: 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
Other related posts: