删除表空间报ORA-00600: internal error code, arguments: [ktssdrp1]
database :10.2.0.4.0SQL> drop tablespace TBS_DXWD including contents and datafiles;
drop tablespace TBS_DXWD including contents and datafiles
*
ERROR at line 1:
ORA-00600: internal error code, arguments: , , , , [], [], [], []
请帮助看一下问题，谢谢!
oradebug setmypid
oradebug EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12
alter session set db_file_multiblocK_read_count=1;
oradebug TRACEFILE_NAME
drop tablespace TBS_DXWD including contents and datafiles;
oradebug EVENT 10046 trace name context off
trace文件上传 TRC文件见TRC文件 报错信息
*** 2014-06-24 17:58:42.486
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: , , , , [], [], [], []
Current SQL statement for this session:
drop table "TOTAL"."BIN$2b1GLmm8ofjgQDYKyANMOA==$0" cascade constraints purge
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FBFFF3B60 ? 7FBFFF3BC0 ?
7FBFFF3B00 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FBFFF3B60 ? 7FBFFF3BC0 ?
7FBFFF3B00 ? 000000000 ?
ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?
7FBFFF3B60 ? 7FBFFF3BC0 ?
7FBFFF3B00 ? 000000000 ?
kgerinv()+161 call ksfdmp() 000000003 ? 000000001 ?
7FBFFF3B60 ? 7FBFFF3BC0 ?
7FBFFF3B00 ? 000000000 ?
kgeasnmierr()+163 call kgerinv() 0066876E0 ? 2A97421168 ?
7FBFFF3BC0 ? 7FBFFF3B00 ?
000000000 ? 000000000 ?
ktssdrp_segment()+2call kgeasnmierr() 0066876E0 ? 2A97421168 ?
138 7FBFFF3BC0 ? 7FBFFF3B00 ?
000000000 ? 00000000A ?
dtbdrp()+1736 call ktssdrp_segment() 7FBFFF5D68 ? 2A97421168 ?
7FBFFF3BC0 ? 7FBFFF3B00 ?
000000000 ? 00000000A ?
dtbdrv()+2715 call dtbdrp() 7FBFFF5D68 ? 565975E90 ?
56C2A3720 ? 7FBFFF6080 ?
000000000 ? 7FBFFF60B8 ?
opiexe()+12935 call dtbdrv() 7FBFFF5D68 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 2A976EB670 ?
opiosq0()+3316 call opiexe() 000000004 ? 000000000 ?
7FBFFF7428 ? 000000005 ?
000000000 ? 2A976EB670 ?
opiosq()+11 call opiosq0() 000000003 ? 00000000F ?
7FBFFF8900 ? 000000000 ?
000000000 ? 2A976EB670 ?
opiodr()+984 call opiosq() 000000003 ? 00000000F ?
7FBFFF8900 ? 000000000 ?
000000000 ? 2A976EB670 ?
rpidrus()+198 call opiodr() 00000004A ? 00000000F ?
7FBFFF8900 ? 000000005 ?
0059B0F90 ? 2A976EB670 ?
skgmstack()+158 call rpidrus() 7FBFFF8158 ? 00000000F ?
7FBFFF8900 ? 000000005 ?
0059B0F90 ? 2A976EB670 ?
rpidru()+116 call skgmstack() 7FBFFF8130 ? 0066872C0 ?
00000F618 ? 0022E9B98 ?
7FBFFF8158 ? 2A976EB670 ?
rpiswu2()+420 call rpidru() 7FBFFF87F0 ? 0066872C0 ?
00000F618 ? 0022E9B98 ?
7FBFFF8158 ? 2A976EB670 ?
rpidrv()+1519 call rpiswu2() 57D2D6B38 ? 000000000 ?
7FBFFF87D0 ? 000000002 ?
7FBFFF8838 ? 3F00000000 ?
rpisplu()+388 call rpidrv() 000000005 ? 00000004A ?
7FBFFF8900 ? 000000008 ?
7FBFFF8838 ? 3F00000000 ?
rpispl()+31 call rpisplu() 000000005 ? 0000005D8 ?
000000000 ? 2A974318B0 ?
000000000 ? 000000000 ?
tbsdrac()+4112 call rpispl() 000000005 ? 000000000 ?
2A974318B0 ? 000000000 ?
7FBFFF87D0 ? 2A00000000 ?
dtsdrv()+2825 call tbsdrac() 00000000A ? 000000000 ?
000000000 ? 000000001 ?
7FBFFF87D0 ? 2A00000000 ?
opiexe()+14107 call dtsdrv() 00000000A ? 000000000 ?
000000000 ? 000000001 ?
7FBFFF87D0 ? 2A00000000 ?
opiosq0()+3316 call opiexe() 000000004 ? 000000000 ?
7FBFFFAF28 ? 000000001 ?
7FBFFF87D0 ? 2A00000000 ?
kpooprx()+315 call opiosq0() 000000003 ? 00000000E ?
7FBFFFB098 ? 0000000A4 ?
7FBFFF87D0 ? 2A00000000 ?
kpoal8()+799 call kpooprx() 7FBFFFE244 ? 7FBFFFC250 ?
000000039 ? 000000001 ?
000000000 ? 2A00000000 ?
opiodr()+984 call kpoal8() 00000005E ? 000000017 ?
7FBFFFE240 ? 000000001 ?
000000001 ? 2A00000000 ?
ttcpip()+1012 call opiodr() 00000005E ? 000000017 ?
7FBFFFE240 ? 000000000 ?
0059B12B0 ? 2A00000000 ?
opitsk()+1322 call ttcpip() 00668F3B0 ? 000000001 ?
7FBFFFE240 ? 000000000 ?
7FBFFFDD38 ? 7FBFFFE3A8 ?
opiino()+1026 call opitsk() 000000003 ? 000000000 ?
7FBFFFE240 ? 000000001 ?
000000000 ? 670000600000001 ?
opiodr()+984 call opiino() 00000003C ? 000000004 ?
7FBFFFF408 ? 000000001 ?
000000000 ? 670000600000001 ?
opidrv()+547 call opiodr() 00000003C ? 000000004 ?
7FBFFFF408 ? 000000000 ?
0059B0D60 ? 670000600000001 ?
sou2o()+114 call opidrv() 00000003C ? 000000004 ?
7FBFFFF408 ? 000000000 ?
0059B0D60 ? 670000600000001 ?
opimai_real()+163 call sou2o() 7FBFFFF3E0 ? 00000003C ?
000000004 ? 7FBFFFF408 ?
0059B0D60 ? 670000600000001 ?
main()+116 call opimai_real() 000000002 ? 7FBFFFF470 ?
000000004 ? 7FBFFFF408 ?
0059B0D60 ? 670000600000001 ?
__libc_start_main()call main() 000000002 ? 7FBFFFF470 ?
+219 000000004 ? 7FBFFFF408 ?
0059B0D60 ? 670000600000001 ?
_start()+42 call __libc_start_main()000713988 ? 000000002 ?
7FBFFFF5B8 ? 005288D00 ?
000000000 ? 000000002 ?
--------------------- Binary Stack Dump ---------------------
出现该错误的原因是在drop table "TOTAL"."BIN$2b1GLmm8ofjgQDYKyANMOA==$0" cascade constraints purge表的时候发生
而删除表空间之前，会先清理该表空间对象，而这个对象是回收站中对象，因此怀疑是该对象数据字典出现问题，请做以下查询
select obj#,dataobj# from obj$ where name='BIN$2b1GLmm8ofjgQDYKyANMOA==$0';
select count(*) from seg$ where obj#=上面查询的值
select count(*) from tab$ where obj#=上面查询的值
看看是否一致？
飞总，我按照您说的查了一下：
select count(*) from tab$ where obj#=结果为1
seg$这个表没有obj#这个字段啊？？？？ 你这个是不是做过imp操作，然后导入了tab$表到数据库中了，从而出现类似问题
如果是生产库，建议逻辑导出来业务数据，然后重建库
如果是测试库，可以delete from tab$ where obj#=xxx;
然后尝试删除表空间
页:
[1]