-
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
-
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
-
try this link
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
David Knight
OCP DBA 8i, 9i, 10g
-
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,
-
may be uncomplicated
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.
David Knight
OCP DBA 8i, 9i, 10g
-
Hi..Guys
Thanks to all for the information given.
Regards
Joe
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|