ITPub博客

首页 > 数据库 > Oracle > ORA-01079: ORACLE database was not properly created, operation aborted(未完)

ORA-01079: ORACLE database was not properly created, operation aborted(未完)

原创 Oracle 作者:o0yuki0o 时间:2015-12-16 17:28:43 0 删除 编辑
这次手动安装数据库遇到的问题是
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博客 ” ,链接:https://blog.itpub.net/16131092/viewspace-1873453/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2014-02-26

  • 博文量
    90
  • 访问量
    75894