| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent ORA-00600: internal error code
Thanks to everyone for the help.
The recreate controlfile/recover/reset logs process did work...I just had to specify the correct online redo log for the recovery.
Thanks again for all the help
John
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante_at_labor.state.ny.us]
Sent: 04 May 2007 13:35
To: John Dunn
Subject: RE: Urgent ORA-00600: internal error code
John,
In case you need it, here is a sample "recreate controlfile" script from one of my databases.
Tom
This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Dunn
Sent: Friday, May 04, 2007 5:50 AM
To: Ghassan Salem
Cc: oracle-l_at_freelists.org
Subject: RE: Urgent ORA-00600: internal error code
Thanks for the reply
The redo logs are there(see below)
How do I "recreate the control files and reset logs"
-rw-rw---- 1 oracle9 oinstall 104858112 May 02 10:50 redo02.log
-rw-rw---- 1 oracle9 oinstall 104858112 May 02 03:19 redo01.log
-rw-rw---- 1 oracle9 oinstall 104858112 May 01 08:27 redo03.log
John
From: Ghassan Salem [mailto:salem.ghassan_at_gmail.com]
Sent: 04 May 2007 09:50
To: John Dunn
Cc: oracle-l_at_freelists.org
Subject: Re: Urgent ORA-00600: internal error code
This indicates a failure to find current redo logs, try to insure they are there, otherwise try to recreate the controil file and reset logs;
rgds
On 5/4/07, John Dunn <JDunn_at_sefas.com> wrote:
Following the replacement of a disk I did a mksysb restore on a AIX 5.2 machine running Oracle 9.2
All the Oracle software, data files etc were on a tar tape that has also been restored.
But now when I try to startup Oracle I get the message
ORA-00600: internal error code, arguments: [3004], [1], [0], [0], [], [], [],
[]
Does anyone have any advice or information on this error?
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 04 2007 - 07:40:37 CDT
 |
 |