Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: I want to know how to check oracle status
"¹ÚÇü¼®" <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