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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16131092/viewspace-1873453/