Skip to Content

You see following ORA-00600 error in ST22 dump or alert.log.

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

When you look into the relevant dev trace of the dump or
incident trace file referred in alert.log, you see the error happens when
running SQL statement like

“delete from <table name> where ..”.

    

Reason:

This issue is addressed as an oracle bug 19438874 which
happens in oracle release 11.2 to 12.1. It is fixed in future release 12.2.

Solution:

The bug fix has been delivered in following SBP version.

SBP 11.2.0.3.14 201505

SBP 11.2.0.4.6 201505

SBP 12.1.0.2.3 20505

Install the above SBP to fix the error.

As a workaround, you can set parameter “_fast_full_scan_enabled”
to FALSE. But this is not a recommended way.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Fidel Vales

    The intention is good but

    1) from My Oracle Support

    ORA-600 [qkaffsindex1] Deleting a Row with a Function Based Index (Doc ID 1943087.1)

    this seems to happen if you have a function based index which is not very normal in SAP

    2) there are patches for versions lower than 12.2

    3) If you are an SAP customer (you should if you are here) install the SBP 11.2.0.4.6 201505 or SBP 11.2.0.3.14 201505

    no need to set any UNDERSCORE parameter not mentioned in the parameter recommendations from SAP or any SAP note

    Please, Please, Please, do NOT recommend to set any underscore parameter. If you think it is needed then ask the SAP-Oracle team to create a note and refer to it.

    (0) 
    1. Ginny Guo Post author

      Hi Fidel,

      Thanks for your quick comment.

      I indeed saw some incidents created by our customers who met this ORA-00600 error. I found this bug in oracle website and created this blog, hoping this could help in case later some other customers meet the same issue.

      I have updated the blog about the SBP solution. I did not see this information in oracle website. So this important information was missing. Thanks for your info so much.

      (0) 

Leave a Reply