{"id":654,"date":"2012-03-12T23:29:31","date_gmt":"2012-03-12T15:29:31","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=654"},"modified":"2012-03-14T18:32:59","modified_gmt":"2012-03-14T10:32:59","slug":"%e5%88%a0%e9%99%a4%e8%a1%a8%e7%a9%ba%e9%97%b4%e6%8a%a5%e9%94%99ora-600ktssdrp1%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=654","title":{"rendered":"\u5220\u9664\u8868\u7a7a\u95f4\u62a5\u9519ORA-600(ktssdrp1)\u9519\u8bef"},"content":{"rendered":"<p>\u6d4b\u8bd5\u73af\u5883\u7684\u65b0\u5efa\u8868\u7a7a\u95f4\u5728\u5220\u9664\u65f6\u62a5\u9519\u3002<br \/>\n\u6570\u636e\u5e93\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u8868\u7a7a\u95f4\u540e\u6267\u884c\u5220\u9664\uff0c\u51fa\u73b0\u4e86ORA-600\u7684\u9519\u8bef\u4fe1\u606f\uff1a<\/p>\n<pre lang='SQL'>SQL> select tablespace_name from dba_tablespaces;\r\nTABLESPACE_NAME\r\n------------------------------\r\nSYSTEM\r\nUNDOTBS\r\nSYSAUX\r\nTEMP\r\nTBS_1\r\nGGX\r\nUSERS\r\nPERFSTAT\r\nSTATSPACK\r\nALA_TEST\r\n10 rows selected.\r\nSQL> drop tablespace ala_test including contents and datafiles;\r\ndrop tablespace ala_test including contents and datafiles\r\n*\r\nERROR at line 1:\r\nORA-00600: internal error code, arguments: [ktssdrp1], [9], [13], [11], [], [], [], []\r\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a\r\nTue Mar 13 18:11:14 CST 2012\r\ndrop tablespace ala_test including contents and datafiles\r\nTue Mar 13 18:11:14 CST 2012\r\nErrors in file \/u01\/app\/oracle\/admin\/orcl10g\/udump\/orcl10g_ora_7838.trc:\r\nORA-00600: internal error code, arguments: [ktssdrp1], [9], [13], [11], [], [], [], []\r\nTue Mar 13 18:11:18 CST 2012\r\nORA-600 signalled during: drop tablespace ala_test including contents and datafiles...<\/pre>\n<p>\u8be6\u7ec6\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Dump file \/u01\/app\/oracle\/admin\/orcl10g\/udump\/orcl10g_ora_7838.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/10.2.0\/db_1\r\nSystem name:    Linux\r\nNode name:      hpserver2.enmotech.com\r\nRelease:        2.6.32-100.28.5.el6.x86_64\r\nVersion:        #1 SMP Wed Feb 2 18:40:23 EST 2011\r\nMachine:        x86_64\r\nInstance name: orcl10g\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 13\r\nUnix process pid: 7838, image: oracle@hpserver2.enmotech.com (TNS V1-V3)\r\n*** ACTION NAME:() 2012-03-13 18:11:14.802\r\n*** MODULE NAME:(sqlplus@hpserver2.enmotech.com (TNS V1-V3)) 2012-03-13 18:11:14.802\r\n*** SERVICE NAME:(SYS$USERS) 2012-03-13 18:11:14.802\r\n*** SESSION ID:(30.124) 2012-03-13 18:11:14.802\r\n*** 2012-03-13 18:11:14.802\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [ktssdrp1], [9], [13], [11], [], [], [], []\r\nCurrent SQL statement for this session:\r\ndrop table \"APP\".\"SERVICE\" cascade constraints purge\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex\r\nlocation             type     point                (? means dubious value)\r\n-------------------- -------- -------------------- ----------------------------\r\nssd_unwind_bp: unhandled instruction at 0x3d12d3e instr=f\r\nssd_unwind_bp: unhandled instruction at 0x1344b61 instr=f\r\nksedst()+31          call     ksedst1()            000000000 ? 000000001 ?\r\n                                                   7FFFA35C05C0 ? 7FFFA35C0620 ?\r\n                                                   7FFFA35C0560 ? 000000000 ?\r\nksedmp()+610         call     ksedst()             000000000 ? 000000001 ?\r\n                                                   7FFFA35C05C0 ? 7FFFA35C0620 ?\r\n                                                   7FFFA35C0560 ? 000000000 ?\r\nksfdmp()+63          call     ksedmp()             000000003 ? 000000001 ?\r\n                                                   7FFFA35C05C0 ? 7FFFA35C0620 ?\r\n                                                   7FFFA35C0560 ? 000000000 ?\r\nkgerinv()+161        call     ksfdmp()             006AE9A40 ? 000000003 ?\r\n                                                   7FFFA35C05C0 ? 7FFFA35C0620 ?\r\n                                                   7FFFA35C0560 ? 000000000 ?\r\nkgeasnmierr()+163    call     kgerinv()            006AE9A40 ? 008754D28 ?\r\n                                                   7FFFA35C0620 ? 7FFFA35C0560 ?\r\n                                                   000000000 ? 000000000 ?\r\nktssdrp_segment()+2  call     kgeasnmierr()        006AE9A40 ? 008754D28 ?\r\n289                                                7FFFA35C0620 ? 7FFFA35C0560 ?\r\n                                                   000000000 ? 000000009 ?\r\ndtbdrp()+1736        call     ktssdrp_segment()    7FFFA35C2998 ? 008754D28 ?\r\n                                                   7FFFA35C0620 ? 7FFFA35C0560 ?\r\n                                                   000000000 ? 000000009 ?\r\ndtbdrv()+2732        call     dtbdrp()             7FFFA35C2998 ? 0779C1148 ?\r\n                                                   074FB4318 ? 7FFFA35C2CB0 ?\r\n                                                   000000000 ? 7FFFA35C2CE8 ?\r\nopiexe()+13175       call     dtbdrv()             7FFFA35C2998 ? 0779C1148 ?\r\n                                                   000000000 ? 7FFFA35C2CB0 ?\r\n                                                   000000000 ? 7FFFA35C2CE8 ?\r\nopiosq0()+3398       call     opiexe()             000000004 ? 000000000 ?\r\n                                                   7FFFA35C3F2C ? 000000005 ?\r\n                                                   000000000 ? 7FFFA35C2CE8 ?\r\nopiosq()+14          call     opiosq0()            000000003 ? 00000000F ?\r\n                                                   7FFFA35C5600 ? 000000000 ?\r\n                                                   000000000 ? 000000041 ?\r\nopiodr()+1184        call     opiosq()             000000003 ? 00000000F ?\r\n                                                   7FFFA35C5600 ? 000000000 ?\r\n                                                   000000000 ? 000000041 ?\r\nssd_unwind_bp: unhandled instruction at 0x24168a7 instr=f\r\nrpidrus()+196        call     opiodr()             00000004A ? 00000000F ?\r\n                                                   7FFFA35C5600 ? 000000005 ?\r\n                                                   005BEBA90 ? 000000041 ?\r\nskgmstack()+158      call     rpidrus()            7FFFA35C4E58 ? 00000000F ?\r\n                                                   7FFFA35C5600 ? 000000005 ?\r\n                                                   005BEBA90 ? 000000041 ?\r\nrpidru()+116         call     skgmstack()          7FFFA35C4E30 ? 006AE9620 ?\r\n                                                   00000F618 ? 002419628 ?\r\n                                                   7FFFA35C4E58 ? 000000041 ?\r\nrpiswu2()+409        call     rpidru()             7FFFA35C54F8 ? 006AE9620 ?\r\n                                                   00000F618 ? 002419628 ?\r\n                                                   7FFFA35C4E58 ? 000000041 ?\r\nrpidrv()+1516        call     rpiswu2()            07F1AEA58 ? 000000000 ?\r\n                                                   7FFFA35C54D8 ? 000000002 ?\r\n                                                   7FFFA35C5540 ? 000000000 ?\r\nrpispl()+406         call     rpidrv()             000000005 ? 00000004A ?\r\n                                                   7FFFA35C5600 ? 000000008 ?\r\n                                                   7FFFA35C5540 ? 000000000 ?\r\ntbsdrac()+4341       call     rpispl()             000000005 ? 000000000 ?\r\n                                                   0087315C0 ? 000000041 ?\r\n                                                   000000000 ? 000000000 ?\r\ndtsdrv()+2882        call     tbsdrac()            000000009 ? 000000000 ?\r\n                                                   000000000 ? 000000001 ?\r\n                                                   000000000 ? 000000000 ?\r\nopiexe()+14347       call     dtsdrv()             000000009 ? 000000000 ?\r\n                                                   000000000 ? 000000001 ?\r\n                                                   000000000 ? 000000000 ?\r\nopiosq0()+3398       call     opiexe()             000000004 ? 000000000 ?\r\n                                                   7FFFA35C7B3C ? 000000002 ?\r\n                                                   000000000 ? 000000000 ?\r\nkpooprx()+318        call     opiosq0()            000000003 ? 00000000E ?\r\n                                                   7FFFA35C7E68 ? 0000000A4 ?\r\n                                                   000000000 ? 600000039 ?\r\nkpoal8()+783         call     kpooprx()            7FFFA35CB04C ? 7FFFA35C9078 ?\r\n                                                   000000039 ? 000000001 ?\r\n                                                   000000000 ? 600000039 ?\r\nopiodr()+1184        call     kpoal8()             00000005E ? 000000017 ?\r\n                                                   7FFFA35CB048 ? 000000001 ?\r\n                                                   000000001 ? 600000039 ?\r\nttcpip()+1226        call     opiodr()             00000005E ? 000000017 ?\r\n                                                   7FFFA35CB048 ? 000000000 ?\r\n                                                   005BEBDB0 ? 600000039 ?\r\nopitsk()+1310        call     ttcpip()             006AF1FD0 ? 0054A67A0 ?\r\n                                                   7FFFA35CB048 ? 000000000 ?\r\n                                                   7FFFA35CAB48 ? 7FFFA35CB1B0 ?\r\nopiino()+1024        call     opitsk()             000000003 ? 000000000 ?\r\n                                                   7FFFA35CB048 ? 000000001 ?\r\n                                                   000000000 ? 6AF000900000001 ?\r\nopiodr()+1184        call     opiino()             00000003C ? 000000004 ?\r\n                                                   7FFFA35CC248 ? 000000001 ?\r\n                                                   000000000 ? 6AF000900000001 ?\r\nopidrv()+548         call     opiodr()             00000003C ? 000000004 ?\r\n                                                   7FFFA35CC248 ? 000000000 ?\r\n                                                   005BEB860 ? 6AF000900000001 ?\r\nsou2o()+114          call     opidrv()             00000003C ? 000000004 ?\r\n                                                   7FFFA35CC248 ? 000000000 ?\r\n                                                   005BEB860 ? 6AF000900000001 ?\r\nopimai_real()+163    call     sou2o()              7FFFA35CC220 ? 00000003C ?\r\n                                                   000000004 ? 7FFFA35CC248 ?\r\n                                                   005BEB860 ? 6AF000900000001 ?\r\nmain()+116           call     opimai_real()        000000002 ? 7FFFA35CC2B0 ?\r\n                                                   000000004 ? 7FFFA35CC248 ?\r\n                                                   005BEB860 ? 6AF000900000001 ?\r\n__libc_start_main()  call     main()               000000002 ? 7FFFA35CC2B0 ?\r\n+253                                               000000004 ? 7FFFA35CC248 ?\r\n                                                   005BEB860 ? 6AF000900000001 ?\r\n_start()+41          call     __libc_start_main()  00072D134 ? 000000002 ?\r\n                                                   7FFFA35CC408 ? 000000000 ?\r\n                                                   005BEB860 ? 6AF000900000001 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u62a5\u9519\u53d1\u751f\u5728\u5220\u9664\u4e00\u4e2a\u8868\u4e0a\u3002\u800c\u8fd9\u4e2a\u8868\u5728\u6570\u636e\u5e93\u4e2d\u5e94\u8be5\u662f\u4e0d\u5b58\u5728\u7684\uff0c\u6216\u8005\u8bf4\u5373\u4f7f\u8fd9\u4e2a\u8868\u5b58\u5728\uff0c\u4e5f\u4e0d\u53ef\u80fd\u5efa\u7acb\u5728\u8fd9\u4e2a\u8868\u7a7a\u95f4\u3002\u90a3\u4e48\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u5e94\u8be5\u53ea\u6709\u4e00\u4e2a\uff0c\u6570\u636e\u5b57\u5178\u51fa\u73b0\u4e86\u4e0d\u4e00\u81f4\u7684\u72b6\u6001\u3002<\/p>\n<pre lang='SQL'>SQL> select ts#, count(*) from seg$ group by ts#;\r\n       TS#   COUNT(*)\r\n---------- ----------\r\n         1         11\r\n         6         20\r\n         2       1126\r\n         4         57\r\n         5          5\r\n         0       1429\r\n6 rows selected.\r\nSQL> select ts#, count(*) from tab$ group by ts#;\r\n       TS#   COUNT(*)\r\n---------- ----------\r\n         6        429\r\n        11         97\r\n         2        247\r\n         5          5\r\n         4         48\r\n         8         30\r\n         7          2\r\n         0        736\r\n         9         10\r\n        12          2\r\n10 rows selected.<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u5728SEG$\u4e2d\u4e0d\u5b58\u5728\u8868\u7a7a\u95f4\u7f16\u53f7\u5927\u4e8e6\u7684\u5bf9\u8c61\uff0c\u4f46\u662f\u5728TAB$\u4e2d\u786e\u5b58\u5728\u5f88\u591a\u3002<\/p>\n<pre lang='SQL'>SQL> select ts#, name from ts$ where name = 'ALA_TEST';\r\n       TS# NAME\r\n---------- ------------------------------\r\n         9 ALA_TEST\r\nSQL> select ts#, name from ts$;\r\n       TS# NAME\r\n---------- ------------------------------\r\n         0 SYSTEM\r\n         1 UNDOTBS\r\n         2 SYSAUX\r\n         3 TEMP\r\n         4 TBS_1\r\n         5 GGX\r\n         6 USERS\r\n         7 PERFSTAT\r\n         8 STATSPACK\r\n         9 ALA_TEST\r\n10 rows selected.<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u8868\u7a7a\u95f4\u76ee\u524d\u7f16\u53f7\u53ea\u52309\uff0c\u800cTAB$\u4e2d\u8bb0\u5f55\u7684\u8868\u7a7a\u95f4\u7684\u7f16\u53f7\u4ee5\u53ca\u5230\u4e8612\u3002\u663e\u7136\u8fd9\u5c31\u662f\u5bfc\u81f4ORA-600\u9519\u8bef\u7684\u539f\u56e0\u3002Oracle\u5728\u5220\u9664\u8868\u7a7a\u95f4\u7684\u65f6\u5019\u53d1\u73b0\u6709\u8868\u5b58\u5728\uff0c\u4f46\u662f\u6839\u636e\u6bb5\u4fe1\u606f\u53c8\u627e\u4e0d\u5230\u5bf9\u5e94\u7684\u8bb0\u5f55\uff0c\u5bfc\u81f4\u5220\u9664\u65e0\u6cd5\u5b8c\u6210\uff0c\u4ece\u800c\u5f15\u53d1\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u81f3\u4e8e\u6570\u636e\u5b57\u5178\u4e0d\u4e00\u81f4\u7684\u4ea7\u751f\u5e94\u8be5\u662f\u6d4b\u8bd5\u73af\u5883\u901a\u8fc7imp\u5bfc\u5165tab$\u5f15\u8d77\u7684\uff0c\u5bf9\u4e8e\u6d4b\u8bd5\u73af\u5883\u800c\u8a00\uff0c\u8fd9\u4e2a\u9519\u8bef\u5f88\u5bb9\u6613\u6e05\u9664\u6389\uff0c\u76f4\u63a5\u5220\u9664\u4e0d\u4e00\u81f4\u7684\u8bb0\u5f55\u5373\u53ef\uff0c\u4f46\u662f\u5bf9\u4e8e\u4ea7\u54c1\u73af\u5883\u800c\u8a00\uff0c\u4e0d\u63a8\u8350\u8fd9\u79cd\u65b9\u5f0f\uff1a<\/p>\n<pre lang='SQL'>SQL> select ts#, count(*) from ind$ group by ts#;\r\n       TS#   COUNT(*)\r\n---------- ----------\r\n         6        239\r\n        11         61\r\n        13        103\r\n         2        332\r\n         4          9\r\n         8         31\r\n         0        858\r\n7 rows selected.\r\nSQL> delete tab$ where ts# = 9;\r\n10 rows deleted.\r\nSQL> commit;\r\nCommit complete.\r\nSQL> drop tablespace ala_test including contents and datafiles;\r\nTablespace dropped.<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6d4b\u8bd5\u73af\u5883\u7684\u65b0\u5efa\u8868\u7a7a\u95f4\u5728\u5220\u9664\u65f6\u62a5\u9519\u3002 \u6570\u636e\u5e93\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u8868\u7a7a\u95f4\u540e\u6267\u884c\u5220\u9664\uff0c\u51fa\u73b0\u4e86ORA-600\u7684\u9519\u8bef\u4fe1\u606f\uff1a SQL> select tablespace_name from dba_tablespaces; TABLESPACE_NAME &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; SYSTEM UNDOTBS SYSAUX TEMP TBS_1 GGX USERS PERFSTAT STATSPACK ALA_TEST 10 rows selected. SQL> drop tablespace ala_test including contents and datafiles; drop tablespace ala_test including contents and datafiles * ERROR at &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=654\">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":[536,537,8,538,539],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-ay","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/654"}],"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=654"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/654\/revisions"}],"predecessor-version":[{"id":655,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/654\/revisions\/655"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}