oracle controlfile笔记

最新推荐文章于 2021-04-08 14:10:52 发布

原创最新推荐文章于 2021-04-08 14:10:52 发布 · 298 阅读

CC 4.0 BY-SA版权

本文介绍了一次创建Oracle数据库控制文件时遇到的ORA-01503错误及解决过程。原因在于未指定字符集参数，通过添加CHARACTER SET AL32UTF8解决了问题。

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
;