We are encountering ths problem:
DATABASE OPEN: error when opening database:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
ORA-01089: immediate shutdown in progress - no operations are permitted.Can you tell us in what situations do we get this error?
Your database is trying to shut down. When it is trying to shut down, no one is allowed to log in. To find out why your database is trying to shut down, you'll have to look in your database's alert log file for clues.
Sometimes, the database won't shut down no matter how long you wait. So you'll have to force it down and then restart it. The following commands in SQL*Plus should do the trick:
connect / as sysdba shutdown abort startupYou should now be able to connect to your database.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.