客户的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

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。