在删除用户时报ORA-00600: 内部错误代码, 参数: [13011], [420], [4293646], [57], [4293653], [0], [], [], [], [], [], []
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
SQL> drop user gzyb cascade;
ORA-00600: 内部错误代码, 参数: [13011], [420], [4293646], [57], [4293653], [0], [], [], [], [], [], []
检查跟踪文件/orac/diag/rdbms/dbservice/dbservice/incident/incdir_47163/dbservice_ora_13533_i47163.trc
Dump file /orac/diag/rdbms/dbservice/dbservice/incident/incdir_47163/dbservice_ora_13533_i47163.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /orac/orahome/11.2.0/db_1
Release: 2.6.32-279.el6.x86_64
Version: #1 SMP Wed Jun 13 18:24:36 EDT 2012
Redo thread mounted by this instance: 1
Oracle process number: 26
Unix process pid: 13533, image: oracle@gzybtest
*** 2013-08-10 13:15:13.697
*** SESSION ID:(68.2534) 2013-08-10 13:15:13.697
*** CLIENT ID:() 2013-08-10 13:15:13.697
*** SERVICE NAME:(dbservice) 2013-08-10 13:15:13.697
*** MODULE NAME:(PL/SQL Developer) 2013-08-10 13:15:13.697
*** ACTION NAME:(Main session) 2013-08-10 13:15:13.697
Dump continued from file: /orac/diag/rdbms/dbservice/dbservice/trace/dbservice_ora_13533.trc
ORA-00600: 内部错误代码, 参数: [13011], [420], [4293646], [57], [4293653], [0], [], [], [], [], [], []
========= Dump for incident 47163 (ORA 600 [13011]) ========
*** 2013-08-10 13:15:13.697
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=2mp99nzd9u1qp) -----
delete from histgrm$ where obj# = :1
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+36 call kgdsdst() 000000000 ? 000000000 ?
7FFFEC2A8D08 ? 000000001 ?
7FFFEC2AD208 ? 000000000 ?
发现是在执行delete from histgrm$ where obj# = :1语句时报错
Arg [b] Data Object number
Arg [c] Tablespace Relative DBA of block containing the row to be updated
Arg [e] Relative DBA of block being updated (should be same as [c])
查询object_id=420是什么对象发现是C_OBJ#_INTCOL#
SQL> Select object_name,object_type,owner from dba_objects where data_object_id=420;
OBJECT_NAME OBJECT_TYPE OWNER
-------------------------------------------------------------------------------- ------------------- ----------- -------------------
C_OBJ#_INTCOL# CLUSTER SYS
看样子只有HISTGRM$存储在这个CLUSTER中。按理说这个对象是可以TRUNCATE的
SQL> truncate cluster c_obj#_intcol#;
truncate cluster c_obj#_intcol#
ORA-00701: 无法变更热启动数据库所需的对象
由于是BOOTSTRAP$对象,所以无法TRUNCATE.由于这个对象是420>59,因此不是核心BOOTSTRAP$对象,所以我们用得上EVENT 38003 了。
SQL> alter system set EVENT="38003 trace name context forever, level 10"
Total System Global Area 448790528 bytes
Variable Size 163579068 bytes
Database Buffers 276824064 bytes
Redo Buffers 7090176 bytes
SQL> truncate cluster c_obj#_intcol#;
SQL> drop user gzyb cascade;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26015009/viewspace-768222/,如需转载,请注明出处,否则将追究法律责任。