By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
SQL> shutdown immediate
SQL> startup mount
ORACLE instance started.
SQL> select status from v$instance; STATUS
If you perform the same operations and the query from V$INSTANCE is reporting OPEN, then there must be some other process that is opening the database. Is it possible that you have a cron or OEM job that does something to this affect?
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.