ORA-7445: [kcrfw_update_blk_list]

老杨 2019-04-18
15
0 0
摘要:客户的11.2数据库测试环境中碰到了ORA-7445(kcrfw_update_blk_list)错误。详细的错误信息如下:TueDEC2...

问题描述

客户的11.2数据库测试环境中碰到了ORA-7445(kcrfw_update_blk_list)错误。
详细的错误信息如下:

Tue DEC 20 22:00:02 2011
BEGIN automatic SQL Tuning Advisor run FOR special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Tue DEC 20 22:00:46 2011
Exception [TYPE: SIGBUS, Non-existent physical address] [ADDR:0x62652000] [PC:0x216E0C4, kcrfw_update_blk_list()+196] [flags: 0x0, COUNT: 1]
Errors IN file /u01/app/oracle/diag/rdbms/fhacdb/fhacdb/trace/fhacdb_lgwr_24506.trc (incident=140173):
ORA-07445: exception encountered: core dump [kcrfw_update_blk_list()+196] [SIGBUS] [ADDR:0x62652000] [PC:0x216E0C4] [Non-existent physical address] []
Incident details IN: /u01/app/oracle/diag/rdbms/fhacdb/fhacdb/incident/incdir_140173/fhacdb_lgwr_24506_i140173.trc
USE ADRCI OR Support Workbench TO package the incident.
See Note 411.1 at My Oracle Support FOR error AND packaging details.
Tue DEC 20 22:00:48 2011
Dumping diagnostic DATA IN directory=[cdmp_20111220220048], requested BY (instance=1, osid=24506 (LGWR)), summary=[incident=140173].
Tue DEC 20 22:00:49 2011
PMON (ospid: 24482): terminating the instance due TO error 470
System state dump requested BY (instance=1, osid=24482 (PMON)), summary=[abnormal instance termination].
System State dumped TO trace file /u01/app/oracle/diag/rdbms/fhacdb/fhacdb/trace/fhacdb_diag_24492.trc
Tue DEC 20 22:00:50 2011
ORA-1092 : opitsk aborting process
Tue DEC 20 22:00:50 2011
License high water mark = 45
Dumping diagnostic DATA IN directory=[cdmp_20111220220049], requested BY (instance=1, osid=24482 (PMON)), summary=[abnormal instance termination].
Instance TERMINATED BY PMON, pid = 24482
USER (ospid: 17228): terminating the instance
Instance TERMINATED BY USER, pid = 17228
Tue DEC 20 22:01:03 2011
Adjusting the DEFAULT VALUE OF parameter parallel_max_servers
FROM 960 TO 685 due TO the VALUE OF parameter processes (700)
Starting ORACLE instance (normal)
WARNING: You are trying TO USE the MEMORY_TARGET feature. This feature requires the /dev/shm file system TO be mounted FOR at least 7868514304 bytes. /dev/shm IS either NOT mounted OR IS mounted WITH available SPACE less than this SIZE. Please fix this so that MEMORY_TARGET can WORK AS expected. CURRENT available IS 7857356800 AND used IS 562315264 bytes. Ensure that the mount point IS /dev/shm FOR this directory.
memory_target needs larger /dev/shm
Wed DEC 21 09:34:59 2011
Adjusting the DEFAULT VALUE OF parameter parallel_max_servers
FROM 960 TO 685 due TO the VALUE OF parameter processes (700)
Starting ORACLE instance (normal)
WARNING: You are trying TO USE the MEMORY_TARGET feature. This feature requires the /dev/shm file system TO be mounted FOR at least 7784628224 bytes. /dev/shm IS either NOT mounted OR IS mounted WITH available SPACE less than this SIZE. Please fix this so that MEMORY_TARGET can WORK AS expected. CURRENT available IS 7742439424 AND used IS 677232640 bytes. Ensure that the mount point IS /dev/shm FOR this directory.
memory_target needs larger /dev/shm


专家解答

对应的详细信息为:

*** 2011-12-20 22:00:46.889
*** SESSION ID:(586.1) 2011-12-20 22:00:46.889
*** CLIENT ID:() 2011-12-20 22:00:46.889
*** SERVICE NAME:(SYS$BACKGROUND) 2011-12-20 22:00:46.889
*** MODULE NAME:() 2011-12-20 22:00:46.889
*** ACTION NAME:() 2011-12-20 22:00:46.889
Dump continued FROM file: /u01/app/oracle/diag/rdbms/fhacdb/fhacdb/trace/fhacdb_lgwr_24506.trc
ORA-07445: exception encountered: core dump [kcrfw_update_blk_list()+196] [SIGBUS] [ADDR:0x62652000] [PC:0x216E0C4] [Non-existent physical address] []
========= Dump FOR incident 140173 (ORA 7445 [kcrfw_update_blk_list()+196]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [TYPE: SIGBUS, Non-existent physical address] [ADDR:0x62652000] [PC:0x216E0C4, kcrfw_update_blk_list()+196] [flags: 0x0, COUNT: 1]
Registers:
%rax: 0x0000000000015ffc %rbx: 0x0000000000000000 %rcx: 0x0000000000033908
%rdx: 0x000000006263c000 %rdi: 0x0000000000001d55 %rsi: 0x000000000000eaa8
%rsp: 0x00007fff89e18410 %rbp: 0x00007fff89e18440  %r8: 0x0000000000000002
 %r9: 0x0000000000015ffc %r10: 0x000000006263c000 %r11: 0x000000000000eaa8
%r12: 0x0000000000001d55 %r13: 0x00007fc19ece10b8 %r14: 0x0000000000000002
%r15: 0x0000000000000000 %rip: 0x000000000216e0c4 %efl: 0x0000000000010212
  kcrfw_update_blk_list()+170 (0x216e0aa) mov 0x5deb4677(%rip),%r12d
  kcrfw_update_blk_list()+177 (0x216e0b1) mov 0x5deb4660(%rip),%rdx
  kcrfw_update_blk_list()+184 (0x216e0b8) lea 0x0(,%r12,8),%r11
  kcrfw_update_blk_list()+192 (0x216e0c0) lea (%r11,%r12,4),%rax
> kcrfw_update_blk_list()+196 (0x216e0c4) mov %ebx,0x4(%rax,%rdx)
  kcrfw_update_blk_list()+200 (0x216e0c8) mov 0x5deb465a(%rip),%edx
  kcrfw_update_blk_list()+206 (0x216e0ce) mov 0x78(%r13),%rcx
  kcrfw_update_blk_list()+210 (0x216e0d2) mov 0x34(%rcx,%r15),%r15d
  kcrfw_update_blk_list()+215 (0x216e0d7) lea 0x0(,%rdx,8),%rax
*** 2011-12-20 22:00:46.901
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- SQL Statement (None) -----
CURRENT SQL information unavailable - no cursor.
----- Call Stack Trace -----
calling              CALL     entry                argument VALUES IN hex      
location             TYPE     point                (? means dubious VALUE)     
-------------------- -------- -------------------- ----------------------------
skdstdst()+36        CALL     kgdsdst()            000000000 ? 000000000 ?
                                                   7FC19EEA4098 ? 000000001 ?
                                                   000000001 ? 000000003 ?
ksedst1()+98         CALL     skdstdst()           000000000 ? 000000000 ?
                                                   7FC19EEA4098 ? 000000001 ?
                                                   000000000 ? 000000003 ?
ksedst()+34          CALL     ksedst1()            000000001 ? 000000001 ?
                                                   7FC19EEA4098 ? 000000001 ?
                                                   000000000 ? 000000003 ?
dbkedDefDump()+2741  CALL     ksedst()             000000001 ? 000000001 ?
                                                   7FC19EEA4098 ? 000000001 ?
                                                   000000000 ? 000000003 ?
ksedmp()+36          CALL     dbkedDefDump()       000000003 ? 000000003 ?
                                                   7FC19EEA4098 ? 000000001 ?
                                                   000000000 ? 000000003 ?
ssexhd()+2366        CALL     ksedmp()             000000003 ? 000000003 ?
                                                   7FC19EEA4098 ? 000000001 ?
                                                   000000000 ? 000000003 ?
__sighandler()       CALL     ssexhd()             000000007 ? 7FC19EEACD70 ?
                                                   7FC19EEACC68 ? 000000001 ?
                                                   000000000 ? 000000003 ?
kcrfw_update_blk_li  signal   __sighandler()       000001D55 ? 00000EAA8 ?
st()+196                                           06263C000 ? 000033908 ?
                                                   000000002 ? 000015FFC ?
kcrfw_post()+284     CALL     kcrfw_update_blk_li  7FC19ECE10B8 ? 00000EAA8 ?
                              st()                 06263C000 ? 000033908 ?
                                                   000000002 ? 000015FFC ?
kcrfw_redo_write()+  CALL     kcrfw_post()         7FFF89E18FB8 ? 00000EAA8 ?
2528                                               06263C000 ? 000033908 ?
                                                   000000002 ? 000015FFC ?
ksbabs()+771         CALL     kcrfw_redo_write()   7FFF89E18FB8 ? 000000018 ?
                                                   06263C000 ? 000033908 ?
                                                   000000002 ? 000015FFC ?
ksbrdp()+971         CALL     ksbabs()             7FFF89E18FB8 ? 000000018 ?
                                                   06263C000 ? 000033908 ?
                                                   000000002 ? 000015FFC ?
opirip()+618         CALL     ksbrdp()             7FFF89E18FB8 ? 000000018 ?
                                                   06263C000 ? 000033908 ?
                                                   000000002 ? 000015FFC ?
opidrv()+598         CALL     opirip()             000000032 ? 000000004 ?
                                                   7FFF89E1A178 ? 000033908 ?
                                                   000000002 ? 000015FFC ?
sou2o()+98           CALL     opidrv()             000000032 ? 000000004 ?
                                                   7FFF89E1A178 ? 000033908 ?
                                                   000000002 ? 000015FFC ?
opimai_real()+261    CALL     sou2o()              7FFF89E1A150 ? 000000032 ?
                                                   000000004 ? 7FFF89E1A178 ?
                                                   000000002 ? 000015FFC ?
ssthrdmain()+252     CALL     opimai_real()        000000000 ? 7FFF89E1A340 ?
                                                   000000004 ? 7FFF89E1A178 ?
                                                   000000002 ? 000015FFC ?
main()+196           CALL     ssthrdmain()         000000003 ? 7FFF89E1A340 ?
                                                   000000001 ? 000000000 ?
                                                   000000002 ? 000015FFC ?
__libc_start_main()  CALL     main()               000000003 ? 7FFF89E1A4E0 ?
+253                                               000000001 ? 000000000 ?
                                                   000000002 ? 000015FFC ?
_start()+36          CALL     __libc_start_main()  000A07804 ? 000000001 ?
                                                   7FFF89E1A4D8 ? 000000000 ?
                                                   000000002 ? 000015FFC ?

虽然这个错误信息在MOS上没有任何记录,根据错误信息和TRACE信息不难判断,导致问题的原因是由于内存空间不足所致。
由于配置的MEMORY_TARGET的值大于/dev/shm的值,导致Oracle在处理内存地址时出现了异常,从而导致数据库的崩溃。
那么解决问题的方法很简单,缩小MEMORY_TARGET的值,或增大/dev/shm的设置,确保MEMORY_TARGET小于/dev/shm,数据库即可正常启动。

「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
Oracle
订阅
欢迎订阅Oracle频道,订阅之后可以获取最新资讯和更新通知。
墨值排行
今日本周综合
近期活动
全部
相关课程
全部