IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Sometimes you can get ” ORA-01033: ORACLE initialization or shutdown in progress ” error.
ORA-01033: ORACLE initialization or shutdown in progress
Details of error are as follows.
ORA-01033: 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.
ORA-01033: ORACLE initialization or shutdown in progress
ORACLE initialization or shutdown in progress
You should wait a few minutes because shutdown in progress . Sometimes database shutdowns in a 30-60 minutes because of some processses and sessions.
If you don’t want to wait, then you can shutdown database with abort option and start it up again.
SQL> shutdown abort; ORACLE instance shut down. SQL> startup nomount; ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1375792 bytes Variable Size 671089104 bytes Database Buffers 394264576 bytes Redo Buffers 4603904 bytes SQL> alter database mount; Database altered. SQL> alter database open; alter database open
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
if in command alter database open;
the result is erorr at line 1:
how to fix this error
what is the error , i couldn’t understand ?