升級失敗後，在drop user時出現錯誤ORA-00600 kkpo_rcinfo_defstg:objnotfound

YallonKing發表於2012-05-09
OBJ
關於升級失敗後，在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: oracle@m1hfdata (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

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

相關文章