How to fix ORA-01033: ORACLE initialization or shutdown in progress

 
When you login into Oracle Database and it throws following error message:
ORA-01033: ORACLE initialization or shutdown in progress
Then follow the below mentioned steps to solve this issue.
Ora-011033 Oracle error
As a DBA, you must know that Shutdown, Shutdown Immediate or Startup commands that are issued by database administrator with SYSDBA privileges.
If your database shutdown is in progress then wait for some time until the database is shutdown and start your database with Startup command.
C:\>sqlplus system/system
SQL*Plus: Release 11.2.0.2.0 Production on Tue Nov 18 12:21:40 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
To check the status of instance and database, login with SYSDBA privileges and follow the steps.


C:\>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Tue Nov 18 12:22:30 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 – Production
SQL> select status, database_status from v$instance;
STATUS       DATABASE_STATUS
------------ -----------------
STARTED      ACTIVE

SQL> select open_mode from v$database;
select open_mode from v$database
                      *
ERROR at line 1:
ORA-01507: database not mounted
Here we can see the instance is started but database is not mounted.
Now mount the database, if this succeeds then there is no problem.
SQL> alter database mount;
Database altered.
SQL> select status, database_status from v$instance;
STATUS       DATABASE_STATUS
------------ -----------------
MOUNTED      ACTIVE
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
Database is mounted successfully but when you try to connect, you still get the same ORA-01033 error:
SQL> exit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 – Production
C:\>sqlplus system/system
SQL*Plus: Release 11.2.0.2.0 Production on Tue Nov 18 12:25:55 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
When you open the database, you must ensure that database is opened in read write mode. Open your database with SYSDBA privileges and open the database.
Enter user-name: / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Nov 19 12:25:55 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
SQL> alter database open;
Database altered.
SQL> select status, database_status from v$instance;
STATUS       DATABASE_STATUS
------------ -----------------
OPEN         ACTIVE
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
Now the database is opened in read write mode and your database is up. You can login with your user and can use your database.

Post a Comment