这次手动安装数据库遇到的问题是
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/,如需转载,请注明出处,否则将追究法律责任。