Re: ora- 600 and ora -03113
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- Date: Wed, 5 Oct 2005 13:34:37 -0400
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@xxxxxxxxxxxxxxxxx> 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@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
>
> 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:
