客户在进行OLAP的导入时出现了这个错误。
数据库版本为10.2.0.3，除了这两个错误外，同时还出现了其他的错误：
Mon Jul 30 23:49:08 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xAF509008], [], [], [], [], [], [] Mon Jul 30 23:49:09 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xAF50AF34], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xAF509008], [], [], [], [], [], [] Mon Jul 30 23:49:21 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xAF509008], [], [], [], [], [], [] Mon Jul 30 23:49:23 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xAF50AF34], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xAF509008], [], [], [], [], [], [] Mon Jul 30 23:49:35 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xAF509008], [], [], [], [], [], [] Mon Jul 30 23:49:36 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xAF50AF34], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xAF509008], [], [], [], [], [], [] Mon Jul 30 23:49:48 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] Mon Jul 30 23:49:49 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [17125], [0x0], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] Mon Jul 30 23:50:02 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] |
导致问题的就是OLAP的imp操作，查询MOS发现Bug 7526250 : EXEC DBMS_AW.EXECUTE FAILS WITH ORA-600 [KGHFREMPTY:DS] AND ORA-600 [KGHASP1]描述的就是当前的问题，数据库版本同样也是10.2.0.3，这个bug的基本BUG指向：Bug 7395130 : ORA-4030 ERROR DURING EIF IMPORT USING THE ‘UPDATE’ OPTION。
Oracle在执行OLAP的EIF导入时，可能出现内存泄漏和ORA-4030等错误，这和当前数据库的现象完全相同。当前数据库中不但出现了ORA-4030的错误，而且还有明显的ORA-600[729]错误的出现。
Oracle在11.2中才FIXED了这个bug，而且目前没有看到这个bug的补丁，看来Oracle对于OLAP组件的支持还是赶不上DB。