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.
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.
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.