Summary: in this tutorial, you will learn how to fix up the issue of the following error. When you connect to the Oracle Database
through PL/SQL, SQLPLUS or weblogic server
ORA-01033: ORACLE initialization or shutdown in progress
By the following ways, you can get an error because of your database is started but not mounted.
This is PL/SQL login error
This is SQL Plus login error
Next , login to the database as a sys user to sysdba.
We know that the startup process of database as below:
Now, you can check the status of instance and we can see there is orcl instance is started but
it should be mounted and opened for accessible.
SELECT instance_name, status FROM v$instance;
To check mount status use the following command and there is database mode is not mounted
select open_mode from v$database;
Execute the following command to mount the database and check status
alter database mount;
Now your database is mounted and it should be opened for accessible. So again execute
the following command to be ready for access
alter database open;
Now, finally your database is ready to access by hr user and the problem is permanently solved.
During this process if you get error message:
Oracle database fails to start, error message ORA-00214: control file control02.ctl
inconsistent with file control01.ctl
Then do the following tasks,
Forcefully shutdown the instance
shutdown immediate;
Then copy this file D:/app/Administrator/oradata/orcl/CONTROL01.CTL
And replace with D:/app/Administrator/fast_recovery_area/orcl/CONTROL02.CTL.
Noted: the name of file should be as usual which was earlier
Now, start the instance
the issue is completely done now
Thanks for being with us.
