{"id":833,"date":"2012-05-12T23:58:42","date_gmt":"2012-05-12T15:58:42","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=833"},"modified":"2012-05-17T14:02:04","modified_gmt":"2012-05-17T06:02:04","slug":"ora-600ksnpostksnigb%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=833","title":{"rendered":"ORA-600(ksnpost:ksnigb)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u623710.2.0.5 RAC for HP-UX ia64\u51fa\u73b0ORA-600(ksnpost:ksnigb)\u7684\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Wed Apr 25 16:32:21 UTC 2012\r\nErrors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_ora_17014.trc:\r\nORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb]\r\nWed Apr 25 16:32:55 UTC 2012\r\nTrace dumping is performing id=[cdmp_20120425163255]\r\nWed Apr 25 16:32:56 UTC 2012\r\nErrors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_ora_5511.trc:\r\nORA-12012: \u81ea\u52a8\u6267\u884c\u4f5c\u4e1a 8938 \u51fa\u9519\r\nORA-12801: \u5e76\u884c\u67e5\u8be2\u670d\u52a1\u5668 ORA-12801: \u5e76\u884c\u67e5\u8be2\u670d\u52a1\u5668 P122, instance orcldb2:orcl2 (2) \u4e2d\u53d1\u51fa\u9519\u8bef\u4fe1\u53f7\r\nORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb]\r\nORA-06512: \u5728 \"SYS.DBMS_STATS\", line 21275\r\n\u4e2d\u53d1\u51fa\u9519\u8bef\u4fe1\u53f7\r\nWed Apr 25 16:35:41 UTC 2012\r\nErrors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_ora_19966.trc:\r\nORA-27041: unable to open file\r\nHPUX-ia64 Error: 23: File table overflow\r\nAdditional information: 44\r\nAdditional information: 65598\r\nAdditional information: 2734688\r\nWed Apr 25 16:35:41 UTC 2012\r\nErrors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_ora_19966.trc:\r\nORA-27041: unable to open file\r\nHPUX-ia64 Error: 23: File table overflow\r\nAdditional information: 44\r\nAdditional information: 65598\r\nAdditional information: 2734688\r\nWed Apr 25 16:35:41 UTC 2012\r\nErrors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_ora_19966.trc:\r\nORA-27041: unable to open file\r\nHPUX-ia64 Error: 23: File table overflow\r\nAdditional information: 44\r\nAdditional information: 65598\r\nAdditional information: 2734688<\/pre>\n<p>\u8be6\u7ec6TRACE\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>orcldb2>more \/oracle\/app\/admin\/orcl\/bdump\/orcl2_ora_17014.trc\r\nDump file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_ora_17014.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, OLAP, Data Mining\r\nand Real Application Testing options\r\nORACLE_HOME = \/oracle\/app\/product\/10.2.0\/db_1\r\nSystem name:    HP-UX\r\nNode name:      orcldb2\r\nRelease:        B.11.31\r\nVersion:        U\r\nMachine:        ia64\r\nInstance name: orcl2\r\nRedo thread mounted by this instance: 2\r\nOracle process number: 0\r\nUnix process pid: 17014, image: oracle@orcldb2\r\nIoctl ASYNC_CONFIG error, errno = 1\r\n*** SERVICE NAME:(SYS$USERS) 2012-04-25 16:32:21.472\r\n*** SESSION ID:(377.37550) 2012-04-25 16:32:21.472\r\n*** 2012-04-25 16:32:21.472\r\nksedmp: internal or fatal error\r\nORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb]\r\nCurrent SQL statement for this session:\r\nselect \/*+ parallel_index(t,\"IDX_PRODUCT_ID\",96) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t,\"\r\nIDX_PRODUCT_ID\") *\/ count(*) as nrw,count(distinct sys_op_lbid(82769,'L',t.rowid)) as nlb,count(distinct \"PRODUCT_ID\") as ndk,sys_op_countchg(substrb(t.rowid\r\n,1,15),1) as clf from \"ORCL_UNICOM\".\"MESSAGE_LOG\" sample block (   .4377057550,1)  t where (\"PRODUCT_ID\" is not null) and (TBL$OR$IDX$PART$NUM(\"ORCL_UNICOM\".\"M\r\nESSAGE_LOG\",0,4,0,\"ROWID\") = :objn)\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\n40000000040333a0     call     4000000004035b60     000000000 ? 000000001 ?\r\n4000000004032b40     call     4000000004033360     000000000 ?\r\n                                                   C000000000000D20 ?\r\n                                                   4000000004032B40 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ?\r\n400000000407abb0     call     40000000040322c0     000000003 ?\r\n                                                   9FFFFFFFFFFEFC10 ?\r\n                                                   60000000000BA268 ?\r\n                                                   9FFFFFFFFFFF01E0 ?\r\n                                                   C000000000000999 ?\r\n                                                   400000000407ABB0 ?\r\n40000000098c33d0     call     400000000407ab40     9FFFFFFFFFFF0770 ?\r\n                                                   000000003 ?\r\n                                                   9FFFFFFFFFFF01F0 ?\r\n                                                   60000000000BA268 ?\r\n                                                   C000000000000612 ?\r\n                                                   40000000098C33D0 ?\r\n40000000098c41c0     call     40000000098c32a0     60000000000318D0 ?\r\n                                                   4000000001ADC4E0 ?\r\n                                                   6000000000032988 ?\r\n                                                   4000000001ADC4E0 ?\r\n                                                   9FFFFFFFFFFF07A0 ?\r\n4000000004030400     call     40000000098c4180     60000000000318D0 ?\r\n                                                   9FFFFFFFFD364638 ?\r\n                                                   9FFFFFFFFD364648 ?\r\n                                                   6000000000032D00 ?\r\n                                                   9FFFFFFFFFFF07A0 ?\r\n4000000002071430     call     4000000004030350     4000000000F67410 ?\r\n                                                   000000000 ?\r\n                                                   60000000000C6C98 ?\r\n40000000030c7ce0     call     40000000020713d0     C000001FF2838160 ?\r\n                                                   60000000000BA268 ?\r\n                                                   C000000000000797 ?\r\n                                                   40000000030C7CE0 ?\r\n                                                   9FFFFFFFFFFF07DC ?\r\n                                                   9FFFFFFFFFFF07E0 ?\r\n                                                   9FFFFFFFFFFF07D0 ?\r\n                                                   000000001 ?\r\n40000000030c8940     call     40000000030c7a50     C0000020351ED5A0 ?<\/pre>\n<p>\u67e5\u8be2MOS\uff0c\u53d1\u73b0\u548c\u95ee\u9898\u6587\u6863Get Various ORA-600 Error Followed By &#8220;HPUX-ia64 Error: 24: Too many open files&#8221; [ID 1061351.1]\u63cf\u8ff0\u5f97\u6bd4\u8f83\u63a5\u8fd1\u3002\u867d\u7136\u6587\u6863\u63cf\u8ff0\u7684\u95ee\u9898\u662fHPUX-ia64 Error: 24\uff0c\u800c\u5f53\u524d\u7684\u9519\u8bef\u662fHPUX-ia64 Error: 23: File table overflow\uff0c\u4f46\u662f\u4e8c\u8005\u7684\u672c\u8d28\u662f\u4e00\u6837\u7684\u3002<br \/>\n\u4ece\u9519\u8bef\u4fe1\u606f\u4e0a\u770b65598\u5df2\u7ecf\u8d85\u8fc7\u4e86\u8bbe\u7f6e\u503c65536\uff0c\u9488\u5bf9\u8fd9\u4e2a\u95ee\u9898\uff0c\u53ef\u4ee5\u901a\u8fc7\u8c03\u6574\u5185\u6838\u53c2\u6570\u7684\u65b9\u5f0f\u8fdb\u884c\u89e3\u51b3\uff0c\u53ef\u4ee5\u53c2\u8003\u6587\u6863How to Increase the Number of Open Files on HP-UX [ID 1264834.1]\u3002<br \/>\n\u800c\u5bf9\u4e8e\u5f53\u524d\u7684\u60c5\u51b5\uff0c\u95ee\u9898\u53d1\u751f\u5728\u5e76\u884c\u6267\u884c\u4e0a\uff0c\u5e76\u884c\u5ea6\u5f00\u523096\u663e\u7136\u8fc7\u5927\uff0c\u5c06\u5176\u964d\u81f3\u5e76\u884c\u5ea616\u5e94\u8be5\u5c31\u53ef\u4ee5\u907f\u514d\u8be5\u9519\u8bef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623710.2.0.5 RAC for HP-UX ia64\u51fa\u73b0ORA-600(ksnpost:ksnigb)\u7684\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Wed Apr 25 16:32:21 UTC 2012 Errors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_ora_17014.trc: ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb] Wed Apr 25 16:32:55 UTC 2012 Trace dumping is performing id=[cdmp_20120425163255] &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=833\">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":[697,696,699,698,8,152],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-dr","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/833"}],"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=833"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/833\/revisions"}],"predecessor-version":[{"id":834,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/833\/revisions\/834"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}