oracle 01079,ORA-01079: ORACLE database was not properly created, operation aborted（未完）

这次手动安装数据库遇到的问题是

ORA-01079: ORACLE database was not properly created, operation aborted

SQL> !oerr ora 1079

01079, 00000, "ORACLE database was not properly created, operation aborted"

// *Cause:  There was an error when the database or control file was created.

// *Action:  Check what error was signaled when the database was first

//           created or when the control file was recreated. Take appropriate

//           actions to recreate the database or a new control file.

解决对策就是，把原来的control file del(保险起见我是做了备份) 后重新创建 control file

用下面这段脚本

CREATE CONTROLFILE REUSE DATABASE "cnebtd"  NORESETLOGS

MAXINSTANCES 1

MAXLOGHISTORY 1

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXDATAFILES 100

LOGFILE GROUP 1 ('/dcnebd1/doradata/cnebtd/log1cnebtd.dbf') size 500M,

GROUP 2 ('/dcnebd1/doradata/cnebtd/log2cnebtd.dbf') size 500M,

GROUP 3 ('/dcnebd1/doradata/cnebtd/log3cnebtd.dbf') size 500M

DATAFILE '/dcnebd1/doradata/cnebtd/dbs1cnebtd.dbf'

CHARACTER SET AL32UTF8

至此，control file 已经重新建立完成。

SQL> startup nomount

SQL> CREATE DATABASE cnebtd

MAXINSTANCES 1

MAXLOGHISTORY 1

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXDATAFILES 100

DATAFILE '/dcnebd1/doradata/cnebtd/dbs1cnebtd.dbf'

sysaux datafile '/dcnebd1/doradata/cnebtd/dbx1cnebtd.dbf'

UNDO TABLESPACE undotbs DATAFILE '/dcnebd1/doradata/cnebtd/undo01.dbf'

DEFAULT TEMPORARY TABLESPACE tempts

CHARACTER SET AL32UTF8

NATIONAL CHARACTER SET AL16UTF16

LOGFILE GROUP 1 ('/dcnebd1/doradata/cnebtd/log1cnebtd.dbf') size 500M,

GROUP 2 ('/dcnebd1/doradata/cnebtd/log2cnebtd.dbf') size 500M,

GROUP 3 ('/dcnebd1/doradata/cnebtd/log3cnebtd.dbf') size 500M;  14   15

CREATE DATABASE cnebtd

*

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-01501: CREATE DATABASE failed

ORA-01519: error while processing file '?/rdbms/admin/dcore.bsq' near line 30

ORA-00604: error occurred at recursive SQL level 1

ORA-01119: error in creating database file

'/dcnebd1/doradata/cnebtd/dbs1cnebtd.dbf'

ORA-17610: file '/dcnebd1/doradata/cnebtd/dbs1cnebtd.dbf' does not exist and no

size specified

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Process ID: 11239

Session ID: 197 Serial number: 1

数据库创建完成后，v$动态视图可以使用，DBA_XXX等视图还不可用。

再运行脚本创建ORACLE的数据字典。建议spool输出脚本运行结果，便于排查错误。

SQL>@?/rdbms/admin/catalog.sql

SQL>@?/rdbms/admin/catproc.sql

SQL>@?/rdbms/admin/catexp.sql

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16131092/viewspace-1873453/，如需转载，请注明出处，否则将追究法律责任。