\u5728\u4e00\u4e2a\u5ba2\u6237\u7684\u6570\u636e\u5e93\u544a\u8b66\u65e5\u5fd7\u4e2d\uff0c\u9891\u7e41\u51fa\u73b0ORA-600(kdsgrp1)\u9519\u8bef\u3002
\n\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n
\/oracle\/admin\/tjsb\/udump\/tjsb1_ora_1701138.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options\r\nORACLE_HOME = \/oracle\/product\/10.2.0\/db_1\r\nSystem name: AIX\r\nNode name: p570c\r\nRelease: 3\r\nVersion: 5\r\nMachine: 00C971744C00\r\nInstance name: tjsb1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 883\r\nUnix process pid: 1701138, image: oracle@p570c\r\n*** 2011-07-26 09:59:41.111\r\n*** ACTION NAME:(abc) 2011-07-26 09:59:41.105\r\n*** MODULE NAME:(archive.exe) 2011-07-26 09:59:41.105\r\n*** SERVICE NAME:(tjsb) 2011-07-26 09:59:41.105\r\n*** SESSION ID:(2466.64103) 2011-07-26 09:59:41.105\r\n row 0766ce34.a continuation at\r\n file# 29 block# 2543156 slot 11 not found\r\n**************************************************\r\nKDSTABN_GET: 0 ..... ntab: 1\r\ncurSlot: 11 ..... nrows: 110\r\n**************************************************\r\n*** 2011-07-26 09:59:41.111\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\nSELECT DISTINCT KC01.AAC001 AAC001 FROM AC04, AC02, KC01 WHERE KC01.AAB001 = :B2 AND KC01.AKC021 IN ('11', '12') AND AC02.AAE140 = '\r\n3' AND AC02.AAC031 = '1' AND AC02.AAC001 = KC01.AAC001 AND AC04.AAC001 = KC01.AAC001 AND AC04.AAE030 <= TO_DATE(:B1 , 'yyyymm') AND \r\n(AC04.AAE031 >= TO_DATE(:B1 , 'yyyymm') OR AC04.AAE031 IS NULL) AND NVL(AC04.AKC010, 0) > 0 AND NOT EXISTS (SELECT 1 FROM AC01 WHERE\r\n AAB001 = :B2 AND NVL(AAC033, '0') = '3' AND AAC001 = KC01.AAC001) AND NOT EXISTS (SELECT 1 FROM DUAL WHERE :B3 <= (SELECT NVL(SUM(C\r\nKC010), 0) FROM KC33 WHERE AAC001 = KC01.AAC001 AND AAE001 = TO_NUMBER(SUBSTR(:B1 , 1, 4)))) UNION SELECT DISTINCT KC01.AAC001 AAC00\r\n1 FROM AC02, KC01 WHERE KC01.AAB001 = :B2 AND KC01.AKC021 IN ('21', '22', '23') AND AC02.AAE140 = '3' AND AC02.AAC031 = '1' AND AC02\r\n.AAC001 = KC01.AAC001 AND NOT EXISTS (SELECT 1 FROM AC01 WHERE AAB001 = :B2 AND NVL(AAC033, '0') > '0' AND AAC001 = KC01.AAC001) AND\r\n NOT EXISTS (SELECT 1 FROM KC33 WHERE AAC001 = KC01.AAC001 AND AAE002 = :B1 ) AND (NOT EXISTS (SELECT 1 FROM DUAL WHERE :B4 <= (SELE\r\nCT NVL(SUM(CKC010), 0) FROM KC33 WHERE AAC001 = KC01.AAC001 AND AAE001 = TO_NUMBER(SUBSTR(:B1 , 1, 4))) AND NVL(TO_CHAR(KC01.AIC162,\r\n 'yyyymm'),'199001') < SUBSTR(:B1 , 1, 4) || '01')) AND (NOT EXISTS (SELECT 1 FROM DUAL WHERE :B3 <= (SELECT NVL(SUM(CKC010), 0) FRO\r\nM KC33 WHERE AAC001 = KC01.AAC001 AND AAE001 = TO_NUMBER(SUBSTR(:B1 , 1, 4))) AND NVL(TO_CHAR(KC01.AIC162, 'yyyymm'),'199001') >= SU\r\nBSTR(:B1 , 1, 4) || '01'))\r\n----- PL\/SQL Call Stack -----\r\n object line object\r\n handle number name\r\n70000078a8a6960 8456 package body TJSI.PKG_A_JJZJ\r\n70000078bd54dc0 1 anonymous block\r\n----- Call Stack Trace -----\r\ncalling call entry argument values in hex \r\nlocation type point (? means dubious value) \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst+001c bl ksedst1 000000000 ? 000000000 ?\r\nksedmp+0290 bl ksedst 104522370 ?\r\nksfdmp+0018 bl 03F2C1FC \r\nkgerinv+00dc bl _ptrgl \r\nkgeasnmierr+004c bl kgerinv 000000000 ? 000000001 ?\r\n 10D00000000 ? 000000000 ?\r\n 110648E58 ?\r\nkdsgrp+0460 bl 01F92FB8 \r\nkdsfbr+0268 bl kdsgrp 000000001 ? 1105E2988 ?\r\n 000000000 ?\r\nqertbFetchByRowID+0 bl kdsfbr FFFFFFFFFFF1FA0 ? 000000000 ?\r\n9d0 1040DC78C ? 000000000 ?\r\n 1105FC720 ? 1101FB888 ?\r\n 1105FCF40 ? 000000000 ?\r\nrwsfcd+0054 bl _ptrgl \r\nqerflFetchOutside+0 bl 03F2BB90 \r\n09c \r\nrwsfcd+0054 bl _ptrgl \r\nqeruaFetch+013c bl 03F2BB90 \r\nqersoFetch+0110 bl 01F92FBC \r\nopifch2+141c bl 01F92FBC \r\nopifch+003c bl opifch2 000000001 ? 11062BDC0 ?\r\n FFFFFFFFFFF36D0 ?\r\nopipls+21a4 bl opifch FFFFFFFFFFF3858 ? 110173648 ?\r\n FFFFFFFFFFF3870 ?\r\nopiodr+0ae0 bl _ptrgl \r\nrpidrus+01bc bl opiodr 6686B0E7F0 ? 684B93430 ?\r\n FFFFFFFFFFF67E0 ? D86B0E750 ?\r\nskgmstack+00c8 bl _ptrgl \r\nrpidru+0088 bl skgmstack 110173648 ? FFFFFFFFFFF5830 ?\r\n 000000002 ? 000000000 ?\r\n FFFFFFFFFFF5FA8 ?\r\nrpiswu2+034c bl _ptrgl \r\nrpidrv+095c bl rpiswu2 7000007837E2BD8 ?\r\n 3A00000000 ? 10451BB80 ?\r\n 000000000 ? 110196C78 ?\r\n 3A10196C60 ?\r\n FFFFFFFFFFF6008 ? 000000000 ?\r\npsddr0+02bc bl 01F96D24 \r\npsdnal+01d0 bl psddr0 D013BC57C ? 6610573D78 ?\r\n FFFFFFFFFFF67E0 ?\r\n 3000000000 ?\r\npevm_BFTCHC+03b4 bl _ptrgl \r\npfrinstr_FTCHC+0138 bl pevm_BFTCHC 101479974 ? 000000000 ?\r\n 000000010 ?\r\npfrrun_no_tool+005c bl _ptrgl \r\npfrrun+1014 bl pfrrun_no_tool FFFFFFFFFFF6B20 ?\r\n 70000078BD54DC0 ? 3000009BB ?\r\nplsql_run+06b4 bl pfrrun 110469588 ?\r\npeicnt+0224 bl plsql_run 110469588 ? 10001102381F8 ?\r\n 000000000 ?\r\nkkxexe+0250 bl peicnt FFFFFFFFFFF7E38 ? 110469588 ?\r\nopiexe+2ef8 bl kkxexe 11064CEA0 ?\r\nkpoal8+0edc bl opiexe FFFFFFFFFFFB454 ?\r\n FFFFFFFFFFFB180 ?\r\n FFFFFFFFFFF9628 ?\r\nopiodr+0ae0 bl _ptrgl \r\nttcpip+1020 bl _ptrgl \r\nopitsk+1124 bl 01F95258 \r\nopiino+0990 bl opitsk 0FFFFD490 ? 000000000 ?\r\nopiodr+0ae0 bl _ptrgl \r\nopidrv+0484 bl 01F947C0 \r\nsou2o+0090 bl opidrv 3C02D9855C ? 44065F000 ?\r\n FFFFFFFFFFFF390 ?\r\nopimai_real+01bc bl 01F92214 \r\nmain+0098 bl opimai_real 000000000 ? 000000000 ?\r\n__start+0098 bl main 000000000 ? 000000000 ?<\/pre>\n\u67e5\u8be2\u4e86\u4e00\u4e0bmetalink\uff0c\u53d1\u73b0\u9519\u8bef\u53f7\u4e3akdsgrp1\u7684\u5df2\u77e5600\u9519\u8bef\u670920\u591a\u4e2a\u4e4b\u591a\u3002\u5f53\u524d\u7684\u7248\u672c\u662f10204\uff0c\u800c\u8fd9\u4e9b\u5df2\u77e5bug\u53c8\u670980%\u90fd\u53ef\u80fd\u5728\u8fd9\u4e2a\u7248\u672c\u4e0a\u53d1\u751f\u3002\u4e0d\u8fc7\u4ed4\u7ec6\u770b\u4e00\u4e0b\u9519\u8bef\u7684\u8bf4\u660e\uff0c\u8fd9\u4e9b\u9519\u8bef\u6709\u51e0\u5206\u76f8\u4f3c\u4e4b\u5904\uff0c\u591a\u534a\u90fd\u548c\u8868\u6216\u7d22\u5f15\u7684\u903b\u8f91\u635f\u574f\u6709\u5173\u3002
\n\u5728\u8fd9\u4e2atrace\u6587\u4ef6\u4e2d\uff0c\u6709\u660e\u786e\u7684\u6807\u8bc6\u635f\u574f\u4e4b\u5904\uff1a<\/p>\n
row 0766ce34.a continuation at\r\n file# 29 block# 2543156 slot 11 not found<\/pre>\n\u663e\u7136\u8fd9\u91cc\u51fa\u73b0\u4e86\u4e00\u4e2a\u903b\u8f91\u574f\u5757\uff0c\u90a3\u4e48\u5176\u5b9e\u4e0d\u7528\u518d\u53bb\u5173\u5fc3\u5f53\u524d\u7684\u95ee\u9898\u5c5e\u4e8e\u54ea\u4e2a\u5df2\u77e5\u7684bug\uff0c\u53ea\u8981\u89e3\u51b3\u4e86\u8fd9\u4e2a\u574f\u5757\uff0c\u5c31\u89e3\u51b3\u4e86\u8fd9\u4e2aORA-600\u7684\u9519\u8bef\u3002
\n\u6709\u4e86FILE\u548cBLOCK\u7684\u5e8f\u53f7\uff0c\u53ef\u4ee5\u901a\u8fc7DUMP\u7684\u624b\u6bb5\uff0c\u4e5f\u53ef\u4ee5\u67e5\u8be2DBA_EXTENTS\u89c6\u56fe\uff0c\u6765\u786e\u8ba4\u574f\u5757\u7684\u5185\u5bb9\u3002
\n\u5982\u679c\u574f\u5757\u5c5e\u4e8e\u7d22\u5f15\uff0c\u90a3\u4e48\u53ef\u4ee5\u901a\u8fc7\u5220\u9664\u7d22\u5f15\u7136\u540e\u91cd\u5efa\u7684\u65b9\u5f0f\uff0c\u5f88\u5bb9\u6613\u7684\u89e3\u51b3\u95ee\u9898\u3002
\n\u5982\u679c\u574f\u5757\u5c5e\u4e8e\u8868\uff0c\u90a3\u4e48\u574f\u5757\u4e2d\u7684\u90e8\u5206\u884c\u4fe1\u606f\u53ef\u80fd\u4e22\u5931\u3002\u5982\u679c\u627e\u4e0d\u5230\u51fa\u73b0\u9519\u8bef\u4e4b\u524d\u7684\u5907\u4efd\uff0c\u53ef\u4ee5\u901a\u8fc7DBMS_REPAIR\u5305\u8fdb\u884c\u4fee\u590d\uff0c\u6216\u8005\u8bbe\u7f6ealter session set events ‘10231 trace name context forever, level 10’\uff0c\u7136\u540e\u5bfc\u51fa\u6216CREATE TABLE AS SELECT\u5c06\u574f\u5757\u610f\u5916\u7684\u6570\u636e\u8fdb\u884c\u91cd\u5efa\u3002
\n\u53ef\u4ee5\u53c2\u8003metalink\u6587\u6863ID 468883.1\uff0c\u83b7\u53d6\u66f4\u8be6\u7ec6\u7684\u4fe1\u606f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728\u4e00\u4e2a\u5ba2\u6237\u7684\u6570\u636e\u5e93\u544a\u8b66\u65e5\u5fd7\u4e2d\uff0c\u9891\u7e41\u51fa\u73b0ORA-600(kdsgrp1)\u9519\u8bef\u3002 \u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a \/oracle\/admin\/tjsb\/udump\/tjsb1_ora_1701138.trc Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options ORACLE_HOME = \/oracle\/product\/10.2.0\/db_1 System name: AIX Node name: p570c Release: 3 Version: 5 Machine: … Continue reading