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

On Feb 28, 12:32 pm, Jim Smith <usene..._at_ponder-stibbons.com> wrote:
> In message <1172679926.034867.13..._at_h3g2000cwc.googlegroups.com>, Massa
> Batheli <mng..._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>

There are differences between open, mounted and shutdown. You should ask your dba to help you out here to write the proper script for the purpose.

By going behind his/her back things can only get worse as you won't know when/what/why he is [has scheduled to be] doing. Received on Wed Feb 28 2007 - 16:32:41 CST