ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 升级失败后,在drop user时出现错误ORA-00600 kkpo_rcinfo_defstg:objnotfound

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

原创 Linux操作系统 作者:YallonKing 时间:2012-05-09 16:55:39 0 删除 编辑
关于升级失败后,在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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-08-07

  • 博文量
    72
  • 访问量
    245995