ORA-600(kghfremptyds)和ORA-600(kghasp1)错误

客户在进行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。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-740775/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-740775/