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

In message <1172679926.034867.13770_at_h3g2000cwc.googlegroups.com>, Massa Batheli <mngong_at_gmail.com> writes
>
>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.

Enterprise manager can monitor the state of instances as can most other monitoring tools.

If you must roll your own, you can write something in java or c/OCI or Perl/DBI which attempts to connect and interprets any error code appropriately.

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>