在追求技术的路上总是会遇到坎坷的,手动创建实例,因为sysaux01.dbf文件设置的太小 ,ALERT日志提示ORA-3214错误
CREATE TABLESPACE sysaux DATAFILE '/oracle/database/oradata/otars/sysaux01.dbf' size 325 reuse
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE
ORA-3214 signalled during: CREATE TABLESPACE sysaux DATAFILE '/oracle/database/oradata/otars/sysaux01.dbf' size 325 reuse
造成database crash 掉
opiodr aborting process unknown ospid (3668) as a result of ORA-1092
Fri Mar 03 20:56:49 2017
ORA-1092 : opitsk aborting process
Fri Mar 03 20:57:49 2017
OK,在修改表空间的sysaux01.dbf 值后,再次执行create database 操作,就提示标题所说的ORA-01501 ORA-00200 ORA-00202 ORA-27038异常信息。
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/oracle/database/oradata/otars/control01.c