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: I want to know how to check oracle status

Re: I want to know how to check oracle status

From: Candido Dessanti <candido.dessanti_at_blunet.it>
Date: 23 Aug 2004 08:15:15 -0700
Message-ID: <11c1e2d8.0408230715.79674408@posting.google.com>


"¹ÚÇü¼®" <uxguru_at_becsolutions.com> wrote in message news:<cgbkb0$p84$1_at_news1.kornet.net>...
> Hi~!
>
> I want to know how to check oracle status, start or stop or mount etc.,
> before start backup or restore.
> Not on consol but on program.
> I'm making a program. ^^
> I have to check oracle process?
> Or, I have to check the table about oracle information?
> Does it have another way?
>
> Thank you.

you can check for the pmon process to know if instnace is up or down then if it's up you can query the dynamic view v$instance to know the statuis of the database (open,closed,mounted) in this way select status from v$instance Received on Mon Aug 23 2004 - 10:15:15 CDT

Original text of this message

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