topic Re: Getting Ora-3113 caused by 0ra-00600 in Operating System - HP-UX

Getting Ora-3113 caused by 0ra-00600

Boniface Chiwenda_1 — Tue, 05 Jul 2005 07:10:40 GMT

Hi everyone

Iam running oracle 8i on unixware 7.1.1.

Problem.

The server was shutdown without shutting down oracle and when starting the database the Iam getting ora-3113 just after mounting the database but before opening the database.
I checked the alert.log and there was an error ora-00600 and followed the error in the trace file and this is what it is point to .
ora-00600; internal error code; argument;[3705],[1],[1],[1],[2],[],[],[]
and because of this error the database can not start.
May somebody how has come a cross this error help.

waiting to hear from you.
Regards

Bonnie.

Re: Getting Ora-3113 caused by 0ra-00600

Patti Johnson — Tue, 05 Jul 2005 07:48:52 GMT

Bonnie,

Take a look at Metalink Note:1054592.6. Sounds like the controlfile is out of sync and needs to be recreated. Below is part of the note.

The Alert log shows ORA-600[3705]

Solution Description
====================
1. Issue the command 'Alter Database Backup Controlfile to Trace;'

2. Edit the subsequent trace file.

a. Remove everything above the 'STARTUP NOMOUNT' line.
b. Change 'STARTUP NOMOUNT' to
'STARTUP NOMOUNT PFILE='.

3. Run the create controlfile script.

Re: Getting Ora-3113 caused by 0ra-00600

Boniface Chiwenda_1 — Tue, 05 Jul 2005 09:38:59 GMT

Thanks Patti

I tried the suggested solution but i was getting ora-3114 oracle not available.

logged into the system as oracle, then svrmgrl, and connect internal.
then Issued the command and then it gave me the above error.

what should i do before issuing these suggested solutions?

waiting to hear from you soon.

Thanks once again.

Regards

Bonnie.

Re: Getting Ora-3113 caused by 0ra-00600

Patti Johnson — Tue, 05 Jul 2005 10:07:54 GMT

Bonnie,

Do a startup mount, then issue the 'alter database...' don't try and open the db.
You stated that the ora-3113 is just after mounting the db but before opening.

Patti

Re: Getting Ora-3113 caused by 0ra-00600

Boniface Chiwenda_1 — Tue, 05 Jul 2005 10:29:25 GMT

Thanks Patti

Let me try it I will get back to you.

Regards

Bonnie.

Re: Getting Ora-3113 caused by 0ra-00600

Greg OBarr — Wed, 06 Jul 2005 10:03:32 GMT

You should have multiple copies of the control file. There may be a chance that one or more of them are OK, depending on what actually happened when the system went down. You may want to try locating all your control files and comparing the date and time on each of them. If they are different sizes or different date/timestamps, try backing them all up by making copies as in:

# cp -rp /u01/control01.ctl /u01/control01.ctl.SAVE

Then take the one with the latest date/timestamp and copy it to the others. If you have three copies of the controlfile, and control02.ctl has the latest date/timestamp, try:

# cp -rp /u02/control02.ctl /u01/control01.ctl

etc, for the other copies.

It's worth a try, in my opinion. I believe that if you re-create the controlfile, you're going to have to use "alter database open resetlogs", which you want to avoid if possible.

-greg

Re: Getting Ora-3113 caused by 0ra-00600

Boniface Chiwenda_1 — Thu, 07 Jul 2005 01:52:11 GMT

Thanks Patti and Greg for your support.

I had to recreate the controlfile and managed to open the database. Right now the system is up and running and people are working with no problem.

Thanks again for your help.

Regards

Bonnie.

Re: Getting Ora-3113 caused by 0ra-00600

Yogeeraj_1 — Thu, 07 Jul 2005 02:00:36 GMT

hi Bonnie,

good that you managed to get it running again.

Now, don't forget to establish a proper backup plan and ensure that this does not happen again... As well as any other database problems that be recovered easily...

(Hint: use RMAN)

kind regards
yogeeraj

Re: Getting Ora-3113 caused by 0ra-00600

Boniface Chiwenda_1 — Thu, 07 Jul 2005 02:05:44 GMT

Thanks yogeeraj