DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Ora-0600

  1. #1
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52

    Angry 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

  2. #2
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234
    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

  3. #3
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52
    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

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185

    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

  5. #5
    Join Date
    Dec 2002
    Posts
    36
    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,

  6. #6
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185

    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

  7. #7
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52
    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
  •  


Click Here to Expand Forum to Full Width