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

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

In this short tutorial we will be looking at how to resolve ORA-01033 ORACLE initialization or shutdown in progress.

An error was encountered performing the requested operation: ORA-01033: ORACLE 
initialization or shutdown in progress 01033. 
00000 - "ORACLE initialization or shutdown in progress" *Cause: An attempt was made to 
log on while Oracle is being started 
up or shutdown. *Action: Wait a few minutes. Then retry the operation. Vendor code 1033

You might get this error when connecting to the database from various applications, for me it was SQL Developer, so here is how to resolve it.

Resolving ORA-01033

  • Log on to the server that host the database and connect to the database via sqlplus as SYSDBA.
sqlplus / as sysdba
  • Check the status of the database¬† by running the SQL command below.
SQL> select status, database_status from v$instance;

STATUS           DATABASE_STATUS

------------   -----------------

MOUNTED          ACTIVE

By running the query we see that the database is mounted. In order to get rid of the error and access the database we will need to change the status of the database to OPEN.

  • To gain access to the database again we will need to change the database status to OPEN. Execute the command below:
alter database open;
  • The database should now be open and access restored. To check the status of the database again you can execute the command below or try connecting to the database again from your application.
SQL> select status, database_status from v$instance;

STATUS         DATABASE_STATUS

------------ -----------------

OPEN           ACTIVE

 

Check out our other Database Posts:

PostgreSQL 12 Streaming replication on Ubuntu easy step-by-step guide

How to easily access SQL Server 2019 if locked out

How To: SQL Server job progress check