客户的Oracle 10201 for Windows环境频繁出现这个错误。
详细的错误信息为：
Fri DEC 16 16:27:02 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] Fri DEC 16 16:27:03 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] Fri DEC 16 16:27:03 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] Fri DEC 16 16:27:03 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] Fri DEC 16 16:27:03 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] . . . Fri DEC 16 16:27:08 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [] [] [] [] [] [] ORA-07445: exception encountered: core dump [] [] [] [] [] [] ORA-07445: exception encountered: core dump [] [] [] [] [] [] ORA-07445: exception encountered: core dump [] [] [] [] [] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] . . . |
这个错误出现后就会在告警日志中频繁的报错，并最终导致数据库崩溃。
检查对应的TRACE文件：
Dump file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc Fri DEC 16 16:27:02 2011 ORACLE V10.2.0.1.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Oracle DATABASE 10g Enterprise Edition Release 10.2.0.1.0 - Production WITH the Partitioning, OLAP AND DATA Mining options Windows Server 2003 Version V5.2 Service Pack 2 CPU : 16 - TYPE 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:5675M/8181M, Ph+PgF:7432M/9789M, VA:2641M/4095M Instance name: px Redo thread mounted BY this instance: 0 <none> Oracle process NUMBER: 0 Windows thread id: 5360, image: ORACLE.EXE *** 2011-12-16 16:27:02.539 ksedmp: internal OR fatal error ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] CURRENT SQL information unavailable - no SGA. ----- Call Stack Trace ----- calling CALL entry argument VALUES IN hex location TYPE point (? means dubious VALUE) -------------------- -------- -------------------- ---------------------------- 7D611D87 00000000 7D60F983 CALLrel 7D60F666 7D610C82 CALL??? 00000000 7D5342B0 CALL??? 00000000 _ssbev_env+40 CALL??? 00000000 _slzgetevar+278 CALLrel _ssbev_env+0 _kpummpin+686 CALLrel _slzgetevar+0 C32F3A8 607B5158 19 C32F388 20 0 _kpupin+81 CALLrel _kpummpin+0 C32F408 0 0 0 0 61E2E060 0 836A4C _kpkipgi+83 CALLrel _kpupin+0 2 0 0 0 0 0 836A4C _kpkipgn+14 CALLrel _kpkipgi+0 0 _kscnfy+1334 CALLreg 00000000 7 0 _opirip+58 CALLrel _kscnfy+0 7 0 _opidrv+857 CALLrel _opirip+0 32 4 C32FEC0 _sou2o+45 CALLrel _opidrv+0 32 4 C32FEC0 _opimai_real+227 CALLrel _sou2o+0 C32FEB4 32 4 C32FEC0 _opimai+92 CALLrel _opimai_real+0 3 C32FEEC _BackgroundThreadSt CALLrel _opimai+0 art@4+422 7D50FE1E CALLreg 00000000 --------------------- Binary Stack Dump --------------------- |
查询MOS后，确认是Windows平台上的bug，详情参考MS-Windows: ORA-7445 On functions: ssbev_env, slzgetevar + no SGA [ID 1305096.1]。这个bug影响10.2.0.5以前的Windows平台下的10g，导致问题的原因是一个未公布的Bug:8592848，Oracle在10.2.0.5和11.2.0.1中fixed了这个bug。