Recently we migrated RAC databases from 10.2.0.4 AIX to 11.2.0.3 PSU1 on Redhat using transport tablespaces. As part of our tests, we setup flashback to a gurantee restore point. After several cycle of testing, we flashed back the database to the original save point, and it completed sucessfully. However, when users inserted or deleted on tables data belonged to the tablespace that we transported, application showed error ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [],
It was confirmed that we hit bug 1291956 . There are 3 solutions for this error.
1) Temporary workaround of moving the problem table to another tablespace.
alter table <table name> move tablespace <tablespace name>;
2) There is an additional workaround of setting "_fastpin_enable"=0 which is discussed in Document 12919564.8.
3) Long term resolution would be to apply one-off Patch:12919564.
We choose #3 and apply this one-off Patch. This patch overlays the PSU patch 13343438 . After applying the patch to the database home, it fixed insert/delete issues.
opatch lsinv | grep ^Patch
Patch 12919564 : applied on Mon Apr 16 13:32:53 CDT 2012
Patch 13343438 : applied on Wed Feb 22 15:56:35 CST 2012
Patch Description: "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Patch 13348650 : applied on Wed Feb 22 15:56:14 CST 2012
Patch Description: "Grid Infrastructure Patch Set Update : 11.2.0.3.1 (13348650)"
opatch lsinv -bugs_fixed | grep -i 12919564
12919564 12919564 Mon Apr 16 13:32:53 CDT 2012 ENCOUNTERED ORA-600 [KTBESC_PLUGGED] WHILE
