RE: ora- 600 and ora -03113

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_xs4all.nl> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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  

--
http://www.freelists.org/webpage/oracle-l