暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-7445: [_ssbev_env]

老杨 2019-04-18
1808

问题描述

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

查询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。

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论