當前位置:成語大全網 - 新華字典 - ora-00600 error

ora-00600 error

這個壹般是 數據字典有點小問題了。

In Oracle Database 11g, the DMSYS schema is no longer used. The Data Mining option is installed in the SYS schema. The 11.2 pre-upgrade tool has been extended to include a warning that the DMSYS schema should be dropped. If this warning is reported, it is recommended to drop the schema as per the Oracle Data Mining Administrator's Guide 11g Release 2 (11.2).

While dropping the DMSYS user, you receive the following errors:

ORA-00600: internal error code, arguments: [dmmeclodm.2], [1403], [], [], [], [], [], [], [], [], [], []

ORA-06512: at "SYS.DMP_SYS", line 132

ORA-06512: at "SYS.DMP_SYS", line 1217

ORA-06512: at line 1

ORA-00600: internal error code, arguments: [kzdGenDropStmt], [82], [0], [], [], [], [], [], [], [], [], []

dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)

----- Current SQL Statement for this session (sql_id=d5rrp44zk179y) -----

DROP USER dmsys CASCADE

CAUSE

There are objects in SYS.OBJ$ that need to be dropped first.

SOLUTION

Run these queries:

spool output.txt

select user# FROM SYS.USER$ U WHERE U.NAME = 'DMSYS';

(note user# and use it in the queries below):

select obj#,name FROM SYS.OBJ$ WHERE type#=82 AND owner# = <user# from above>;

select distinct u.name from obj$ o, user$ u where o.owner#=u.user# and o.owner#=<user# from above>;

delete from obj$ WHERE type#=82 AND owner# = <user# from above>;

Then drop DMSYS

As SYS:

DROP USER DMSYS CASCADE;

如果自己搞不定可以找詩檀軟件專業ORACLE數據庫修復團隊成員幫您恢復!

詩檀軟件專業數據庫修復團隊