Fixed – 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.

I use SEMRush for Keyword Research & Boost Organic Traffic. Do You?

Highly recommended SEM & SEO Tool for overview of Traffic, Keywords, Backlinks and more. You can search your competitors URL to analyze keywords & crush your competition.



Get Free Blogging Tips & Technology updates in your Email !!!

Subscribe via RSS feed


The following two tabs change content below.
Anil Kumar
IT Blogger Tips focus on Blogging Tips, SEO Tips, Social Media, SQL Tips, PL/SQL Tips, Oracle DBA, Linux/Unix, Latest Technology, How Tos and Technical Solutions. You can find us on Facebook | Twitter |
Find on Google+

  • Krishna

    Hi,
    It’s worked.
    my export file name = tablexp.dmp .(my table name = ex)
    Now I want to delete my table from “SQL> drop table ex;” and I open/Import ex table again.(with SQL>select*from command).

  • lloyd

    Please help with below

    ORA-01033: ORACLE initialization or shutdown in progress

    I installed oracle 10g and I getting the above error.before started to receive this error my installation complained about my password that has expired.I reused the password that I have and it worked but on subsequent login I got ORA-01033:. why should a password expire because I am using student licence with UNISA

    • If your user password has been expired, first tell your sys administrator or dba rights user to renew your password using below command.
      Alter user identified by .
      Exp. – Alter user scott identified by tiger;

  • Mark Shanu

    I did as was instructed but i got the error below:

    Enter user-name: sys as sysdba
    Enter password:

    Connected to:
    Oracle Database 11g Release 11.2.0.1.0 – 64bit Production

    SQL> select status, database_status from v$instance;

    STATUS DATABASE_STATUS
    ———— —————–
    MOUNTED ACTIVE

    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
    [613], [42759], [42760], [], [], [], [], [], [], []

    SQL>

    what do i do to get working?

    • Musab

      Under this situation follow the following steps:

      SQL> startup mount

      ORACLE Instance started

      SQL> recover database

      Media recovery complete

      SQL> alter database open

      Database altered

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)