oracle报错ora00200,createdatabase提示ORA01501ORA00200ORA00202ORA27038错误提示

在追求技术的路上总是会遇到坎坷的&＃xff0c;手动创建实例&＃xff0c;因为sysaux01.dbf文件设置的太小 &＃xff0c;ALERT日志提示ORA-3214错误

CREATE TABLESPACE sysaux DATAFILE  &＃39;/oracle/database/oradata/otars/sysaux01.dbf&＃39; size 325 reuse

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE

ORA-3214 signalled during: CREATE TABLESPACE sysaux DATAFILE  &＃39;/oracle/database/oradata/otars/sysaux01.dbf&＃39; 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&＃xff0c;在修改表空间的sysaux01.dbf 值后&＃xff0c;再次执行create database 操作&＃xff0c;就提示标题所说的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: &＃39;/oracle/database/oradata/otars/control01.ctl&＃39;

ORA-27038: created file already exists

Additional information: 1

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

SQL> host

[oracle&＃64;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&＃64;node01 dbs]$ cd !$

cd /oracle/database/oradata/otars/

[oracle&＃64;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&＃64;node01 otars]$ rm -rf *

[oracle&＃64;node01 otars]$ ll

total 0

[oracle&＃64;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 (&＃39;/oracle/database/oradata/otars/redo01.log&＃39;) size 100m,

6     group 2 (&＃39;/oracle/database/oradata/otars/redo02.log&＃39;) size 100m,

7     group 3 (&＃39;/oracle/database/oradata/otars/redo03.log&＃39;) 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 &＃39;/oracle/database/oradata/otars/system01.dbf&＃39; size  325m reuse

16  sysaux datafile &＃39;/oracle/database/oradata/otars/sysaux01.dbf&＃39; size 325m reuse

17  default tablespace users

18     datafile &＃39;/oracle/database/oradata/otars/user01.dbf&＃39; size 100m reuse autoextend on maxsize unlimited

19  default temporary tablespace temp

20     tempfile &＃39;/oracle/database/oradata/otars/temp01.dbf&＃39; size 20m reuse

21  undo tablespace undotbs1

22     datafile &＃39;/oracle/database/oradata/otars/undotbs1.dbf&＃39; size 30m reuse autoextend on maxsize unlimited;

Database created.

来自 “ ITPUB博客 ” &＃xff0c;链接&＃xff1a;http://blog.itpub.net/27039319/viewspace-2134692/&＃xff0c;如需转载&＃xff0c;请注明出处&＃xff0c;否则将追究法律责任。