Requires Free Membership to View
SQL> shutdown immediate
Database closed.
Database dismounted.
SQL> startup mount
ORACLE instance started.
...
Database mounted.
SQL> select status from v$instance;
STATUS
-----------
MOUNTED
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?
This was first published in April 2005

Join the conversationComment
Share
Comments
Results
Contribute to the conversation