The error message “ORA-011033: ORACLE initialization or shutdown in progress” is typically encountered when trying to connect to an Oracle database that is either in the process of starting up or shutting down. in this blog post we will learn how to resolve ORA-011033 in production environment.
Reason:
This error message can occur for a variety of reasons, such as a database crash or a planned maintenance operation. To resolve issue ora-011033, you can try the following steps:
- Wait for the database to finish the startup or shutdown process: If the database is still starting up or shutting down, you will need to wait until the process is completed before attempting to connect.
- Check the database status: You can check the status of the database by logging in as the Oracle user and running the command “sqlplus / as sysdba” to connect to the database, and then issuing the command “startup” to start the database or “shutdown” to stop it.
PS C:\Users\Administrator> sqlplus system/password as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Thu Apr 27 16:27:53 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL>
Resolution:
if the datafile remove or crashed then shutdown database with mount command like below
SQL> Startup mount
ORA-01081: cannot start already-running ORACLE – shut it down first
SQL> shutdown abort
ORACLE instance shut down.
SQL>
SQL> startup mount
ORACLE instance started.
Total System Global Area 1904054272 bytes
Fixed Size 2404024 bytes
Variable Size 570425672 bytes
Database Buffers 1325400064 bytes
Redo Buffers 5824512 bytes
Database mounted.
Once database mounted successfully then try to recover database with below commands
SQL> recover database
Media recovery complete
SQL> alter database open;
Database altered
- Check the Oracle Listener status: You can also check the status of the Oracle Listener by running the command “lsnrctl status” to verify that it is running and listening on the correct port.
- Verify connectivity: Ensure that the host name, port, and service name are all correct for the database you are trying to connect to database.
- Restart the Oracle Listener: If the above steps do not resolve the issue, you may need to restart the Oracle Listener service.
If the database is mounted but not open then you may end up getting the error as well. To check whether the database is MOUNTED or OPEN or neither of those, hopefully, we can resolve ORA-011033 error message.
Conclusion:
In this blog post we learnt how to resolve ORA-011033 step by step.
Read More
How to unlock files in TFS source controller locked by user who have left or forgot to check in code
