ORA-600[13013] Error While Creating a User. [ID 297595.1]

rongshiyuan發表於2013-01-23
ORA-600[13013] Error While Creating a User. [ID 297595.1]

In this Document
Symptoms
Cause
Solution
References


Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.5.0 to 9.2.0.1 - Release: 8.1.5 to 9.2
Information in this document applies to any platform.

Symptoms

Error ORA-600 [13013] [5001], [10], [4194358],[0], [4200168], [17] running CREATE USER command.

ORA-600 [13013] Argument format
=========================

This format relates to Oracle Server 8.0.3 to 11.2

Arg [a] Passcount
Arg [b] Data Object number
Arg [c] Tablespace Relative DBA of block containing the row to be updated
Arg [d] Row Slot number
Arg [e] Relative DBA of block being updated (should be same as [c])
Arg [f] Code

The corrupt object with the obj_id = 10 is the SYS.C_USER$ cluster
Analyze this cluster with the option Validate Structure failed with message ORA-01499 :
table/index cross reference

The corrupt object is the index I_USER1 . Drop or rebuild this index failed with message
ORA-00701: object necessary for warmstarting database cannot be altered.

Delete Role SNMPAGENT via OEM gets ORA-1919.
DROP Role SNMPAGENT via SQLPLUS gets ORA-8102.


You can also receive ORA-00600 [12700] error with the ORA-00600[13013].

Cause

The corrupted index SYS.I_USER1 which belongs to table SYS.USER$.

Not related to bug or known problems.

Solution

The I_INDEX1 index is created on the USER$ table which is part of the C_USER# cluster. This
cluster is created in sql.bsq and is part of the bootstrap phase and can not be dropped and
recreated. The only option here is to rebuild the database via export import.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-753111/,如需轉載,請註明出處,否則將追究法律責任。

相關文章