ORA-01033,ORA-01147,ORA-01110:

错误编码：ORA-01033: ORACLE initialization or shutdown in progress

故障描述：因为移动了数据库文件（[NAME].DMP）/日志文件等文件，导致数据库连接出现ORA-01033错误。

故障分析：网上有一种常见的说法是该类故障通常是由于移动文件而影响了数据库日志文件出现损坏而导致的无法正常进行IO操作而引起的错误。ORACLE将识别为数据库未装载完成而导致出现如上错误。

故障特征：使用命令行sqlplus或PL/SQL Developer均无法打开数据库。但是可以使用sys用户以sysdba的身份登录系统

处理步骤：

1. 在 ‘开始’-->‘运行’执行cmd

2. 输入：sqlplus "/ as sysdba"

? 应提示类似于如下信息：

SQL*Plus: Release 9.2.0.1.0 - Production on 星期三 5月 20 22:07:45 2009

Copyright (c) 1982, 2002, Oracle Corporation.? All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

3. 输入：shutdown immediate
? 应提示类似于如下信息：

ORA-01109: 数据库未打开

已经卸载数据库。

4. 输入：startup

? 应提示类似于如下信息：

ORA-01157: 无法标识/锁定数据文件 15 - 请参阅 DBWR 跟踪文件
ORA-01110: 数据文件 15: 'D:\TEST\MY_INDEX1_1.DBF'
5. 根据第4步信息输入：alter database datafile 'D:\TEST\MY_INDEX1_1.DBF' offline drop

? 应提示类似于如下信息：

数据库已更改。

6. 重复第3、4、5步骤，直到第4步不再出现ORA-01157、ORA-01110错误信息，即告OK.

?

?

?

======================================================================

?

?

?

Oracle数据库练习出现这样的问题：

ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DAUP\SYSTEM01.DBF'

解决办法：

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 126950220 bytes
Fixed Size?????????????????? 453452 bytes
Variable Size???????????? 109051904 bytes
Database Buffers?????????? 16777216 bytes
Redo Buffers???????????????? 667648 bytes
Database mounted.
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DAUP\SYSTEM01.DBF'

SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 126950220 bytes
Fixed Size?????????????????? 453452 bytes
Variable Size???????????? 109051904 bytes
Database Buffers?????????? 16777216 bytes
Redo Buffers???????????????? 667648 bytes
Database mounted.


SQL> alter database datafile 'D:\ORACLE\ORADATA\DAUP\SYSTEM01.dbf' online;

Database altered.

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

<script type="text/javascript"></script>