- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Getting Ora-3113 caused by 0ra-00600
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2005 12:10 AM
тАО07-05-2005 12:10 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2005 12:48 AM
тАО07-05-2005 12:48 AM
Re: Getting Ora-3113 caused by 0ra-00600
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2005 02:38 AM
тАО07-05-2005 02:38 AM
Re: Getting Ora-3113 caused by 0ra-00600
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2005 03:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2005 03:29 AM
тАО07-05-2005 03:29 AM
Re: Getting Ora-3113 caused by 0ra-00600
Let me try it I will get back to you.
Regards
Bonnie.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2005 03:03 AM
тАО07-06-2005 03:03 AM
Re: Getting Ora-3113 caused by 0ra-00600
# 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2005 06:52 PM
тАО07-06-2005 06:52 PM
Re: Getting Ora-3113 caused by 0ra-00600
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2005 07:00 PM
тАО07-06-2005 07:00 PM
Re: Getting Ora-3113 caused by 0ra-00600
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2005 07:05 PM
тАО07-06-2005 07:05 PM