Fixed – ORA-01033: ORACLE initialization or shutdown in progress

ORA-01033 ORACLE initialization or shutdown in progressIn our previous article you have seen how to resolve ORA-12541: TNS no listener error. Now today we will show you how to resolve ORA-01033: ORACLE initialization or shutdown in progress error.

Error Message:

ORA-01033: ORACLE initialization or shutdown in progress

Resolution:

The following video is a practical demonstration to resolve ORA-01033: ORACLE initialization or shutdown in progress error.

As a DBA, you must know the 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 till the database gets shutdown. Now first connect your database with system user.

C:\>sqlplus system/system
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jul 02 12:21:40 2015
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 current status of database and instance, you must login with SYSDBA privileges.

C:\>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jul 02 12:23:42 2015
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 you can see the instance is started but database is not mounted. Now its time to mount the database. Issue following command to 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. Type exit and reconnect with system user.

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 Thu Jul 02 12:25:26 2015
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. Now open your database with SYSDBA privileges.

Enter user-name: / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jul 02 12:30:30 2015
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


Here you can see the database is opened in read write mode and your database issue is resolved. Now you can login with your user name and password to access your database.


Subscribe to get FREE tech advice, tips and in-depth articles directly in your Inbox.


Start Your Dream Website Today & Earn Money Online

To Start a dream website, you need to choose a right Domain Name & Reliable Web Hosting Provider. Host your Domain on Self-hosted Blogging Platform WordPress.

Install SEO complaint WordPress Theme, spread your knowledge through Email Marketing and implement SEO with leading SEO Tool for huge traffic.

Complete Guide to Start a Blog & Make Money in 2017


Leave a Reply

Your email address will not be published. Required fields are marked *