{"id":109,"date":"2011-09-19T22:00:07","date_gmt":"2011-09-19T14:00:07","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=109"},"modified":"2011-09-19T22:00:07","modified_gmt":"2011-09-19T14:00:07","slug":"ora-600kkoiptinvalid-join-method%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=109","title":{"rendered":"ORA-600(kkoipt:invalid join method)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u768411.2.0.2\u6570\u636e\u5e93\u78b0\u5230\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Fri Sep 16 15:23:52 2011\r\nErrors in file \/u01\/diag\/rdbms\/ora1\/ora1\/trace\/ora1_ora_20382140.trc (incident=169704):\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [kkoipt:invalid join method], [1], [0], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/u01\/diag\/rdbms\/ora1\/ora1\/incident\/incdir_169704\/ora1_ora_20382140_i169704.trc\r\nFri Sep 16 15:24:00 2011\r\nDumping diagnostic data in directory=[cdmp_20110916152400], requested by (instance=1, osid=20382140), summary=[incident=169704].\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\n\u800c\u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\u5982\u4e0b\uff1a\r\nbash-3.2$ more \/u01\/diag\/rdbms\/ora1\/ora1\/incident\/incdir_169704\/ora1_ora_20382140_i169704.trc\r\nDump file \/u01\/diag\/rdbms\/ora1\/ora11\/incident\/incdir_169704\/ora1_ora_20382140_i169704.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\nORACLE_HOME = \/u01\/product\/11.2.0\/dbhome_1\r\nSystem name:    AIX\r\nNode name:      node1\r\nRelease:        1\r\nVersion:        6\r\nMachine:        00F6CD264C00\r\nInstance name: ora1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 193\r\nUnix process pid: 20382140, image: oracle@s180\r\n*** 2011-09-16 15:23:52.275\r\n*** SESSION ID:(29.7169) 2011-09-16 15:23:52.275\r\n*** CLIENT ID:() 2011-09-16 15:23:52.275\r\n*** SERVICE NAME:(ora1) 2011-09-16 15:23:52.275\r\n*** MODULE NAME:(TOAD 10.5.0.41) 2011-09-16 15:23:52.275\r\n*** ACTION NAME:() 2011-09-16 15:23:52.275\r\nDump continued from file: \/u01\/diag\/rdbms\/ora1\/ora1\/trace\/ora1_ora_20382140.trc\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [kkoipt:invalid join method], [1], [0], [], [], [], [], [], [], [], [], []\r\n========= Dump for incident 169704 (ORA 600 [kkoipt:invalid join method]) ========\r\n*** 2011-09-16 15:23:52.336\r\ndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)\r\n----- Current SQL Statement for this session (sql_id=7ukzmn3p6zby6) -----\r\nSELECT *\r\n  FROM (\r\n  SELECT   a.childpolicyno, a.policyno, e.exportno corpno, a.effectdate,\r\n                 TO_CHAR (a.lapsedate, 'yyyy-mm-dd') lapsedate, e.chnname,\r\n                 e.address, e.keyflag, e.specialflag, g.empname,\r\n                 g.secdeptname, f.TYPE, ROWNUM AS ID\r\n            FROM t_schildpolicy a,\r\n                 t_spolicy f,\r\n                 t_exportcorp e,\r\n                 t_nodeinfo d,\r\n                 v_employeecustomer g\r\n           WHERE f.policyno = a.policyno\r\n             AND f.insurantno = e.exportno\r\n             AND f.policyno = g.productid(+)\r\n             AND d.nodeid = f.nodeid\r\n             AND e.chnname LIKE '%%'\r\n             AND ((d.corpid = '3502'))\r\n             AND ROWNUM <= 10\r\n        ORDER BY a.policyno)\r\n WHERE ID BETWEEN 1 AND 10\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nskdstdst()+40        bl       107b6e01c            FFFFFFFFFFECCA8 ? 000002004 ?\r\n                                                   000000001 ? 000000003 ?\r\n                                                   000000000 ? 000000002 ?\r\n                                                   000000001 ? 000000000 ?\r\nksedst1()+104        call     skdstdst()           FFFFFFFFFFEBCB0 ? 000002004 ?\r\n                                                   110A597A0 ? 10A027B2C ?\r\n                                                   110A597A0 ? 000000000 ?\r\n                                                   FFFFFFFFFFEBDE0 ? 700000007 ?\r\nksedst()+40          call     ksedst1()            3030000000000 ? 002050033 ?\r\n                                                   10A027B20 ? 700000000025C ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   10A027180 ? 000000000 ?\r\ndbkedDefDump()+2828  call     ksedst()             FFFFFFFFFFEBE90 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 300000003 ?\r\nksedmp()+76          call     dbkedDefDump()       310A597A0 ? 1100010C8 ?\r\n                                                   FFFFFFFFFFEC490 ?\r\n                                                   28444040FFFEC66C ?\r\n                                                   100148568 ? 1096635A8 ?\r\n                                                   FFFFFFFFFFEC4E0 ? 11064B598 ?\r\nksfdmp()+88          call     ksedmp()             000000000 ? 000000000 ?\r\n                                                   0096635C3 ? 109CB2C50 ?\r\n                                                   200000000000000 ? 000000000 ?\r\n                                                   110C221E8 ? 110A597A0 ?\r\ndbgexPhaseII()+1212  call     ksfdmp()             000002004 ? 110A597A0 ?\r\n                                                   000000000 ? FFFFFFFFFFEC658 ?\r\n                                                   FFFFFFFFFFEC580 ?\r\n                                                   FFFFFFFFFFECCA8 ? 1001D04B8 ?\r\n                                                   110C221E8 ?\r\ndbgexProcessError()  call     dbgexPhaseII()       110A597A0 ? 110C203F8 ?\r\n+3604                                              0000296E8 ? 200000000 ?\r\n                                                   FFFFFFFFFFED258 ? 00000006A ?\r\n                                                   000000000 ? 000000000 ?\r\ndbgeExecuteForError  call     dbgexProcessError()  110A597A0 ? 110C221E8 ?\r\n()+72                                              100000000 ? 000000000 ?\r\n                                                   110D01C88 ? 000000000 ?\r\n                                                   110CADC78 ? 110C23F30 ?\r\ndbgePostErrorKGE()+  call     dbgeExecuteForError  FFFFFFFFFFF0830 ?\r\n1152                          ()                   B7417335409B9B1B ?\r\n                                                   FFFFFFFFFFF06F0 ? 0409B9800 ?\r\n                                                   10524EA10 ?\r\n                                                   2147AE154168E65F ?\r\n                                                   10524EA10 ? 000000000 ?\r\ndbkePostKGE_kgsf()+  call     dbgePostErrorKGE()   002050000 ? 001160000 ?\r\n64                                                 25810001330 ? 000000000 ?\r\n                                                   110001330 ? FFFFFFFFFFF1510 ?\r\n                                                   109613CD0 ? 110CB3F18 ?<\/pre>\n<p>\u8fd9\u4e2aSQL\u9519\u8bef\u7684\u5947\u7279\u4e4b\u5904\u5728\u4e8e\uff0c\u5982\u679c\u5c06ORDER BY\u8bed\u53e5\u4e2d\u7684a.policyno\u53d8\u6210\u5176\u4ed6\u5217\uff0c\u5219\u4e0d\u4f1a\u5bfc\u81f4\u9519\u8bef\uff0c\u751a\u81f3\u662f\u6362\u6210\u4e0e\u4e4b\u76f8\u7b49\u5173\u8054\u7684f.policyno\uff0c\u540c\u6837\u4e0d\u4f1a\u62a5\u9519\u3002<br \/>\n\u8fd9\u663e\u7136\u662f\u4e00\u4e2abug\uff0c\u67e5\u8be2metalink\u53d1\u73b0\uff0c\u5c45\u7136\u76ee\u524d\u552f\u4e00\u786e\u8ba4\u5f71\u54cd\u7684\u7248\u672c\u5c31\u662f11.2.0.2\uff0c\u8fd9\u4e2aBug\u7684\u63cf\u8ff0\u4e3aBug 12591252  Query with ORDER BY fails with ORA-600 [kkoipt:invalid join method]\u3002\u800cOracle\u7684\u89e3\u91ca\u662f\uff0c\u4f18\u5316\u5668\u8bd5\u56fe\u901a\u8fc7\u7d22\u5f15\u6765\u907f\u514d\u6392\u5e8f\u64cd\u4f5c\u65f6\uff0c\u53ef\u80fd\u5f15\u53d1\u8fd9\u4e2abug\u3002\u8fd9\u6b63\u597d\u8bf4\u660e\u4e86\u4e3a\u4ec0\u4e48SQL\u4e2d\u6362\u6210\u5176\u4ed6\u7684\u5217\u5c31\u4e0d\u4f1a\u5bfc\u81f4\u9519\u8bef\u3002<br \/>\n\u76ee\u524d\u8fd9\u4e2abug\u5728Windows\u5e73\u53f0\u768411.2.0.2\u7684patch 10\u4e2d\u88abfixed\uff0c\u5176\u4ed6\u5e73\u53f0\u53ea\u80fd\u901a\u8fc7\u5355\u72ec\u768412591252\u8865\u4e01\u6765\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002\u5f53\u7136\u5982\u679c\u80fd\u901a\u8fc7\u6539\u5199SQL\u6765\u5b9e\u73b0\u8fd9\u4e2a\u76ee\u7684\uff0c\u65e0\u7591\u4ee3\u4ef7\u662f\u6700\u5c0f\u7684\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u768411.2.0.2\u6570\u636e\u5e93\u78b0\u5230\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 \u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Fri Sep 16 15:23:52 2011 Errors in file \/u01\/diag\/rdbms\/ora1\/ora1\/trace\/ora1_ora_20382140.trc (incident=169704): ORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [kkoipt:invalid join method], [1], [0], [], [], [], [], [], [], [], [], [] Incident details in: \/u01\/diag\/rdbms\/ora1\/ora1\/incident\/incdir_169704\/ora1_ora_20382140_i169704.trc Fri Sep 16 15:24:00 2011 Dumping diagnostic &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=109\">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":[9,11,8,10],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-1L","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/109"}],"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=109"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":110,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/109\/revisions\/110"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}