Change the DBID using NID
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?
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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments