（2013/03/13 - 2013/03/15） 公司 ORACLE EBS 11i 已维护处理两天，具体是因为在系统正常动作的过程中，先是发现运行无比的慢，web page / forms / search 无响应。决定重启 Apps / DB，就在关闭 DB 时，出现错误：ORA-00600: internal error ccdode, arguments: [], [], [], [], [], [], [], []
强行重启DB后，进入 Apps –> Forms 作业操作，出现各种莫名奇妙的Errors；接着进入后台DB查看到超过 1 万多个 Object（package/function/procedure/view… 对象）Invalid失效，Compile Invalid Objects，当进入 Apps –> Forms 作业操作，还是出现各种莫名奇妙的Errors，并且还导致之前 Compile OK 的对象又变成Invalid无效了。
解决方案：
ORA00600
Metalink ID: 752428.1
Check Trace Log
Trace file Log path:
/oracle/prod/pklgpidb/10.2.0/admin/PKLGPI_ibmp52a1/udump
ORA-00600: internal error ccdode, arguments: [kksfbc-reparse-infinite-loop], [0x11046CC20], [], [], [], [], [], []
Check Invalid Object
SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
set pagesize 10000
column d_name format a20
column p_name format a20
select do.obj# d_obj,do.name d_name, do.type# d_type,
po.obj# p_obj,po.name p_name,
to_char(p_timestamp,'DD-MON-YYYY HH24:MI:SS') "P_Timestamp",
to_char(po.stime ,'DD-MON-YYYY HH24:MI:SS') "STIME",
decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') X
from sys.obj$ do, sys.dependency$ d, sys.obj$ po
where P_OBJ#=po.obj#(+)
and D_OBJ#=do.obj#
and do.status=1 /*dependent is valid*/
and po.status=1 /*parent is valid*/
and po.stime!=p_timestamp /*parent timestamp not match*/
order by 2,1;
Change SGA Memory size
$ORACLE_HOME/dbs
(/oracle/uat/uklgpidb/10.2.0/dbs)
Vi initUKLGPI.ora
sga_target = 1G
Recompile the invalid object
Change db user
sqlplus / as sysdba
SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
Run utlrp.sql to recompile the invalid objects.
cd $ORACLE_HOME/rdbms/admin/
@utlrp.sql; (may be more than 3 times)
Change Apps User
Compile the Apps Schema
Use adadmin to recompile theh apps schema
Enable maintenance mode
Chose 3 to compile the Apps schema (about 3mins)
Disable maintenance mod
Apply Opatch
Please check the optach path first.
echo $PATH:$ORACLE_HOME/OPatch
and check the folder access right.
# 1. To apply the patch, unzip the PSE container file:
# p7460291_10203_AIX64-5L.zip
## 2. PreInstall steps:
# shutdown
## 3. Set your current directory to the directory where the patch
# is located:
## % cd 7460291
## Ensure that the directory containing the opatch script appears in
# your $PATH; then enter the following command:
## % opatch apply
## 4. PostInstall Steps:
# startup