Database Administration (MOSC)

MOSC Banner

ORA-01033 Oracle initialization or shutdown in progress in Oracle 10 XE 10.2.0

edited Mar 16, 2012 6:25AM in Database Administration (MOSC) 5 commentsAnswered
Hi,

I am running Oracle 10 XE 10.2.0 in Microsoft Window Server 2003 SP2 for more than 2 years.  It is working fine, but today I get the ORA-01033 Oracle initialization or shutdown in

progress error and the database cannot start.

Here are what I get when I run from SQL Command Line:

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area   599785472 bytes

Fixed Size                             1288820 bytes

Variable Size                      239076748 bytes

Database Buffers               356515840 bytes

Redo Buffers                         2904064 bytes

Database mouted.

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center