{"id":1111,"date":"2012-08-16T23:05:57","date_gmt":"2012-08-16T15:05:57","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1111"},"modified":"2012-09-09T22:13:40","modified_gmt":"2012-09-09T14:13:40","slug":"ora-4030%e3%80%81ora-27300%e9%94%99%e8%af%af%e5%92%8c%e5%a4%a7%e9%87%8fora-7445%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1111","title":{"rendered":"ORA-4030\u3001ORA-27300\u9519\u8bef\u548c\u5927\u91cfORA-7445\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u623711.2 RAC\u73af\u5883\u51fa\u73b0\u5927\u91cf\u7684ORA-7445\u9519\u8bef\u3001ORA-4030\u9519\u8bef\u4ee5\u53caORA-27300\u3001ORA-27301\u548cORA-27302\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Sat Dec 31 02:33:18 2011\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p015_28613.trc:\r\nORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE5FE0] [PC:0xFFFFFFFF7ADA92B0] [Address not mapped to object] []\r\nORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba)\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p018_28624.trc:\r\nORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE5FE0] [PC:0xFFFFFFFF7ADA92B0] [Address not mapped to object] []\r\nORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba)\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFE5FE0] [PC:0xFFFFFFFF7ADA92B0, _ndoprnt()+4] [flags: 0x0, count: 1]Exception [type\r\n: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFE5EF0] [PC:0xFFFFFFFF7ADA92B0, _ndoprnt()+4] [flags: 0x0, count: 1]\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p019_28626.trc:\r\nORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE5FE0] [PC:0xFFFFFFFF7ADA92B0] [Address not mapped to object] []\r\nORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba)\r\n.\r\n.\r\n.\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p017_28617.trc:\r\nORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE5EF0] [PC:0xFFFFFFFF7ADA92B0] [Address not mapped to object] []\r\nORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba)\r\nSat Dec 31 02:33:21 2011\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_26985.trc (incident=385310):\r\nORA-04030: \u5728\u5c1d\u8bd5\u5206\u914d 123416 \u5b57\u8282 (QERHJ hash-joi,kllcqas:kllsltba) \u65f6\u8fdb\u7a0b\u5185\u5b58\u4e0d\u8db3\r\nIncident details in: \/app\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_385310\/orcl1_ora_26985_i385310.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\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\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\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nSat Dec 31 02:33:24 2011\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFE7088] [PC:0x10780A9C8, sskgds_init()+8] [flags: 0x0, count: 1]\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p014_28611.trc:\r\nORA-07445: exception encountered: core dump [sskgds_init()+8] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE7088] [PC:0x10780A9C8] [Address not mapped to object] []\r\nORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba)\r\nSat Dec 31 02:33:24 2011\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFE7088] [PC:0x10780A9C8, sskgds_init()+8] [flags: 0x0, count: 1]\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p023_28634.trc:\r\nORA-07445: exception encountered: core dump [sskgds_init()+8] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE7088] [PC:0x10780A9C8] [Address not mapped to object] []\r\nORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba)\r\nSat Dec 31 02:33:24 2011\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFE7088] [PC:0x10780A9C8, sskgds_init()+8] [flags: 0x0, count: 1]\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p020_28628.trc:\r\nORA-07445: exception encountered: core dump [sskgds_init()+8] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE7088] [PC:0x10780A9C8] [Address not mapped to object] []\r\nORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba)\r\nSat Dec 31 02:33:24 2011\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFE6F98] [PC:0x10780A9C8, sskgds_init()+8] [flags: 0x0, count: 1]\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p016_28615.trc:\r\nORA-07445: exception encountered: core dump [sskgds_init()+8] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE6F98] [PC:0x10780A9C8] [Address not mapped to object] []\r\nORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba)\r\n.\r\n.\r\n.\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p022_28632.trc:\r\nORA-07445: exception encountered: core dump [sskgds_init()+8] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE6F98] [PC:0x10780A9C8] [Address not mapped to object] []\r\nORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba)\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFC6CF8] [PC:0x107388144, kgdsdst()+36] [flags: 0x0, count: 1]\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_26985.trc (incident=385311):\r\nORA-07445: \u51fa\u73b0\u5f02\u5e38\u9519\u8bef: \u6838\u5fc3\u8f6c\u50a8 [kgdsdst()+36] [SIGSEGV] [ADDR:0xFFFFFFFF7FFC6CF8] [PC:0x107388144] [Address not mapped to object] []\r\nORA-04030: \u5728\u5c1d\u8bd5\u5206\u914d 123416 \u5b57\u8282 (QERHJ hash-joi,kllcqas:kllsltba) \u65f6\u8fdb\u7a0b\u5185\u5b58\u4e0d\u8db3\r\nIncident details in: \/app\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_385311\/orcl1_ora_26985_i385311.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\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\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\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\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nSat Dec 31 02:33:32 2011\r\nDumping diagnostic data in directory=[cdmp_20111231023332], requested by (instance=1, osid=26985), summary=[incident=385310].\r\nSat Dec 31 02:33:37 2011\r\nProcess m000 died, see its trace file\r\nSat Dec 31 02:34:35 2011\r\nProcess startup failed, error stack:\r\nSat Dec 31 02:34:36 2011\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_3787.trc (incident=386654):\r\nORA-04030: \u5728\u5c1d\u8bd5\u5206\u914d 32792 \u5b57\u8282 (QERHJ hash-joi,QERHJ Bit vector) \u65f6\u8fdb\u7a0b\u5185\u5b58\u4e0d\u8db3\r\nIncident details in: \/app\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_386654\/orcl1_ora_3787_i386654.trc\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_psp0_46.trc:\r\nORA-27300: OS system dependent operation:fork failed with status: 12\r\nORA-27301: OS failure message: Not enough space\r\nORA-27302: failure occurred at: skgpspawn3\r\nSat Dec 31 02:34:38 2011\r\nProcess m000 died, see its trace file\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\nProcess startup failed, error stack:\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_psp0_46.trc:\r\nORA-27300: OS system dependent operation:fork failed with status: 12\r\nORA-27301: OS failure message: Not enough space\r\nORA-27302: failure occurred at: skgpspawn3\r\nSat Dec 31 02:34:43 2011\r\nProcess J000 died, see its trace file\r\nkkjcre1p: unable to spawn jobq slave process \r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_cjq0_2549.trc:\r\nProcess startup failed, error stack:\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_psp0_46.trc:\r\nORA-27300: OS system dependent operation:fork failed with status: 12\r\nORA-27301: OS failure message: Not enough space\r\nORA-27302: failure occurred at: skgpspawn3\r\nProcess J000 died, see its trace file\r\nkkjcre1p: unable to spawn jobq slave process \r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_cjq0_2549.trc:\r\nSat Dec 31 02:34:47 2011\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFDE000] [PC:0x1008FD910, ksmpgd_init_ctx()+16] [flags: 0x0, count: 1]\r\nERROR: Unable to normalize symbol name for the following short stack (at offset 210):\r\ndbgexProcessError()+164<-dbgePostErrorKGE()+1320<-dbkePostKGE_kgsf()+44<-kgeade()+416<-kgerelv()+144<-kgerev()+56<-kgerec5()+32<-ssexhd()+1448<-__sighndlr()+\r\n12<-call_user_handler()+992<-ksmpgd_init_ctx()+16<-_$c1A.ksmpgd_scan_pga_heaps_local_detail()+24<-ksm_4030_dump_internal()+208<-ksmarfg()+912<-kghnospc()+429\r\n2<-kghalf()+1416<-qerhjInitializeManagementComponents()+1688<-qerhjFetch()+996<-rwsfcd()+108<-qerhjFetch()+460<-opifch2()+10836<-kpoal8()+3228<-opiodr()+1428\r\n<-ttcpip()+1056<-opitsk()+1528<-opiino()+1000<-opiodr()+1428<-opidrv()+1100<-sou2o()+92<-opimai_real()+304<-ssthrdmain()+320<-main()+308<-_start()+380\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_3787.trc (incident=386655):\r\nORA-07445: \u51fa\u73b0\u5f02\u5e38\u9519\u8bef: \u6838\u5fc3\u8f6c\u50a8 [ksmpgd_init_ctx()+16] [SIGSEGV] [ADDR:0xFFFFFFFF7FFDE000] [PC:0x1008FD910] [Address not mapped to object] []\r\nORA-04030: \u5728\u5c1d\u8bd5\u5206\u914d 32792 \u5b57\u8282 (QERHJ hash-joi,QERHJ Bit vector) \u65f6\u8fdb\u7a0b\u5185\u5b58\u4e0d\u8db3\r\nIncident details in: \/app\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_386655\/orcl1_ora_3787_i386655.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\nSat Dec 31 02:34:53 2011\r\nProcess startup failed, error stack:\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_psp0_46.trc:\r\nORA-27300: OS system dependent operation:fork failed with status: 12\r\nORA-27301: OS failure message: Not enough space\r\nORA-27302: failure occurred at: skgpspawn3\r\nProcess J000 died, see its trace file\r\nkkjcre1p: unable to spawn jobq slave process \r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_cjq0_2549.trc:\r\nProcess startup failed, error stack:\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_psp0_46.trc:\r\nORA-27300: OS system dependent operation:fork failed with status: 12\r\nORA-27301: OS failure message: Not enough space\r\nORA-27302: failure occurred at: skgpspawn3\r\n.\r\n.\r\n.<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u6574\u4e2a\u8fc7\u7a0b\u6570\u636e\u5e93\u7ecf\u5386\u4e86\u56db\u4e2a7445\u9519\u8bef\u5206\u522b\u4e3a\uff1aORA-7445[_ndoprnt]\u3001ORA-7445[sskgds_init]\u3001ORA-7445[kgdsdst]\u548cORA-7445[ksmpgd_init_ctx]\uff0c\u800c\u8fd9\u56db\u4e2aORA-7445\u663e\u7136\u90fd\u662fORA-4030\u9519\u8bef\u5bfc\u81f4\u7684\u3002\u800c\u5bfc\u81f4ORA-4030\u9519\u8bef\u7684\u539f\u56e0\uff0c\u663e\u7136\u662f\u968f\u540e\u64cd\u4f5c\u7cfb\u7edf\u9519\u8befORA-27300\u3001ORA-27301\u548cORA-27302\u9519\u8bef\u5bfc\u81f4\u7684\u3002<br \/>\n\u67e5\u8be2MOS\u53d1\u73b0\u548c\u6587\u6863Database Crashes With ORA-04030 ORA-07445 ORA-27300 ORA-27301 ORA-27302 [ID 580552.1]\u63cf\u8ff0\u7684\u95ee\u9898\u975e\u5e38\u4e00\u81f4\uff0c\u800c\u5bfc\u81f4\u95ee\u9898\u4ea7\u751f\u7684\u539f\u56e0\u548c\u521a\u624d\u5206\u6790\u7684\u4e00\u6837\uff0c\u7531\u4e8e\u7cfb\u7edfSWAP\u7a7a\u95f4\u4e0d\u8db3\u5bfc\u81f4\u4e86\u6570\u636e\u5e93\u7684\u5185\u5b58\u5206\u914d\u62a5\u9519\u3002<br \/>\n\u91ca\u653eSWAP\u6216\/tmp\u4e0b\u7684\u7a7a\u95f4\uff0c\u53ef\u4ee5\u907f\u514d\u9519\u8bef\u7684\u51fa\u73b0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623711.2 RAC\u73af\u5883\u51fa\u73b0\u5927\u91cf\u7684ORA-7445\u9519\u8bef\u3001ORA-4030\u9519\u8bef\u4ee5\u53caORA-27300\u3001ORA-27301\u548cORA-27302\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Sat Dec 31 02:33:18 2011 Errors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_p015_28613.trc: ORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE5FE0] [PC:0xFFFFFFFF7ADA92B0] [Address not mapped to object] [] ORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba) &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1111\">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":[972,970,971,973,198,57,58,119,118,199,969,968],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-hV","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1111"}],"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=1111"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1111\/revisions"}],"predecessor-version":[{"id":1112,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1111\/revisions\/1112"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}