{"id":836,"date":"2012-05-13T23:49:33","date_gmt":"2012-05-13T15:49:33","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=836"},"modified":"2012-05-17T14:52:08","modified_gmt":"2012-05-17T06:52:08","slug":"ora-7445dbgrlwritealertdetail_int%e5%92%8cora-4030%e5%af%bc%e8%87%b4%e5%ae%9e%e4%be%8b%e5%b4%a9%e6%ba%83","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=836","title":{"rendered":"ORA-7445(dbgrlWriteAlertDetail_int)\u548cORA-4030\u5bfc\u81f4\u5b9e\u4f8b\u5d29\u6e83"},"content":{"rendered":"<p>\u5ba2\u623711.2.0.2 RAC for Solaris 10 sparc\u5355\u5b9e\u4f8b\u51fa\u73b0ORA-7445\u548cORA-4030\u64cd\u4f5c\uff0c\u5bfc\u81f4\u5b9e\u4f8b\u5d29\u6e83\u3002<br \/>\n\u8fd9\u4e2a\u9519\u8bef\u6bd4\u8f83\u4e25\u91cd\uff1a<\/p>\n<pre lang='SQL'>2012-05-04 02:02:26.403000 +08:00\r\nArchived Log entry 949 added for thread 1 sequence 518 ID 0x70a64e83 dest 1:\r\nArchived Log entry 950 added for thread 1 sequence 519 ID 0x70a64e83 dest 1:\r\nThread 1 advanced to log sequence 521 (after internal thread enable)\r\nThread 2 opened at log sequence 441\r\nCurrent log# 4 seq# 441 mem# 0: \/orcldata1\/orcl\/redo04.log\r\nCurrent log# 4 seq# 441 mem# 1: \/orcldata2\/orcl\/redo04.log\r\nSuccessful open of redo thread 2\r\nMTTR advisory is disabled because FAST_START_MTTR_TARGET is not set\r\nSMON: enabling cache recovery\r\nARC3: Archival started\r\nARC0: STARTING ARCH PROCESSES COMPLETE\r\n2012-05-04 02:02:27.570000 +08:00\r\n[374] Successfully onlined Undo Tablespace 5.\r\nUndo initialization finished serial:0 start:903149023 end:903149480 diff:457 (4 seconds)\r\nVerifying file header compatibility for 11g tablespace encryption..\r\nVerifying 11g file header compatibility for tablespace encryption completed\r\nRedo thread 1 internally disabled at seq 521 (CKPT)\r\nSMON: enabling tx recovery\r\nDatabase Characterset is ZHS16GBK\r\nArchived Log entry 951 added for thread 1 sequence 520 ID 0x70a64e83 dest 1:\r\nARC3: Archiving disabled thread 1 sequence 521\r\nArchived Log entry 952 added for thread 1 sequence 521 ID 0x70a64e83 dest 1:\r\nNo Resource Manager plan active\r\nminact-scn: Inst 2 is now the master inc#:2 mmon proc-id:326 status:0x7\r\nminact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000\r\n2012-05-04 02:02:29.806000 +08:00\r\nStarting background process GTX0\r\nGTX0 started with pid=72, OS id=660\r\nStarting background process RCBG\r\nRCBG started with pid=73, OS id=662\r\nreplication_dependency_tracking turned off (no async multimaster replication found)\r\nThread 2 advanced to log sequence 442 (LGWR switch)\r\nCurrent log# 3 seq# 442 mem# 0: \/orcldata1\/orcl\/redo03.log\r\nCurrent log# 3 seq# 442 mem# 1: \/orcldata2\/orcl\/redo03.log\r\nArchived Log entry 953 added for thread 2 sequence 441 ID 0x70a64e83 dest 1:\r\n2012-05-04 02:02:31.733000 +08:00\r\nStarting background process QMNC\r\n2012-05-04 02:02:37.268000 +08:00\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFF5EF8] [PC:0x108068724, dbgrlWriteAlertDetail_int()+132] [flags: 0x0, count: 1]\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFF5FF4] [PC:0xFFFFFFFF7BD00F34, _memset()+52] [flags: 0x0, count: 1]\r\n2012-05-04 02:02:38.594000 +08:00\r\nErrors in file \/opt\/oracle\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_m000_666.trc (incident=156594):\r\nORA-07445: exception encountered: core dump [dbgrlWriteAlertDetail_int()+132] [SIGSEGV] [ADDR:0xFFFFFFFF7FFF5EF8] [PC:0x108068724] [Address not mapped to obj\r\nect] []\r\nORA-04030: out of process memory when trying to allocate 67108896 bytes (qesmmCheckPgaL,qesmmCheckPgaLimit:mem)\r\nIncident details in: \/opt\/oracle\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_156594\/orcl2_m000_666_i156594.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\nErrors in file \/opt\/oracle\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_psp0_266.trc (incident=156026):\r\nORA-07445: exception encountered: core dump [_memset()+52] [SIGSEGV] [ADDR:0xFFFFFFFF7FFF5FF4] [PC:0xFFFFFFFF7BD00F34] [Address not mapped to object] []\r\nIncident details in: \/opt\/oracle\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_156026\/orcl2_psp0_266_i156026.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\n2012-05-04 02:02:49.732000 +08:00\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFF2000] [PC:0x107D04724, dbgemdGetCallStackWFlag()+100] [flags: 0x0, count: 1]\r\nErrors in file \/opt\/oracle\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_dia0_282.trc:\r\nORA-07445: exception encountered: core dump [dbgemdGetCallStackWFlag()+100] [SIGSEGV] [ADDR:0xFFFFFFFF7FFF2000] [PC:0x107D04724] [Address not mapped to objec\r\nt] []\r\nORA-04030: out of process memory when trying to allocate 816 bytes (ksdhngmemctx_h,ksdhng:enod)\r\n2012-05-04 02:02:55.200000 +08:00\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFF2000] [PC:0x107D04724, dbgemdGetCallStackWFlag()+100] [flags: 0x0, count: 1]\r\nErrors in file \/opt\/oracle\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_diag_274.trc:\r\nORA-07445: exception encountered: core dump [dbgemdGetCallStackWFlag()+100] [SIGSEGV] [ADDR:0xFFFFFFFF7FFF2000] [PC:0x107D04724] [Address not mapped to objec\r\nt] []\r\nORA-04030: out of process memory when trying to allocate 32128 bytes (pga heap,grpsvc msg)\r\n2012-05-04 02:02:58.724000 +08:00\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\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\n2012-05-04 02:04:01.919000 +08:00\r\nPMON (ospid: 264): terminating the instance due to error 490\r\n2012-05-04 02:04:05.129000 +08:00\r\nInstance terminated by PMON, pid = 264<\/pre>\n<p>\u6570\u636e\u5e93\u7684\u542f\u52a8\u64cd\u4f5c\u8fd8\u6ca1\u5b8c\u6210\uff0c\u5c31\u78b0\u5230ORA-7445 [dbgrlWriteAlertDetail_int]\u9519\u8bef\uff0c\u968f\u540e\u662fORA-04030\u9519\u8bef\uff0c\u63a5\u7740\u662fORA-07445[_memset]\u9519\u8bef\uff0c\u6700\u540e\u662fORA-7445[dbgemdGetCallStackWFlag]\u9519\u8bef\u3002\u800c\u8fd9\u4e00\u7cfb\u5217\u7684\u9519\u8bef\u51fa\u73b0\uff0c\u6700\u7ec8\u5bfc\u81f4\u4e86PMON\u7ed3\u675f\u4e86\u6570\u636e\u5e93\u5b9e\u4f8b\u3002<br \/>\n\u4ece\u9519\u8bef\u4fe1\u606f\u4e0a\u770b\uff0c\u548c\u5185\u5b58\u5206\u914d\u6709\u5173\uff0c\u4f46\u662f\u6570\u636e\u5e93\u521a\u542f\u52a8\uff0c\u600e\u4e48\u4f1a\u8fde67M\u7684\u5185\u5b58\u90fd\u65e0\u6cd5\u5206\u914d\u5462\uff0c\u67e5\u8be2MOS\u53d1\u73b0\uff0c\u539f\u6765\u662fSWAP\u7a7a\u95f4\u8017\u5c3d\u5bfc\u81f4\u7684\uff0c\u8be6\u7ec6\u63cf\u8ff0\u53ef\u4ee5\u53c2\u8003Instance crash ORA-7445 [_memset()+120] and ORA-4030 (QERHJ hash-joi,kllcqas:kllsltba) [ID 1071033.1]<br \/>\n\u68c0\u67e5\u7cfb\u7edf\u7684\u65e5\u5fd7\u4fe1\u606fmessage\uff1a<\/p>\n<pre lang='SQL'>May 4 02:02:14 orcl2 Had[5187]: [ID 702911 daemon.notice] VCS CRITICAL V-16-1-50086 Swap usage on orcl2 is 97%\r\nMay 4 02:02:33 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 666 (oracle)\r\nMay 4 02:02:33 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 674 (oracle)\r\nMay 4 02:02:33 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 668 (oracle)\r\nMay 4 02:02:34 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 266 (oracle)\r\nMay 4 02:02:35 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 666 (oracle)\r\nMay 4 02:02:35 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 668 (oracle)\r\nMay 4 02:02:35 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 674 (oracle)\r\nMay 4 02:02:35 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 266 (oracle)\r\nMay 4 02:02:36 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 666 (oracle)\r\nMay 4 02:02:36 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 674 (oracle)\r\nMay 4 02:02:36 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 668 (oracle)\r\nMay 4 02:02:36 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 266 (oracle)\r\nMay 4 02:02:37 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 666 (oracle)\r\nMay 4 02:02:37 orcl2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 668 (oracle)<\/pre>\n<p>\u679c\u7136\u627e\u5230\u5927\u91cf\u7684SWAP\u7a7a\u95f4\u4e0d\u8db3\u7684\u544a\u8b66\uff0c\u5bf9\u4e8eSolaris\u7cfb\u7edf\u800c\u8a00\uff0c\u6e05\u7406\/tmp\u7a7a\u95f4\uff0c\u7136\u540e\u91cd\u542f\u6570\u636e\u5e93\uff0c\u95ee\u9898\u4e0d\u518d\u51fa\u73b0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623711.2.0.2 RAC for Solaris 10 sparc\u5355\u5b9e\u4f8b\u51fa\u73b0ORA-7445\u548cORA-4030\u64cd\u4f5c\uff0c\u5bfc\u81f4\u5b9e\u4f8b\u5d29\u6e83\u3002 \u8fd9\u4e2a\u9519\u8bef\u6bd4\u8f83\u4e25\u91cd\uff1a 2012-05-04 02:02:26.403000 +08:00 Archived Log entry 949 added for thread 1 sequence 518 ID 0x70a64e83 dest 1: Archived Log entry 950 added for thread 1 sequence 519 ID 0x70a64e83 dest 1: Thread 1 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=836\">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":[701,490,703,702,119,118,277,252,700],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-du","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/836"}],"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=836"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/836\/revisions"}],"predecessor-version":[{"id":837,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/836\/revisions\/837"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=836"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=836"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}