{"id":620,"date":"2012-02-29T23:13:21","date_gmt":"2012-02-29T15:13:21","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=620"},"modified":"2012-03-01T18:24:03","modified_gmt":"2012-03-01T10:24:03","slug":"ora-600kjrparnoalloc%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=620","title":{"rendered":"ORA-600(kjrpar:noalloc)\u9519\u8bef"},"content":{"rendered":"<p>\u7531\u4e8eORA-4031\u5f15\u53d1\u7684ORA-600\u9519\u8bef\u3002<br \/>\n\u544a\u8b66\u65e5\u5fd7\u4e2d\u9519\u8bef\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Sat Jan 28 06:07:49 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_j000_21874.trc:\r\nORA-12012: error on auto execute of job 66\r\nORA-04031: unable to allocate 6592 bytes of shared memory (\"shared pool\",\"STANDARDSYS\",\"PL\/SQL MPCODE\",\"PKR: PL_UEP\")\r\nSat Jan 28 06:08:15 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_j000_21874.trc:\r\nORA-12012: error on auto execute of job 87\r\nORA-04031: unable to allocate 6592 bytes of shared memory (\"shared pool\",\"STANDARDSYS\",\"PL\/SQL MPCODE\",\"PKR: PL_UEP\")\r\nSat Jan 28 06:08:50 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_j000_21874.trc:\r\nORA-12012: error on auto execute of job 66\r\nORA-04031: unable to allocate 6592 bytes of shared memory (\"shared pool\",\"STANDARDSYS\",\"PL\/SQL MPCODE\",\"PKR: PL_UEP\")\r\nSat Jan 28 06:09:50 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_j000_21874.trc:\r\nORA-12012: error on auto execute of job 66\r\nORA-04031: unable to allocate 6592 bytes of shared memory (\"shared pool\",\"STANDARDSYS\",\"PL\/SQL MPCODE\",\"PKR: PL_UEP\")\r\nSat Jan 28 06:10:15 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_j000_21874.trc:\r\nORA-12012: error on auto execute of job 87\r\nORA-04031: unable to allocate 6592 bytes of shared memory (\"shared pool\",\"STANDARDSYS\",\"PL\/SQL MPCODE\",\"PKR: PL_UEP\")\r\nSat Jan 28 06:10:51 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_j000_21874.trc:\r\nORA-12012: error on auto execute of job 66\r\nORA-04031: unable to allocate 6592 bytes of shared memory (\"shared pool\",\"STANDARDSYS\",\"PL\/SQL MPCODE\",\"PKR: PL_UEP\")\r\nSat Jan 28 06:11:34 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lmd0_24470.trc:\r\nORA-00600: internal error code, arguments: [kjrpar:noalloc], [1], [385], [0x1066F8850], [0x956F0C4C0], [0x94A9BE408], [], []\r\nSat Jan 28 06:11:35 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lmd0_24470.trc:\r\nORA-00600: internal error code, arguments: [kjrpar:noalloc], [1], [385], [0x1066F8850], [0x956F0C4C0], [0x94A9BE408], [], []\r\nSat Jan 28 06:11:35 2012\r\nTrace dumping is performing id=[cdmp_20120128061135]\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lmd0_24470.trc:\r\nORA-00600: internal error code, arguments: [kjrpar:noalloc], [1], [385], [0x1066F8850], [0x956F0C4C0], [0x94A9BE408], [], []\r\nSat Jan 28 06:11:41 2012\r\nLMD0: terminating instance due to error 482\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_pmon_24462.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lms2_24480.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lms5_24505.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lmon_24468.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lms3_24492.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lms0_24472.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lms4_24496.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lms1_24476.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_cjq0_24533.trc:\r\nORA-00604: error occurred at recursive SQL level 1\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_ckpt_24527.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:41 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_mman_24509.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:42 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_dbw0_24511.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:42 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lck0_24724.trc:\r\nORA-00482: LMD* process terminated with error\r\nSat Jan 28 06:11:42 2012\r\nErrors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_lgwr_24517.trc:\r\nORA-00482: LMD* process terminated with error<\/pre>\n<p>\u6839\u636eMOS\u63cf\u8ff0\uff0c\u8fd9\u4e2aORA-600\u7684\u9519\u8bef\u6e90\u4e8eORA-4031\u9519\u8bef\uff1aORA-600[kjrpar:noalloc] Error Raised in the LMD Process [ID 864377.1]\u3002\u5347\u7ea7\u523011.2\u300111.1.0.7\u548c10.2.0.5\u53ef\u4ee5\u907f\u514d\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u867d\u7136\u5bfc\u81f4\u9519\u8bef\u7684\u672c\u8d28\u662fORA-4031\uff0c\u4f46\u662f\u5f53\u524d\u7684\u8fd9\u4e2a\u9519\u8bef\u5f15\u53d1\u4e86LMD\u8fdb\u7a0b\u7684\u5f02\u5e38\u9000\u51fa\uff0c\u5e76\u6700\u7ec8\u5bfc\u81f4\u6570\u636e\u5e93\u7684\u5d29\u6e83\uff0c\u56e0\u6b64\u5bf9\u4e8e\u5f53\u524d\u7684\u6570\u636e\u5e93\u800c\u8a00\uff0c\u8fd9\u4e2a\u9519\u8bef\u7684\u4e25\u91cd\u7a0b\u5ea6\u751a\u81f3\u66f4\u751a\u4e8eORA-4031\u3002<br \/>\n\u4ece\u6570\u636e\u5e93\u7684\u521d\u59cb\u5316\u53c2\u6570\u8fdb\u884c\u5206\u6790\uff0c\u8fd9\u4e2a\u6570\u636e\u5e93\u7684\u5171\u4eab\u6c60\u914d\u7f6e\u786e\u5b9e\u4e0d\u8db3\uff0c\u56e0\u6b64\u5728\u77ed\u65f6\u95f4\u65e0\u6cd5\u5347\u7ea7\u7684\u60c5\u51b5\u4e0b\uff0c\u589e\u5927\u5171\u4eab\u6c60\u7684\u5185\u5b58\u8bbe\u7f6e\u662f\u76ee\u524d\u907f\u514d\u8fd9\u4e2a\u95ee\u9898\u7684\u6700\u597d\u529e\u6cd5\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7531\u4e8eORA-4031\u5f15\u53d1\u7684ORA-600\u9519\u8bef\u3002 \u544a\u8b66\u65e5\u5fd7\u4e2d\u9519\u8bef\u5982\u4e0b\uff1a Sat Jan 28 06:07:49 2012 Errors in file \/export\/home\/OracleHomes\/admin\/jykfdb\/bdump\/jykfdb1_j000_21874.trc: ORA-12012: error on auto execute of job 66 ORA-04031: unable to allocate 6592 bytes of shared memory (&#8220;shared pool&#8221;,&#8221;STANDARDSYS&#8221;,&#8221;PL\/SQL MPCODE&#8221;,&#8221;PKR: PL_UEP&#8221;) Sat Jan 28 06:08:15 2012 Errors in file &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=620\">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":[490,489,138,442,8,416],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-a0","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/620"}],"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=620"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/620\/revisions"}],"predecessor-version":[{"id":621,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/620\/revisions\/621"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}