ORA-01033: ORACLE initialization or shutdown in progress
785153Dec 13 2010 — edited Dec 14 2010Windows XP with 10g 10.2.0.10
I got some issue as below. Thus, I restart the Oracle service, but I still encountered the same issue. I reboot the system, am still encountering the same issue
as below. Please help.
C:\WINDOWS\system32>sqlplus sys/password@orcl as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 13 15:58:13 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select from dual;*
ADDR INDX INST_ID D
-------- ---------- ---------- -
*0366CD54 0 1 X*
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
C:\WINDOWS\system32>sqlplus user/password@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 13 15:58:36 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
E*RROR:*
ORA-01033: ORACLE initialization or shutdown in progress
Enter user-name:
I have tried the following steps:
alter database open
*
ERROR at line 1:
ORA-16038: log 2 sequence# 388 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
Edited by: 782150 on Dec 13, 2010 1:23 PM