{"id":841,"date":"2012-05-15T23:54:28","date_gmt":"2012-05-15T15:54:28","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=841"},"modified":"2012-05-17T17:38:17","modified_gmt":"2012-05-17T09:38:17","slug":"ora-600qerrmostart2%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=841","title":{"rendered":"ORA-600(qerrmOStart2)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u623711.2.0.2 RAC for Solaris 10\u51fa\u73b0ORA-600\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Fri May 11 14:22:45 2012\r\nErrors in file \/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_ora_25552.trc (incident=194913):\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [qerrmOStart2], [1740], [ORA-01740: \u6807\u8bc6\u7b26\u4e2d\u7f3a\u5931\u53cc\u5f15\u53f7\r\n], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_194913\/orcl2_ora_25552_i194913.trc\r\nFri May 11 14:23:29 2012\r\nFri May 11 14:23:29 2012\r\nDumping diagnostic data in directory=[cdmp_20120511142329], requested by (instance=2, osid=25552), summary=[incident=194913].Use ADRCI or Support Workbench t\r\no package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nException [type: SIGSEGV, Stack Overflow] [ADDR:0x8] [PC:0x10611C144, qerrmOdcl()+36] [flags: 0x0, count: 1]\r\nErrors in file \/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_ora_25552.trc (incident=194914):\r\nORA-07445: \u51fa\u73b0\u5f02\u5e38\u9519\u8bef: \u6838\u5fc3\u8f6c\u50a8 [qerrmOdcl()+36] [SIGSEGV] [ADDR:0x8] [PC:0x10611C144] [Stack Overflow] []\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [qerrmOStart2], [1740], [ORA-01740: \u6807\u8bc6\u7b26\u4e2d\u7f3a\u5931\u53cc\u5f15\u53f7\r\n], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_194914\/orcl2_ora_25552_i194914.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\nFri May 11 14:23:30 2012\r\nSweep [inc][194913]: completed\r\nSweep [inc][194914]: completed\r\nSweep [inc2][194913]: completed<\/pre>\n<p>\u867d\u7136\u8fd9\u4e2a\u64cd\u4f5c\u5728MOS\u6ca1\u6709\u76f8\u5173\u63cf\u8ff0\uff0c\u4f46\u662f\u6839\u636e\u9519\u8bef\u4fe1\u606f\u5206\u6790\uff0c\u8fd9\u4e2aORA-600\u53ea\u662f\u6807\u8bc6\u4f5c\u7528\uff0c\u771f\u6b63\u7684\u9519\u8bef\u662f\u968f\u540e\u53c2\u6570\u4e2d\u7684ORA-1740\u9519\u8bef\u3002\u800c\u8fd9\u4e2a\u9519\u8bef\u4fe1\u606f\u66f4\u50cf\u662f\u4e00\u4e2a\u8bed\u53e5\u5206\u6790\u7684\u9519\u8bef\u3002<\/p>\n<pre lang='SQL'>$ more \/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_194913\/orcl2_ora_25552_i194913.trc\r\nDump file \/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_194913\/orcl2_ora_25552_i194913.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, OLAP, Data Mining\r\nand Real Application Testing options\r\nORACLE_HOME = \/oracle\/product\/11.2.0\/dbhome_1\r\nSystem name:    SunOS\r\nNode name:      orcl2\r\nRelease:        5.10\r\nVersion:        Generic_147440-02\r\nMachine:        sun4u\r\nInstance name: orcl2\r\nRedo thread mounted by this instance: 2\r\nOracle process number: 364\r\nUnix process pid: 25552, image: oracle@orcl2\r\n\r\n\r\n*** 2012-05-11 14:22:45.579\r\n*** SESSION ID:(1590.33807) 2012-05-11 14:22:45.579\r\n*** CLIENT ID:() 2012-05-11 14:22:45.579\r\n*** SERVICE NAME:(orcl) 2012-05-11 14:22:45.579\r\n*** MODULE NAME:(PL\/SQL Developer) 2012-05-11 14:22:45.579\r\n*** ACTION NAME:(SQL Window - New) 2012-05-11 14:22:45.579\r\n \r\nDump continued from file: \/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_ora_25552.trc\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [qerrmOStart2], [1740], [ORA-01740: \u6807\u8bc6\u7b26\u4e2d\u7f3a\u5931\u53cc\u5f15\u53f7\r\n], [], [], [], [], [], [], [], [], []\r\n\r\n========= Dump for incident 194913 (ORA 600 [qerrmOStart2]) ========\r\n\r\n*** 2012-05-11 14:22:45.606\r\ndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)\r\n----- Current SQL Statement for this session (sql_id=2z1m6fp3p7qjd) -----\r\nselect o_no,\r\n       c_state,\r\n       d_state,\r\n       D_CONTENT,\r\n       O_TIME,\r\n       o_id,\r\n       O_NAME,\r\n       l_name,\r\n       l_order\r\n from\r\n(SELECT b.o_no,a.c_state,'' d_state, a.D_CONTENT,a.O_TIME,a.o_id,a.O_NAME,\r\n       l_name,l_order,\r\n       ROW_NUMBER() OVER(PARTITION BY a.O_ID ORDER BY a.O_TIME DESC) RN\r\n  FROM T_O_D@DB_A A, T_B_O@DB_A B,t_b_o_l@db_a c\r\n WHERE A.O_ID = B.O_ID\r\n   AND a.o_id = c.o_id\r\n   AND A.O_TIME >= TRUNC(SYSDATE - 1)\r\n   AND A.O_TIME < TRUNC(SYSDATE)\r\n   AND NOT EXISTS (SELECT 1\r\n          FROM T_B_O_E@DB_A O\r\n         WHERE O.O_ID = A.O\r\n           AND O.O_TIME >= TRUNC(SYSDATE - 1)\r\n           AND O.O_TIME < TRUNC(SYSDATE))\r\n    UNION ALL\r\nSELECT b.o_no,a.c_state, 'TK',a.s_remark,a.O_TIME,a.o_id,a.O_NAME,\r\n       l_name,l_order,\r\n       ROW_NUMBER() OVER(PARTITION BY a.O_ID ORDER BY a.O_TIME DESC) RN\r\n  FROM T_B_O_E@DB_A A, T_B_O@DB_A B,t_b_o_l@db_a c\r\n WHERE A.O_ID = B.O_ID\r\n   AND a.o_id = c.o_id\r\n   AND A.O_TIME >= TRUNC(SYSDATE - 1)\r\n   AND A.O_TIME < TRUNC(SYSDATE)\r\n   AND b.r_time >= TRUNC(SYSDATE - 1)\r\n   AND b.r_time < TRUNC(SYSDATE)\r\n   AND b.p_state = '2'\r\n   AND a.e_type = '14'\r\n    UNION ALL\r\nSELECT b.o_no,a.c_state,'TD', a.s_remark,a.O_TIME,a.o_id,a.O_NAME,\r\n       l_name,l_order,\r\n       ROW_NUMBER() OVER(PARTITION BY a.O_ID ORDER BY a.O_TIME DESC) RN\r\n  FROM T_B_O_E@DB_A  A, T_B_O@DB_A B,t_b_o_l@db_a c\r\n WHERE A.O_ID = B.O_ID\r\n   AND a.o_id = c.o_id\r\n   AND A.O_TIME >= TRUNC(SYSDATE - 1)\r\n   AND A.O_TIME < TRUNC(SYSDATE)\r\n   AND b.c_tag = '1'\r\n   AND a.e_type = '04'\r\nUNION ALL\r\nSELECT to_char(P_ID), STATE, DECODE(STATE, '1', 'S', '2', 'ZDTD'), NULL,\r\n       U_TIME, NULL, NULL, NULL, NULL, 1\r\n  FROM T_B_B_I@DB_A A\r\n WHERE STATE IN ('1', '2')\r\n   AND SCODE = 'EMAL'\r\n   AND U_TIME >= TRUNC(SYSDATE - 1)\r\n   AND U_TIME < TRUNC(SYSDATE))\r\n   where rn = 1\r\n\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst1()+96         CALL     skdstdst()           FFFFFFFF7FFEEED0 ?\r\n                                                   1006B0C80 ? 000000000 ?\r\n                                                   00000000A ? 000000001 ?\r\n                                                   10BD95B00 ?\r\nksedst()+60          CALL     ksedst1()            000000000 ? 000000001 ?\r\n                                                   00010C212 ? 00010C000 ?\r\n                                                   10C20A000 ? 00010C20A ?\r\ndbkedDefDump()+2032  CALL     ksedst()             000000000 ? 10B25B000 ?\r\n                                                   10B25B2B0 ? 10C212000 ?\r\n                                                   00010B000 ? 00010C212 ?\r\ndbgexPhaseII()+1800  PTR_CALL dbkedDefDump()       000000003 ? 000000002 ?\r\n                                                   10A6EC2C8 ? 0000014B0 ?\r\n                                                   10C20A000 ? 000000003 ?\r\ndbgexProcessError()  CALL     dbgexPhaseII()       10C3B4650 ?\r\n+1248                                              FFFFFFFF7BE3A578 ?\r\n                                                   FFFFFFFF7FFF3C28 ?\r\n                                                   0018E0000 ? 10A6E35B8 ?\r\n                                                   000001C00 ?\r\ndbgePostErrorKGE()+  CALL     dbgeExecuteForError  10AE0C3FD ?\r\n1320                          ()                   FFFFFFFFFEC0B62D ?\r\n                                                   001050000 ?\r\n                                                   FFFFFFFF7FFF63D8 ?\r\n                                                   001060000 ? 000000028 ?\r\ndbkePostKGE_kgsf()+  CALL     dbgePostErrorKGE()   10C20AC90 ? 000000000 ?\r\n44                                                 FFFFFFFF7BE3A578 ?\r\n                                                   000000000 ? 000000258 ?\r\n                                                   00010C000 ?\r\nkgerinv_internal()+  CALL     kgeadse()            10C20AC90 ?\r\n72                                                 FFFFFFFF7BC22F20 ?\r\n                                                   000000258 ? 000002868 ?\r\n                                                   10A6E4000 ? 00010A6E4 ?\r\nkgerinv()+40         CALL     kgerinv_internal()   10C20AC90 ? 004EA2360 ?\r\n                                                   10BC2F628 ? 000000258 ?\r\n                                                   000000000 ? 000000002 ?\r\nkgesinv()+20         CALL     kgerinv()            10C20AC90 ?\r\n                                                   FFFFFFFF7BC22F20 ?\r\n                                                   10BC2F628 ? 000000002 ?\r\n                                                   FFFFFFFF7FFF7840 ?\r\n                                                   000001400 ?\r\nksesin()+92          CALL     kgesinv()            10C20AC90 ?\r\n                                                   FFFFFFFF7BC22F20 ?\r\n                                                   10BC2F628 ? 000000002 ?\r\n                                                   FFFFFFFF7FFF7840 ?\r\n                                                   00010C212 ?\r\nOCIKSIN()+412        CALL     ksesin()             10BC2F628 ? 10C212000 ?\r\n                                                   00010C000 ? 00010C000 ?\r\n                                                   00010C20A ? 00010C212 ?\r\nqerrmOStart()+516    CALL     OCIKSIN()            FFFFFFFFFFFFFFFF ?\r\n                                                   0000006CC ? 10BC2F628 ?\r\n                                                   00010BA9D ? 10BA9D890 ?\r\n                                                   FFFFFFFF7FFF786C ?\r\nqerrmStart()+1528    CALL     qerrmOStart()        10E603CD58 ?\r\n                                                   FFFFFFFF7BC68170 ?\r\n                                                   000000000 ?\r\n                                                   FFFFFFFF7DF91088 ?\r\n                                                   000106000 ?\r\n                                                   FFFFFFFF7BC67F2C ?\r\nselexe0()+976        PTR_CALL qerrmStart()         FFFFFFFF7BC68170 ?\r\n                                                   000000003 ? 10E603CD58 ?\r\n                                                   FFFFFFFF7BC75250 ?\r\n                                                   000000001 ?\r\n                                                   FFFFFFFF7DFBE5C8 ?\r\nopiexe()+11664       CALL     selexe0()            FFFFFFFF7BC367C8 ?\r\n                                                   10C21FAE0 ?\r\n                                                   FFFFFFFF7BC41C90 ?\r\n                                                   000000000 ? 10E60B2EE0 ?\r\n                                                   10C21F000 ?\r\nkpoal8()+2368        CALL     opiexe()             000000049 ? 000000003 ?\r\n                                                   FFFFFFFF7FFF9E8C ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   0BFFFFFFF ?\r\nopiodr()+1428        PTR_CALL kpoal8()             00000005E ? 00000001C ?\r\n                                                   FFFFFFFF7FFFD348 ?\r\n                                                   00010C000 ? 10C20A000 ?\r\n                                                   000001648 ?\r\nttcpip()+1056        PTR_CALL opiodr()             00010A795 ? 00000001C ?\r\n                                                   103EAD460 ? 00010A400 ?\r\n                                                   000001400 ? 10C20A000 ?\r\nopitsk()+1528        CALL     ttcpip()             000000000 ? 10A6C7694 ?\r\n                                                   10C20AC90 ?\r\n                                                   FFFFFFFF7FFFD348 ?\r\n                                                   FFFFFFFF7FFFBD90 ?\r\n                                                   10C221848 ?\r\nopiino()+1000        CALL     opitsk()             10A6C7694 ? 10C226C98 ?\r\n                                                   10C221654 ? 10C21F958 ?\r\n                                                   000000000 ? 10C20A950 ?\r\nopiodr()+1428        PTR_CALL opiino()             00010C000 ? 10C2216D0 ?\r\n                                                   10C2216D0 ? 000380000 ?\r\n                                                   0000000EB ?\r\n                                                   FFFFFFFF7FFFECA0 ?\r\nopidrv()+1100        CALL     opiodr()             10C221000 ? 000000004 ?\r\n                                                   1035DD740 ? 00010C000 ?\r\n                                                   000001400 ? 10C20A000 ?\r\nsou2o()+92           CALL     opidrv()             00000003C ? 000000004 ?<\/pre>\n<p>\u663e\u7136\u8fd9\u662fPL\/DEVELOPER\u6267\u884c\u6216\u89e3\u6790\u8bed\u53e5\u7684\u65f6\u5019\u5f15\u53d1\u7684\u95ee\u9898\uff0c\u672c\u8d28\u4e0a\u662f\u4e00\u4e2a\u666e\u901a\u7684\u7f16\u8bd1\u9519\u8bef\uff0c\u4f46\u662fOracle\u5c06\u5176\u4f5c\u4e3a\u5185\u90e8ORA-600\u9519\u8bef\u62a5\u4e86\u51fa\u6765\u3002<br \/>\n\u5bf9\u4e8e\u8fd9\u4e2a\u9519\u8bef\u53ef\u4ee5\u7b80\u5355\u7684\u5ffd\u7565\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623711.2.0.2 RAC for Solaris 10\u51fa\u73b0ORA-600\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Fri May 11 14:22:45 2012 Errors in file \/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_ora_25552.trc (incident=194913): ORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [qerrmOStart2], [1740], [ORA-01740: \u6807\u8bc6\u7b26\u4e2d\u7f3a\u5931\u53cc\u5f15\u53f7 ], [], [], [], [], [], [], [], [], [] Incident details in: \/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_194913\/orcl2_ora_25552_i194913.trc Fri May 11 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=841\">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":[709,707,710,8,118,711,708],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-dz","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/841"}],"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=841"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/841\/revisions"}],"predecessor-version":[{"id":842,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/841\/revisions\/842"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}