ORA-7445(kgegec)错误

客户数据库出现大量的ORA-7445错误。

 

 

这是一个11.1.0.6 for Windows 64bit的环境，在告警日志中包含了大量的ORA-7445错误：

Thu Nov 10 00:00:43 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x75A20BE, kgegec()+76]
Thu Nov 10 00:00:43 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x75A20BE, kgegec()+76]
Thu Nov 10 00:00:43 2011
Errors in file d:\app\administrator\diag\rdbms\gvdb\gvdb\cdump\gvdbcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [kgegec()+76] [0x00000000075A20BE]
Thu Nov 10 00:00:43 2011
Errors in file d:\app\administrator\diag\rdbms\gvdb\gvdb\cdump\gvdbcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [kgegec()+76] [0x00000000075A20BE]
Thu Nov 10 00:01:03 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x75A20BE, kgegec()+76]
Thu Nov 10 00:01:03 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x75A20BE, kgegec()+76]
Thu Nov 10 00:01:03 2011
Errors in file d:\app\administrator\diag\rdbms\gvdb\gvdb\cdump\gvdbcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [kgegec()+76] [0x00000000075A20BE]
Thu Nov 10 00:01:03 2011
Errors in file d:\app\administrator\diag\rdbms\gvdb\gvdb\cdump\gvdbcore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [kgegec()+76] [0x00000000075A20BE]

检查MOS发现这是11.1.0.6上的一个bug：ORA-07445 [Kgegec()] [ID 566690.1]，而导致这个问题的产生的原因是SYSTEM或SYSMAN用户后台运行一个JOB：EXECUTE_EM_DBMS_JOB_PROCS。

如果要避免这个ORA-7445错误的产生，只需要通过DBMS_JOB包，禁止这个JOB定时启动。

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

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