Re: ora- 600 and ora -03113

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_at_labor.state.ny.us> wrote:
>
> 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
>
> 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