Skip to Content
Author's profile photo Former Member

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

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.

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Fidel Vales
      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.

      Author's profile photo Former Member
      Former Member
      Blog 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.