oracle drop user失败,升级失败后，在drop user时出现错误ORA-00600 kkpo_rcinfo_defstg:objnotfound...

关于升级失败后，在drop user时出现错误ORA-00600的解决方案：

当前DB版本：

SQL> select * from v$version where rownum<5;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

PL/SQL Release 11.2.0.1.0 - Production

CORE    11.2.0.1.0      Production

TNS for Linux: Version 11.2.0.1.0 - Production

SQL> sho user

USER is "FUTURELEVEL1"

SQL> conn /as sysdba

Connected.

SQL> drop user futurelevel1 ;

drop user futurelevel1

*

ERROR at line 1:

ORA-00600: 内部错误代码, 参数: [kkpo_rcinfo_defstg:objnotfound], [62768], [],

[], [], [], [], [], [], [], [], []

ORA-06512: 在 line 12

--alert.log文件内容如下：

client_id='' type='UNKNOWN' level='16'

host_id='m1hfdata' host_addr='::1' module=''

pid='16753'>

Errors in file /m1hf/diag/rdbms/m1hf/m1hf/trace/m1hf_j000_16753.trc:

ORA-00600: internal error code, arguments: [kkpo_rcinfo_defstg:objnotfound], [70351], [], [], [], [], [], [], [], [], [], []

ORA-06512: at "APEX_030200.WWV_FLOW_CACHE", line 84

ORA-06512: at line 1

--trce文件内容如下：

[oracle@m1hfdata alert]$ cat /m1hf/diag/rdbms/m1hf/m1hf/trace/m1hf_j000_16753.trc

Trace file /m1hf/diag/rdbms/m1hf/m1hf/trace/m1hf_j000_16753.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /m1hf/oracle

System name:    Linux

Node name:      m1hfdata

Release:        2.6.32-71.el6.i686

Version:        #1 SMP Wed Dec 15 09:50:18 EST 2010

Machine:        i686

Instance name: m1hf

Redo thread mounted by this instance: 1

Oracle process number: 79

Unix process pid: 16753, image: (J000)

*** 2012-05-09 10:48:25.934

*** SESSION ID:(233.31631) 2012-05-09 10:48:25.934

*** CLIENT ID:() 2012-05-09 10:48:25.934

*** SERVICE NAME:(SYS$USERS) 2012-05-09 10:48:25.934

*** MODULE NAME:() 2012-05-09 10:48:25.934

*** ACTION NAME:() 2012-05-09 10:48:25.934

ORA-00600: internal error code, arguments: [kkpo_rcinfo_defstg:objnotfound], [70351], [], [], [], [], [], [], [], [], [], []

ORA-06512: at "APEX_030200.WWV_FLOW_CACHE", line 84

ORA-06512: at line 1

--解决方案：metalink [ID 1308400.1]

BUG:10373381 - ORA-600 [KKPO_RCINFO_DEFSTG:OBJNOTFOUND] AFTER RERUNNING CATUPGRD.SQL