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
