Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01033: ORACLE initialization or shutdown in progress

785153Dec 13 2010 — edited Dec 14 2010
Windows 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2011
Added on Dec 13 2010
4 comments
241 views