CREATE CONTROLFILE REUSE DATABASE ORCL NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1600
LOGFILE
GROUP 1 '/oracle/app/oracle/oradata/orcl/redo01.log' SIZE 50M,
GROUP 2 '/oracle/app/oracle/oradata/orcl/redo02.log' SIZE 50M,
GROUP 3 '/oracle/app/oracle/oradata/orcl/redo03.log' SIZE 50M,
DATAFILE
'/oracle/app/oracle/oradata/orcl/example01.dbf',
'/oracle/app/oracle/oradata/orcl/sysaux01.dbf',
'/oracle/app/oracle/oradata/orcl/system01.dbf',
'/oracle/app/oracle/oradata/orcl/test01.dbf',
'/oracle/app/oracle/oradata/orcl/undotbs01.dbf',
17 '/oracle/app/oracle/oradata/orcl/users01.dbf';
CREATE CONTROLFILE REUSE DATABASE ORCL NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00600: internal error code, arguments: [kccccfl_1], [], [], [], [], [], [], [], [], [], [], []
原因是没有指定字符集
CREATE CONTROLFILE REUSE DATABASE ORCL NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1600
LOGFILE
GROUP 1 '/oracle/app/oracle/oradata/orcl/redo01.log' SIZE 50M,
GROUP 2 '/oracle/app/oracle/oradata/orcl/redo02.log' SIZE 50M,
GROUP 3 '/oracle/app/oracle/oradata/orcl/redo03.log' SIZE 50M
DATAFILE
'/oracle/app/oracle/oradata/orcl/example01.dbf',
'/oracle/app/oracle/oradata/orcl/sysaux01.dbf',
'/oracle/app/oracle/oradata/orcl/system01.dbf',
'/oracle/app/oracle/oradata/orcl/test01.dbf',
'/oracle/app/oracle/oradata/orcl/undotbs01.dbf',
'/oracle/app/oracle/oradata/orcl/users01.dbf'
CHARACTER SET AL32UTF8
;
原来我的字符集是AL32UTF8