在手动创建控制文件时，抛出下面错误

SQL> CREATE CONTROLFILE REUSE DATABASE \"HOST\" NORESETLOGS FORCE LOGGING ARCHIVELOG
2 MAXLOGFILES 192
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 1024
5 MAXINSTANCES 32
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 \'+DATA/dbjx/onlinelog/group_1.373.871427395\' SIZE 50M BLOCKSIZE 512,
9 GROUP 2 \'+DATA/dbjx/onlinelog/group_2.265.864426495\' SIZE 50M BLOCKSIZE 512,
10 GROUP 3 \'+DATA/dbjx/onlinelog/group_3.264.864426511\' SIZE 50M BLOCKSIZE 512,
11 GROUP 4 \'+DATA/dbjx/onlinelog/group_4.276.864426525\' SIZE 50M BLOCKSIZE 512,
12 DATAFILE
13 \'+DATA/dbjx/datafile/system.281.864425653\',
14 \'+DATA/dbjx/datafile/sysaux.282.864425855\',
15 \'+DATA/dbjx/datafile/undotbs1.256.864426041\',
16 \'+DATA/dbjx/datafile/users.258.864426167\',
17 \'+DATA/dbjx/datafile/schedule.259.864426229\'
18 CHARACTER SET AL32UTF8
19 ;

收到如下错误

CREATE CONTROLFILE REUSE DATABASE \"HOST\" NORESETLOGS FORCE LOGGING ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00600: internal error code, arguments: [kcfccfl_1], [], [], [], [], [], [],[]

解决方法

GROUP 4 \\\'+DATA/dbjx/onlinelog/group_4.276.864426525\\\' SIZE 50M BLOCKSIZE 512, <--将此处的逗号去掉即可

补充：

For 10.2 Database, you receive:

CREATE CONTROLFILE REUSE DATABASE \"R10205\" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00600: internal error code, arguments: [kcfccfl_1], [], [], [], [], [], [],[]

For 11.1 to 11.2.0.2 Databases, you receive:

CREATE CONTROLFILE REUSE DATABASE \"R11201\" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00600: internal error code, arguments: [kccccfl_1], [], [], [], [], [], [],[], [], [], [], []

For 11.2.0.3 Database, you receive:

ITPub博客

ORA 600[kcfccfl_1] or ORA 600[kccccfl_1] ,ORA02236 create controlfile解决方法