{"id":810,"date":"2012-05-03T23:46:35","date_gmt":"2012-05-03T15:46:35","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=810"},"modified":"2012-05-04T16:37:14","modified_gmt":"2012-05-04T08:37:14","slug":"%e5%b9%b6%e8%a1%8c%e8%bf%9b%e7%a8%8b%e5%87%ba%e7%8e%b0ora-27090%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=810","title":{"rendered":"\u5e76\u884c\u8fdb\u7a0b\u51fa\u73b0ORA-27090\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u7684RAC\u6570\u636e\u5e93\u51fa\u73b0ORA-27090\u9519\u8bef\u3002<br \/>\n\u8be6\u7ec6\u7684\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Wed May  2 22:13:14 2012\r\nCompleted instance recovery at\r\n Thread 1: logseq 22430, block 190818, scn 5430629987\r\n 4110 data blocks read, 4503 data blocks written, 43017 redo blocks read\r\nWed May  2 22:13:15 2012\r\nThread 1 advanced to log sequence 22431 (thread recovery)\r\nWed May  2 22:13:16 2012\r\nErrors in file \/u01\/app\/oracle\/admin\/orcl\/bdump\/orcl2_p007_15968.trc:\r\nORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA\r\nLinux-x86_64 Error: 4: Interrupted system call\r\nAdditional information: 3\r\nAdditional information: 128\r\nAdditional information: 65536\r\nWed May  2 22:13:16 2012\r\nErrors in file \/u01\/app\/oracle\/admin\/orcl\/bdump\/orcl2_p008_15970.trc:\r\nORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA\r\nLinux-x86_64 Error: 4: Interrupted system call\r\nAdditional information: 3\r\nAdditional information: 128\r\nAdditional information: 65536\r\nWed May  2 22:13:16 2012\r\nErrors in file \/u01\/app\/oracle\/admin\/orcl\/bdump\/orcl2_p004_15962.trc:\r\nORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA\r\nLinux-x86_64 Error: 4: Interrupted system call\r\nAdditional information: 3\r\nAdditional information: 128\r\nAdditional information: 65536\r\n.\r\n.\r\n.\r\nWed May  2 22:13:16 2012\r\nErrors in file \/u01\/app\/oracle\/admin\/orcl\/bdump\/orcl2_p014_15995.trc:\r\nORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA\r\nLinux-x86_64 Error: 4: Interrupted system call\r\nAdditional information: 3\r\nAdditional information: 128\r\nAdditional information: 65536\r\nWed May  2 22:13:29 2012\r\nSMON: Parallel transaction recovery tried<\/pre>\n<p>\u95ee\u9898\u53d1\u751f\u5728RAC\u4e00\u4e2a\u8282\u70b9\u5d29\u6e83\u540e\uff0c\u6240\u6709\u7684\u9519\u8bef\u90fd\u53d1\u751f\u5728\u5e76\u884c\u8fdb\u7a0bPNNN\u4e0a\u3002\u67e5\u770b\u4e86\u4e00\u4e0bMOS\uff0c\u53d1\u73b0\u8fd9\u4e2a\u95ee\u9898\u662f\u7531\u4e8e\u7cfb\u7edf\u53c2\u6570\u914d\u7f6e\u4e0d\u5f53\u6240\u81f4\uff1aORA-27090: MESSAGE 27090 NOT FOUND; [ID 579108.1]\u3002<br \/>\n\u5185\u6838\u53c2\u6570\u7684\u503c\uff1aaio-max-nr\u8bbe\u7f6e\u592a\u4f4e\uff0c\u63a8\u8350\u8bbe\u7f6e\u4e3afs.aio-max-nr= 3145728\u3002\u4fee\u6539\u53c2\u6570\u4f7f\u7528sysctl \u2013p\u91cd\u65b0\u52a0\u8f7d\u53c2\u6570\u540e\uff0c\u91cd\u542f\u6570\u636e\u5e93\u5373\u53ef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u7684RAC\u6570\u636e\u5e93\u51fa\u73b0ORA-27090\u9519\u8bef\u3002 \u8be6\u7ec6\u7684\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Wed May 2 22:13:14 2012 Completed instance recovery at Thread 1: logseq 22430, block 190818, scn 5430629987 4110 data blocks read, 4503 data blocks written, 43017 redo blocks read Wed May 2 22:13:15 2012 Thread 1 advanced to &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=810\">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":[3],"tags":[664,667,666,665],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-d4","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/810"}],"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=810"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/810\/revisions"}],"predecessor-version":[{"id":811,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/810\/revisions\/811"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}