Wednesday, August 6, 2014

[RUEI] Upgrade Fails with Error: "ORA-00600: internal error code, arguments: [kkmmctbf:bad intcoln]"

Situation:
I'm upgrading from my current 12.1.0.X RUEI installation to the version 12.1.0.6 due to a malfunction of the TCP Diagnostic tool.
 
I followed the steps on the "Oracle® Real User Experience Insight Installation Guide 12c Release 5 (12.1.0.6) for Linux x86-64". I reached the step 13 on the section "3.11.1 Upgrading the Reporter System from RUEI 12.1.0.x" and got the following error:
[root@gualaca extra]# ./ruei-upgrade-12.1.0.6.sh rpm_post_install
____________________________________________________________

2014-08-05 14:52:18   rpm_post_install ...
____________________________________________________________

2014-08-05 14:52:18   make_processor_conf ...
2014-08-05 14:52:19   make_processor_conf done
____________________________________________________________
...
2014-08-05 16:29:47   ignore_failed_urls ...
2014-08-05 16:29:48   ignore_failed_urls done
____________________________________________________________

2014-08-05 16:29:48   fix_sesdiag_retention ...
2014-08-05 16:29:48   fix_sesdiag_retention done
____________________________________________________________

2014-08-05 16:29:48   delete_unreferenced_rules ...
    declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkmmctbf:bad intcoln], [6], [], [],
[], [], [], [], [], [], [], []
ORA-06512: at line 22
ORA-06512: at line 26


2014-08-05 16:31:27   delete_unreferenced_rules ERROR
____________________________________________________________

2014-08-05 16:31:27   convert_psesdiag_ecid ...
2014-08-05 16:31:28   convert_psesdiag_ecid done
____________________________________________________________

2014-08-05 16:31:28   migrate_interfaces ...
2014-08-05 16:31:28   migrate_interfaces done
____________________________________________________________

2014-08-05 16:31:28   drop_unused_userflow_tables ...
2014-08-05 16:31:29   drop_unused_userflow_tables done
2014-08-05 16:31:29   rpm_post_install ERROR

It seems like an error with the RUEI database.
 
Cause:
The error occurs on delete a row from a table that has a child table referenced with an ON DELETE CASCADE foreign key, and the child table contains a compound trigger.
 
Bug:
1435647.1: ORA-600 [kkmmctbf:bad intcoln] 
 
Solution:
Install this patch (13582702) on your RUEI database.
 
Note: The patch I'm sharing is for Linux x86-64. There are similar patches for other environments.