ORA-01033: ORACLE initialization or shutdown in progress (DB

PLSQL Developer连不上,然后在em网页中看到
ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)
百度
http://www.360doc.com/content/08/0804/22/16915_1510460.shtml

以sys登录为sysdba
sqlplus /NOLOG
SQL>connect sys/用户口令as sysdba
SQL>shutdown normal
SQL>startup mount
SQL>alter database open
SQL>shutdown normal
SQL>startup

结果出现
SQL> alter database open
2 ;
alter database open
*
第 1 行出现错误:
ORA-01157: 无法标识/锁定数据文件 5 - 请参阅 DBWR 跟踪文件
ORA-01110: 数据文件 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'

再百度
http://space.itpub.net/12778571/viewspace-676515


重建控制文件：

1、 SQL>alter database backup controlfile to trace as ‘E:trace’;

2、 关闭数据库：shutdown immediate

3、 启动：startup nomount

4、 打开‘E:trace’文件，在数据库执行下面的语句，重建控制文件

CREATE CONTROLFILE REUSE DATABASE "XBOMS" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'E:ORACLEPRODUCT10.2.0ORADATAXBOMSREDO01.LOG' SIZE50M,
GROUP 2 'E:ORACLEPRODUCT10.2.0ORADATAXBOMSREDO02.LOG' SIZE50M,
GROUP 3 'E:ORACLEPRODUCT10.2.0ORADATAXBOMSREDO03.LOG' SIZE50M
DATAFILE
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSSYSTEM01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSUNDOTBS01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSSYSAUX01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSUSERS01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSMLOG_NORM_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSGPE_NORM_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSLOG_NORM_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSDH_NORM_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSDRILL_NORM_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSPUB_NORM_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSMLOG_LOB_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSGPE_LOB_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSLOG_LOB_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSDH_LOB_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSDRILL_LOB_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSPUB_LOB_SPACE.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAXBOMSXBMIDDLE_MLOG_SPACE.DBF'
CHARACTER SET ZHS16GBK
;
(ps:trace里面的create语句直接粘上去会有错，自己删去错误的地方。。。或者一段一段的粘上去)
5、RECOVER DATABASE



6、ALTER DATABASE OPEN;


参考：http://www.360doc.com/content/08/0804/22/16915_1510460.shtml

http://space.itpub.net/12778571/viewspace-676515

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!