Cause
The error message “ORA-01089: immediate shutdown or close in progress – no operations are permitted” is an Oracle error message indicating that the database instance is in the process of being shut down or closed and no operations are allowed until the shutdown is complete.
Resolution
To resolve this issue, you should wait for the shutdown to complete and try again later. If the problem persists then you should have to act like below
- you should check the alert log and trace files for any errors that might have occurred during the shutdown process.
- You can also try restarting the database instance to see if that resolves the issue.
- If the problem persists even after restarting the database then you have to perform as following
1- Connect Database server with sys user
PS C:\Users\Administrator> sqlplus system/password as sysdba
2- verify database status
SQL> select status, database_status from v$instance;
shutdown abort the Instance then start it up again as follows. Once instance is started up, run shutdown immediate and startup again.
SQL> shutdown abort SQL> startup SQL> shutdown immediate SQL> startup
If the problem persists even after restarting the database, you may need to contact your database administrator or Oracle support for further assistance.
