ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(kghfremptyds)和ORA-600(kghasp1)错误

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

原创 Linux操作系统 作者:yangtingkun 时间:2012-08-03 23:51:25 0 删除 编辑

客户在进行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博客 ” ,链接:https://blog.itpub.net/4227/viewspace-740775/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 小议ROWNUM
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1964
  • 访问量
    11076908