How to find database status [message #300907] |
Mon, 18 February 2008 11:54  |
itguru
Messages: 19 Registered: July 2007
|
Junior Member |
|
|
how to find database status Eg.in nomount , mount or open stage.
If database/instance in nomount stage & how to close instabce.
If shutdown command is given it close instance but gives error database is open.
from mount stage is it possible to take it in nomount stage.
|
|
|
|
|
|
Re: How to find database status [message #300927 is a reply to message #300923] |
Mon, 18 February 2008 13:50   |
itguru
Messages: 19 Registered: July 2007
|
Junior Member |
|
|
Michel Cadot wrote on Mon, 18 February 2008 13:22 | Did you have a look at v$database and v$instance?
Regards
Michel
|
if datase is not open these views are are not working
oracle 9.0.1 windows xp
|
|
|
|
|
|
|
|
|
|