关于升级失败后,在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