Re: How can you tell if an oracle database is open at the OS level

Thanks for the great ideas.
This database is refreshed nightly.There are no log switches in the DB except during a refresh.
There was a disk crash which was missed.If there was a way to tell that the database was not running at the time that would have helped (More than one check).
Remember DB can have issues and come up as mounted and at this stage the DB processes run.
We would like to find something at the level of the OS that could tell if the DB is open/mounted.
So that a DB admin does not have to log in to find that out

Thanks for the fast responses Received on Wed Feb 28 2007 - 10:25:29 CST