ORA-01033

环境

WinXP

Oracle 10g（安装路径D:\ORACLE\PRODUCT\10.1.0\）

错误，

ORA-01033: ORACLE initialization or shutdown in progress 

原因

删除SID时，删除了一个表空间的数据文件

处理过程

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\xxxx>sqlplus system/yang@ora

 

SQL*Plus: Release 10.1.0.2.0 - Production on 火 1月 15 12:19:18 2008

 

Copyright (c) 1982, 2004, Oracle. All rights reserved.

 

ERROR:

ORA-01033: ORACLE initialization or shutdown in progress

 

NOLOG登录数据库

C:\Documents and Settings\xxxx>sqlplus /nolog

 

SQL*Plus: Release 10.1.0.2.0 - Production on 火 1月 15 12:35:54 2008

 

Copyright (c) 1982, 2004, Oracle. All rights reserved.

 

使用SYSDBA连接数据库

SQL> connect sys/yang as sysdba

Connected.

关闭数据库

SQL> shutdown normal

ORA-01109: database not open

 

Database dismounted.

ORACLE instance shut down.

 

重启到MOUNT状态

SQL> startup mount

ORACLE instance started.

 

Total System Global Area 171966464 bytes

Fixed Size                    787988 bytes

Variable Size              145488364 bytes

Database Buffers            25165824 bytes

Redo Buffers                  524288 bytes

Database mounted.

 

ALTER 数据库 OPEN状态

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01147: SYSTEM tablespace file 1 is offline

ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA\SYSTEM01.DBF'

显示出 datafile 1发生错误 

 

修改datafile 1的状态

SQL> alter database datafile 1 online;

 

Database altered.

 

数据库状态

SQL> alter database open ; 

Database altered.

数据库正常

SQL> conn system/yang@ora

Connected.

SQL> select * from state;

 

CNT_C ST_ ST_NAME

----- --- ----------

1      11 123

1      11 123

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11893231/viewspace-676183/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11893231/viewspace-676183/