客户数据库出现大量的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定时启动。