在追求技术的路上总是会遇到坎坷的，手动创建实例，因为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.ctl'
ORA-27038: created file already exists
Additional information: 1

因为第一次未创建成功，在其创建过程中生产的文件属于”垃圾文件“，只需要删除第一次生产的文件，就可以解决上面提到的异常信息

SQL> host
[oracle@node01 dbs]$ ll /oracle/database/oradata/otars/
total 674424
-rw-r----- 1 oracle oinstall 17612800 Mar 3 20:56 control01.ctl
-rw-r----- 1 oracle oinstall 17612800 Mar 3 20:56 control02.ctl
-rw-r----- 1 oracle oinstall 104858112 Mar 3 20:56 redo01.log
-rw-r----- 1 oracle oinstall 104858112 Mar 3 20:56 redo02.log
-rw-r----- 1 oracle oinstall 104858112 Mar 3 20:56 redo03.log
-rw-r----- 1 oracle oinstall 340795392 Mar 3 20:56 system01.dbf
[oracle@node01 dbs]$ cd !$
cd /oracle/database/oradata/otars/
[oracle@node01 otars]$ ll
total 674424
-rw-r----- 1 oracle oinstall 17612800 Mar 3 20:56 control01.ctl
-rw-r----- 1 oracle oinstall 17612800 Mar 3 20:56 control02.ctl
-rw-r----- 1 oracle oinstall 104858112 Mar 3 20:56 redo01.log
-rw-r----- 1 oracle oinstall 104858112 Mar 3 20:56 redo02.log
-rw-r----- 1 oracle oinstall 104858112 Mar 3 20:56 redo03.log
-rw-r----- 1 oracle oinstall 340795392 Mar 3 20:56 system01.dbf
[oracle@node01 otars]$ rm -rf *
[oracle@node01 otars]$ ll
total 0
[oracle@node01 otars]$ exit
exit

SQL> create database otars
2 user sys identified by oracle
3 user system identified by oracle
4 logfile
5 group 1 ('/oracle/database/oradata/otars/redo01.log') size 100m,
6 group 2 ('/oracle/database/oradata/otars/redo02.log') size 100m,
7 group 3 ('/oracle/database/oradata/otars/redo03.log') size 100m
8 maxlogfiles 50
9 maxlogmembers 5
10 maxloghistory 1
11 maxdatafiles 1024
12 character set AL32UTF8
13 national character set AL16UTF16
14 extent management local
15 datafile '/oracle/database/oradata/otars/system01.dbf' size 325m reuse
16 sysaux datafile '/oracle/database/oradata/otars/sysaux01.dbf' size 325m reuse
17 default tablespace users
18 datafile '/oracle/database/oradata/otars/user01.dbf' size 100m reuse autoextend on maxsize unlimited
19 default temporary tablespace temp
20 tempfile '/oracle/database/oradata/otars/temp01.dbf' size 20m reuse
21 undo tablespace undotbs1
22 datafile '/oracle/database/oradata/otars/undotbs1.dbf' size 30m reuse autoextend on maxsize unlimited;

Database created.

ITPub博客

create database提示ORA-01501 ORA-00200 ORA-00202 ORA-27038错误提示

最新文章