创建控制文件遭遇ORA-600 kccscf_1

发表于 2013 年 2 月 27 日 由 惜分飞

联系：手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题：创建控制文件遭遇ORA-600 kccscf_1

作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

数据库版本10.2.0.1创建控制文件出现ORA-00600[kccscf_1]错误

SQL> CREATE CONTROLFILE REUSE DATABASE "ITPLUSDW" RESETLOGS  ARCHIVELOG
  2      MAXLOGFILES 16
  3      MAXLOGMEMBERS 3
  4      MAXDATAFILES 100
  5      MAXINSTANCES 8
  6      MAXLOGHISTORY 292000
  7  LOGFILE
  8    GROUP 1 '/backup/oracle/oradata/redo01.log'  SIZE 50M,
  9    GROUP 2 '/backup/oracle/oradata/redo02.log'  SIZE 50M,
 10    GROUP 3 '/backup/oracle/oradata/redo03.log'  SIZE 50M
 11  -- STANDBY LOGFILE
 12  DATAFILE
 13    '/backup/oracle/oradata/system01.dbf',
 14    '/backup/oracle/oradata/undotbs01.dbf',
 15    '/backup/oracle/oradata/sysaux01.dbf',
 16    '/backup/oracle/oradata/users01.dbf',
 17    '/backup/oracle/oradata/itplus_data',
 18    '/backup/oracle/oradata/invertories_data',
 19    '/backup/oracle/oradata/inventories_data01',
 20    '/backup/oracle/oradata/itplus_discover',
 21    '/backup/oracle/oradata/inventories_data02',
 22    '/backup/oracle/oradata/inventories_data03',
 23    '/backup/oracle/oradata/inventories_data05',
 24    '/backup/oracle/oradata/inventories_data04'
 25  CHARACTER SET ZHS16CGB231280
 26  ;
CREATE CONTROLFILE REUSE DATABASE "ITPLUSDW" RESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00600: internal error code, arguments: [kccscf_1], [9], [292000], [65535],[], [], [], []

alert日志错误

Default Temporary Tablespace will be necessary for a locally managed database in future release
Tue Feb 26 15:49:36 2013
Errors in file /backup/oracle/admin/udump/itplustest_ora_25001.trc:
ORA-00600: internal error code, arguments: [kccscf_1], [9], [292000], [65535], [], [], [], []
Tue Feb 26 15:49:36 2013
Errors in file /backup/oracle/admin/udump/itplustest_ora_25001.trc:
ORA-00600: internal error code, arguments: [kccscf_1], [9], [292000], [65535], [], [], [], []
ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ITPLUSDW" NORESETLOGS  ARCHIVELOG

查询mos发现Create Control File fails with ORA-600 [kccscf_1] [ID 387210.1],中有描述，该bug在10.2.0.1到11.1.0.6版本中,如果MAXLOGHISTORY超过了65535均有可能出现，在10.2.0.4和11.1.0.6中修复，部分版本有Patch 4877360修复该问题。在不能升级或者没有patch的情况下，解决该问题的思路是设置MAXLOGHISTORY为65535或者更小值,重建控制文件

此条目发表在 ORA-xxxxx 分类目录，贴了 , , 标签。将固定链接加入收藏夹。

《创建控制文件遭遇ORA-600 kccscf_1》有 1 条评论

  1. 惜分飞 说：
    2013 年 2 月 27 日13:07

    Create Control File fails with ORA-600 [kccscf_1] [ID 387210.1]

    Applies to: 
Oracle Server - Enterprise Edition - Version 10.2.0.1 to 11.1.0.6 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 14-June-2012***

Symptoms
o Create controlfile fails with the following errors:
CREATE CONTROLFILE REUSE SET DATABASE ... RESETLOGS FORCE LOGGING 
ARCHIVELOG
*
ERROR at line 1:
ORA-1503: CREATE CONTROLFILE failed
ORA-600: internal error code, arguments: [kccscf_1], [9], [65732], [65535], [], [], [], []


o Database duplication using RMAN fails with the following errors
ORA-00600: internal error code, arguments: [kccscf_1], [9], [74752], [65535], [], [], [], []
ORA-1503 signalled during: CREATE CONTROLFILE REUSE SET DATABASE ... RESETLOGS

Changes
The problem occurs if compatible parameter is set to 10.2 or higher

Cause
This is unpublished bug 4877360
Abstract: APPSST SRV 10G :ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KCCSCF_1], [9], [65732], [65535]

Problem is related to parameter MAXLOGHISTORY specified in create controlfile command. 
It's complaining that maximum should be 65535.

Solution
A possible workaround is to manually recreate the control file, 
and change the maxloghistory set to 65535 or lower in the script.
The bug is fixed in 10.2.0.4 and 11.1.0.6 versions.
For some platforms a backport fix is available. Please check availability of Patch 4877360 on MOS.
If no Backport fix is available, please contact Oracle Support.