ORA-600 [kkpo_rcinfo_defstg:objnotfound]

Maclean Liu(刘相兵

Question:

网友 安装了oracle11g，之后又安装了oracle的update，在update过程中有一些提示，他忽略，继续update安装
问题：不能删除用户名和表空间，提示如下错误：



新建用户后，删除用户，出现如下错误：


我的这种问题该怎么解决呢？

我也说不上安装里边的update是属于更新还是修补
是oracle11gR2的，安装在win2008R2的64位系统下

Maclean Liu(刘相兵

Answer:

你是升级到什么版本？　11.2.0.2?


运行 以下SQL 看一下版本：

select * from v$version ;


在升级过程中的 catupgrad.sql运行错误 可能导致该问题。


ODM Finding:

1. ORA-600 [kkpo_rcinfo_defstg:objnotfound] After Upgrade To 11.2.0.2 [ID 1290342.1]
   
2. 
   
3. Applies to:
   
4. Oracle Server - Enterprise Edition - Version: 11.2.0.2.0 and later   [Release: 11.2 and later ]
   
5. Information in this document applies to any platform.
   
6. Symptoms
   
7. You can get the following error after upgrade from 10.2.0.5 to 11.2.0.1 and then installation of 11.2.0.2 patchset.
   
8. 
   
9. ORA-00600: internal error code, arguments: [kkpo_rcinfo_defstg:objnotfound], [xxxxxx], []
   
10. 
    
11. 
    
12. The stack trace will look similar to the following:
    
13. kkpo_rcinfo_defstg <- ktsircinfo_main <- kkdoilsn <- kkdolsoi <- kkdlgcd <- kkmfbtcn <- qcsIsColInFro <- qcsRslvColWithinQbc <- qcsStrongColRslv <- qcsRslvCol <- qcsRslvName <- qcsridn <- qcsraic <- qcspqbDescendents <- qcspqb <- qcsevw <- qcsfpsq <- kkmfcbsq <- kkmpfcbk <- qcsprfro <- qcsprfro_tree <- qcsprfro_tree <- qcspqbDescendents <- qcspqbDescendents <- qcspqb <- kkmdrv <- rpiswu2 <- opiSem <- opiprs <- kksParseChildCursor <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- opipls <- opiodr <- rpidrus <- skgmstack
    
14. 
    
15. 
    
16. Following query shall also return 0 rows:
    
17. 
    
18. SQL> SELECT COUNT(*)
    
19.      FROM   deferred_stg$;
    
20. 
    
21. 
    
22. Changes
    
23. Upgrade performed from 10gR2 to 11.2.0.1 and then 11.2.0.2.
    
24. Cause
    
25. 
    
26. This issue has been identified as Bug:10373381.
    
27. 
    
28. ORA-600 [kkpo_rcinfo_defstg:objnotfound] may be seen after re-running catupgrd.sql on 11.2.0.1 due to the dropping and recreating of the SYS table deferred_stg$.
    
29. Solution
    
30. 
    
31. 1.  Apply the 11.2.0.2.2 PSU Patch: 11724916 or higher.
    
32. 
    
33.     If on Exadata, download and apply the 11.2.0.2. Bundle Patch 6 Patch:12326685 or higher (See NOTE: 1314319.1 for latest 11.2.0.2 Exadata patches).
    
34. 
    
35. 
    
36. 
    
37.     If on Windows, apply the 11.2.0.2 Patch 3 or higher (See NOTE:1114533.1 for latest 11.2.0.2 patch)
    
38.     32-Bit Patch:11731183
    
39.     64-Bit (x64) Patch:11731184
    
40. 
    
41. OR
    
42. 
    
43. 2.  If available for your platform and version, download and apply Patch 10373381
    
44. 
    
45. OR
    
46. 
    
47. 3.  As a workaround, restore and perform a direct upgrade from 10.2.0.5 to the 11.2.0.2 release.
    
48. References
    
49. BUG:10373381 - ORA-600 [KKPO_RCINFO_DEFSTG:OBJNOTFOUND] AFTER RUNNING CATUPGRD.SQL
    
50. NOTE:10373381.8 - Bug 10373381 - ORA-600 [kkpo_rcinfo_defstg:objnotfound] after rerunning catupgrd.sql in 11.2
    
51. NOTE:1114533.1 - 11.2.0.x Oracle Database and Networking Patches for Microsoft Platforms
    
52. NOTE:1314319.1 - Bug Fix List: the 11.2.0.2 Patch Bundles for Oracle Exadata Database Machine

复制代码