{"id":421,"date":"2011-12-25T20:16:04","date_gmt":"2011-12-25T12:16:04","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=421"},"modified":"2011-12-25T20:16:04","modified_gmt":"2011-12-25T12:16:04","slug":"ora-7445kcrfw_update_blk_list%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=421","title":{"rendered":"ORA-7445(kcrfw_update_blk_list)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u768411.2\u6570\u636e\u5e93\u6d4b\u8bd5\u73af\u5883\u4e2d\u78b0\u5230\u4e86ORA-7445(kcrfw_update_blk_list)\u9519\u8bef\u3002<br \/>\n\u8be6\u7ec6\u7684\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Tue Dec 20 22:00:02 2011\r\nBegin automatic SQL Tuning Advisor run for special tuning task \"SYS_AUTO_SQL_TUNING_TASK\"\r\nTue Dec 20 22:00:46 2011\r\nException [type: SIGBUS, Non-existent physical address] [ADDR:0x62652000] [PC:0x216E0C4, kcrfw_update_blk_list()+196] [flags: 0x0, count: 1]\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/fhacdb\/fhacdb\/trace\/fhacdb_lgwr_24506.trc (incident=140173):\r\nORA-07445: exception encountered: core dump [kcrfw_update_blk_list()+196] [SIGBUS] [ADDR:0x62652000] [PC:0x216E0C4] [Non-existent physical address] []\r\nIncident details in: \/u01\/app\/oracle\/diag\/rdbms\/fhacdb\/fhacdb\/incident\/incdir_140173\/fhacdb_lgwr_24506_i140173.trc\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nTue Dec 20 22:00:48 2011\r\nDumping diagnostic data in directory=[cdmp_20111220220048], requested by (instance=1, osid=24506 (LGWR)), summary=[incident=140173].\r\nTue Dec 20 22:00:49 2011\r\nPMON (ospid: 24482): terminating the instance due to error 470\r\nSystem state dump requested by (instance=1, osid=24482 (PMON)), summary=[abnormal instance termination].\r\nSystem State dumped to trace file \/u01\/app\/oracle\/diag\/rdbms\/fhacdb\/fhacdb\/trace\/fhacdb_diag_24492.trc\r\nTue Dec 20 22:00:50 2011\r\nORA-1092 : opitsk aborting process\r\nTue Dec 20 22:00:50 2011\r\nLicense high water mark = 45\r\nDumping diagnostic data in directory=[cdmp_20111220220049], requested by (instance=1, osid=24482 (PMON)), summary=[abnormal instance termination].\r\nInstance terminated by PMON, pid = 24482\r\nUSER (ospid: 17228): terminating the instance\r\nInstance terminated by USER, pid = 17228\r\nTue Dec 20 22:01:03 2011\r\nAdjusting the default value of parameter parallel_max_servers\r\nfrom 960 to 685 due to the value of parameter processes (700)\r\nStarting ORACLE instance (normal)\r\nWARNING: 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.\r\nmemory_target needs larger \/dev\/shm\r\nWed Dec 21 09:34:59 2011\r\nAdjusting the default value of parameter parallel_max_servers\r\nfrom 960 to 685 due to the value of parameter processes (700)\r\nStarting ORACLE instance (normal)\r\nWARNING: 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.\r\nmemory_target needs larger \/dev\/shm<\/pre>\n<p>\u5bf9\u5e94\u7684\u8be6\u7ec6\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>*** 2011-12-20 22:00:46.889\r\n*** SESSION ID:(586.1) 2011-12-20 22:00:46.889\r\n*** CLIENT ID:() 2011-12-20 22:00:46.889\r\n*** SERVICE NAME:(SYS$BACKGROUND) 2011-12-20 22:00:46.889\r\n*** MODULE NAME:() 2011-12-20 22:00:46.889\r\n*** ACTION NAME:() 2011-12-20 22:00:46.889\r\nDump continued from file: \/u01\/app\/oracle\/diag\/rdbms\/fhacdb\/fhacdb\/trace\/fhacdb_lgwr_24506.trc\r\nORA-07445: exception encountered: core dump [kcrfw_update_blk_list()+196] [SIGBUS] [ADDR:0x62652000] [PC:0x216E0C4] [Non-existent physical address] []\r\n========= Dump for incident 140173 (ORA 7445 [kcrfw_update_blk_list()+196]) ========\r\n----- Beginning of Customized Incident Dump(s) -----\r\nException [type: SIGBUS, Non-existent physical address] [ADDR:0x62652000] [PC:0x216E0C4, kcrfw_update_blk_list()+196] [flags: 0x0, count: 1]\r\nRegisters:\r\n%rax: 0x0000000000015ffc %rbx: 0x0000000000000000 %rcx: 0x0000000000033908\r\n%rdx: 0x000000006263c000 %rdi: 0x0000000000001d55 %rsi: 0x000000000000eaa8\r\n%rsp: 0x00007fff89e18410 %rbp: 0x00007fff89e18440  %r8: 0x0000000000000002\r\n %r9: 0x0000000000015ffc %r10: 0x000000006263c000 %r11: 0x000000000000eaa8\r\n%r12: 0x0000000000001d55 %r13: 0x00007fc19ece10b8 %r14: 0x0000000000000002\r\n%r15: 0x0000000000000000 %rip: 0x000000000216e0c4 %efl: 0x0000000000010212\r\n  kcrfw_update_blk_list()+170 (0x216e0aa) mov 0x5deb4677(%rip),%r12d\r\n  kcrfw_update_blk_list()+177 (0x216e0b1) mov 0x5deb4660(%rip),%rdx\r\n  kcrfw_update_blk_list()+184 (0x216e0b8) lea 0x0(,%r12,8),%r11\r\n  kcrfw_update_blk_list()+192 (0x216e0c0) lea (%r11,%r12,4),%rax\r\n> kcrfw_update_blk_list()+196 (0x216e0c4) mov %ebx,0x4(%rax,%rdx)\r\n  kcrfw_update_blk_list()+200 (0x216e0c8) mov 0x5deb465a(%rip),%edx\r\n  kcrfw_update_blk_list()+206 (0x216e0ce) mov 0x78(%r13),%rcx\r\n  kcrfw_update_blk_list()+210 (0x216e0d2) mov 0x34(%rcx,%r15),%r15d\r\n  kcrfw_update_blk_list()+215 (0x216e0d7) lea 0x0(,%rdx,8),%rax\r\n*** 2011-12-20 22:00:46.901\r\ndbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)\r\n----- SQL Statement (None) -----\r\nCurrent SQL information unavailable - no cursor.\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nskdstdst()+36        call     kgdsdst()            000000000 ? 000000000 ?\r\n                                                   7FC19EEA4098 ? 000000001 ?\r\n                                                   000000001 ? 000000003 ?\r\nksedst1()+98         call     skdstdst()           000000000 ? 000000000 ?\r\n                                                   7FC19EEA4098 ? 000000001 ?\r\n                                                   000000000 ? 000000003 ?\r\nksedst()+34          call     ksedst1()            000000001 ? 000000001 ?\r\n                                                   7FC19EEA4098 ? 000000001 ?\r\n                                                   000000000 ? 000000003 ?\r\ndbkedDefDump()+2741  call     ksedst()             000000001 ? 000000001 ?\r\n                                                   7FC19EEA4098 ? 000000001 ?\r\n                                                   000000000 ? 000000003 ?\r\nksedmp()+36          call     dbkedDefDump()       000000003 ? 000000003 ?\r\n                                                   7FC19EEA4098 ? 000000001 ?\r\n                                                   000000000 ? 000000003 ?\r\nssexhd()+2366        call     ksedmp()             000000003 ? 000000003 ?\r\n                                                   7FC19EEA4098 ? 000000001 ?\r\n                                                   000000000 ? 000000003 ?\r\n__sighandler()       call     ssexhd()             000000007 ? 7FC19EEACD70 ?\r\n                                                   7FC19EEACC68 ? 000000001 ?\r\n                                                   000000000 ? 000000003 ?\r\nkcrfw_update_blk_li  signal   __sighandler()       000001D55 ? 00000EAA8 ?\r\nst()+196                                           06263C000 ? 000033908 ?\r\n                                                   000000002 ? 000015FFC ?\r\nkcrfw_post()+284     call     kcrfw_update_blk_li  7FC19ECE10B8 ? 00000EAA8 ?\r\n                              st()                 06263C000 ? 000033908 ?\r\n                                                   000000002 ? 000015FFC ?\r\nkcrfw_redo_write()+  call     kcrfw_post()         7FFF89E18FB8 ? 00000EAA8 ?\r\n2528                                               06263C000 ? 000033908 ?\r\n                                                   000000002 ? 000015FFC ?\r\nksbabs()+771         call     kcrfw_redo_write()   7FFF89E18FB8 ? 000000018 ?\r\n                                                   06263C000 ? 000033908 ?\r\n                                                   000000002 ? 000015FFC ?\r\nksbrdp()+971         call     ksbabs()             7FFF89E18FB8 ? 000000018 ?\r\n                                                   06263C000 ? 000033908 ?\r\n                                                   000000002 ? 000015FFC ?\r\nopirip()+618         call     ksbrdp()             7FFF89E18FB8 ? 000000018 ?\r\n                                                   06263C000 ? 000033908 ?\r\n                                                   000000002 ? 000015FFC ?\r\nopidrv()+598         call     opirip()             000000032 ? 000000004 ?\r\n                                                   7FFF89E1A178 ? 000033908 ?\r\n                                                   000000002 ? 000015FFC ?\r\nsou2o()+98           call     opidrv()             000000032 ? 000000004 ?\r\n                                                   7FFF89E1A178 ? 000033908 ?\r\n                                                   000000002 ? 000015FFC ?\r\nopimai_real()+261    call     sou2o()              7FFF89E1A150 ? 000000032 ?\r\n                                                   000000004 ? 7FFF89E1A178 ?\r\n                                                   000000002 ? 000015FFC ?\r\nssthrdmain()+252     call     opimai_real()        000000000 ? 7FFF89E1A340 ?\r\n                                                   000000004 ? 7FFF89E1A178 ?\r\n                                                   000000002 ? 000015FFC ?\r\nmain()+196           call     ssthrdmain()         000000003 ? 7FFF89E1A340 ?\r\n                                                   000000001 ? 000000000 ?\r\n                                                   000000002 ? 000015FFC ?\r\n__libc_start_main()  call     main()               000000003 ? 7FFF89E1A4E0 ?\r\n+253                                               000000001 ? 000000000 ?\r\n                                                   000000002 ? 000015FFC ?\r\n_start()+36          call     __libc_start_main()  000A07804 ? 000000001 ?\r\n                                                   7FFF89E1A4D8 ? 000000000 ?\r\n                                                   000000002 ? 000015FFC ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u867d\u7136\u8fd9\u4e2a\u9519\u8bef\u4fe1\u606f\u5728MOS\u4e0a\u6ca1\u6709\u4efb\u4f55\u8bb0\u5f55\uff0c\u6839\u636e\u9519\u8bef\u4fe1\u606f\u548cTRACE\u4fe1\u606f\u4e0d\u96be\u5224\u65ad\uff0c\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u662f\u7531\u4e8e\u5185\u5b58\u7a7a\u95f4\u4e0d\u8db3\u6240\u81f4\u3002<br \/>\n\u7531\u4e8e\u914d\u7f6e\u7684MEMORY_TARGET\u7684\u503c\u5927\u4e8e\/dev\/shm\u7684\u503c\uff0c\u5bfc\u81f4Oracle\u5728\u5904\u7406\u5185\u5b58\u5730\u5740\u65f6\u51fa\u73b0\u4e86\u5f02\u5e38\uff0c\u4ece\u800c\u5bfc\u81f4\u6570\u636e\u5e93\u7684\u5d29\u6e83\u3002<br \/>\n\u90a3\u4e48\u89e3\u51b3\u95ee\u9898\u7684\u65b9\u6cd5\u5f88\u7b80\u5355\uff0c\u7f29\u5c0fMEMORY_TARGET\u7684\u503c\uff0c\u6216\u589e\u5927\/dev\/shm\u7684\u8bbe\u7f6e\uff0c\u786e\u4fddMEMORY_TARGET\u5c0f\u4e8e\/dev\/shm\uff0c\u6570\u636e\u5e93\u5373\u53ef\u6b63\u5e38\u542f\u52a8\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u768411.2\u6570\u636e\u5e93\u6d4b\u8bd5\u73af\u5883\u4e2d\u78b0\u5230\u4e86ORA-7445(kcrfw_update_blk_list)\u9519\u8bef\u3002 \u8be6\u7ec6\u7684\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Tue Dec 20 22:00:02 2011 Begin automatic SQL Tuning Advisor run for special tuning task &#8220;SYS_AUTO_SQL_TUNING_TASK&#8221; 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 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=421\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[323,322,324,118],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-6N","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/421"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=421"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/421\/revisions"}],"predecessor-version":[{"id":422,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/421\/revisions\/422"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}