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.