客户数据库出现大量的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/