Ora-0600

Hi Guys.

One of our clients place I have been getting ORA-0600 Internal Error.
I just want to know the reason behind this error.I am planning to re create the database and importing the data from the prevoius dump.
My alert file looks like this.



Sun Dec 22 15:29:56 2002
Thread 1 advanced to log sequence 865
Current log# 4 seq# 865 mem# 0: /oracle/oradata/ORA8/redoORA804.log
Sun Dec 22 15:30:33 2002
Errors in file /oracle/admin/ORA8/bdump/ora8_smon_388.trc:
ORA-00600: internal error code, arguments: [kfhpfh_03], [13], [1210], [], [], [], [], []
Sun Dec 22 15:30:48 2002
ORACLE Instance ORA8 (pid = 6) - Error 600 encountered while recovering transaction (5, 40).
Sun Dec 22 15:30:48 2002
Errors in file /oracle/admin/ORA8/bdump/ora8_smon_388.trc:
ORA-00600: internal error code, arguments: [kfhpfh_03], [13], [1210], [], [], [], [], []
Sun Dec 22 15:33:31 2002
Thread 1 advanced to log sequence 866
Current log# 2 seq# 866 mem# 0: /oracle/oradata/ORA8/redoORA802.log
Sun Dec 22 15:35:58 2002
Errors in file /oracle/admin/ORA8/bdump/ora8_smon_388.trc:
ORA-00600: internal error code, arguments: [kfhpfh_03], [13], [1210], [], [], [], [], []
Sun Dec 22 15:36:15 2002
ORACLE Instance ORA8 (pid = 6) - Error 600 encountered while recovering transaction (5, 40).
Sun Dec 22 15:36:15 2002
Errors in file /oracle/admin/ORA8/bdump/ora8_smon_388.trc:
ORA-00600: internal error code, arguments: [kfhpfh_03], [13], [1210], [], [], [], [], []
Sun Dec 22 15:37:05 2002
Thread 1 advanced to log sequence 867
Current log# 1 seq# 867 mem# 0: /oracle/app/oradata/ORA8/redoORA801.log
Sun Dec 22 15:38:56 2002
Thread 1 advanced to log sequence 868
Current log# 3 seq# 868 mem# 0: /oracle/app/oracle/oradata/ORA8/redoORA803.log


.
I think you gurus can help me.


Regards

Joe
:confused:

Hi jomon_s,

Did this ORA 600 occured during import?

Is there some trace file in u/b/cdump?
Maybe create a tar at Metalink.

Can you logmine the redolog see what is going on?

Regards,

Tycho

Hi.


I have got this error when I tried to drop a user tablespace.And there is a PMON trace generated in bdump location.


Regards

Joe

Use this link posted on another thread to get more information based on the first argument of the ORA-00600.

http://metalink.oracle.com/metalink/...1&blackframe=0

ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:

timeouts

file corruption

failed data checks in memory

hardware, memory, or I/O errors

incorrectly restored files

The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.

Action: Report this error to Oracle Customer Support after gathering the following information:

events that led up to the error

the operations that were attempted that led to the error

the conditions of the operating system and databases at the time of the error

any unusual circumstances that occurred before receiving the ORA-00600 message

contents of any trace files generated by the error

the relevant portions of the Alter files

Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.

I will call Oracle Support on any "ORA-00600" errors.

Regards,

I would check the link on metalink before going through the agony of opening a TAR or calling Oracle.

Last week, one of my apps received ORA-00600 only for a simple networking problem that was repaired by changing the connection information in the c/s based forms.

ORA-00600 may not be indicative of a disaster.

Hi..Guys


Thanks to all for the information given.


Regards

Joe