Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can you tell if an oracle database is open at the OS level

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

From: Jim Smith <usenet01_at_ponder-stibbons.com>
Date: Wed, 28 Feb 2007 17:32:28 +0000
Message-ID: <L9pfmZRsyb5FFwVS@jimsmith.demon.co.uk>


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>
Received on Wed Feb 28 2007 - 11:32:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US