I want to know how to check oracle status

"¹ÚÇü¼®" wrote in message news:...
> 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.

Take a look at Karma:
http://freshmeat.net/projects/karma/
http://www.iheavy.com/karma/help/readme.html

And Sean Hull's book (with Andy Duncan):
http://www.oreilly.com/catalog/oracleopen/

even if you don't use his programs, the source is there for you to use.

-bdbafh

"¹ÚÇü¼®" wrote in message news:...
> 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.

Take a look at Karma:
http://freshmeat.net/projects/karma/
http://www.iheavy.com/karma/help/readme.html

And Sean Hull's book (with Andy Duncan):
http://www.oreilly.com/catalog/oracleopen/

even if you don't use his programs, the source is there for you to use.

-bdbafh

"¹ÚÇü¼®" wrote in message news:...
> 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.

Take a look at Karma:
http://freshmeat.net/projects/karma/
http://www.iheavy.com/karma/help/readme.html

And Sean Hull's book (with Andy Duncan):
http://www.oreilly.com/catalog/oracleopen/

even if you don't use his programs, the source is there for you to use.

-bdbafh

"¹ÚÇü¼®" wrote in message news:...
> 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.

Take a look at Karma:
http://freshmeat.net/projects/karma/
http://www.iheavy.com/karma/help/readme.html

And Sean Hull's book (with Andy Duncan):
http://www.oreilly.com/catalog/oracleopen/

even if you don't use his programs, the source is there for you to use.

-bdbafh

"¹ÚÇü¼®" wrote in message news:...
> 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.

Take a look at Karma:
http://freshmeat.net/projects/karma/
http://www.iheavy.com/karma/help/readme.html

And Sean Hull's book (with Andy Duncan):
http://www.oreilly.com/catalog/oracleopen/

even if you don't use his programs, the source is there for you to use.

-bdbafh

"¹ÚÇü¼®" wrote in message news:...
> 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.

Take a look at Karma:
http://freshmeat.net/projects/karma/
http://www.iheavy.com/karma/help/readme.html

And Sean Hull's book (with Andy Duncan):
http://www.oreilly.com/catalog/oracleopen/

even if you don't use his programs, the source is there for you to use.

-bdbafh

"¹ÚÇü¼®" wrote in message news:...
> 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.

Take a look at Karma:
http://freshmeat.net/projects/karma/
http://www.iheavy.com/karma/help/readme.html

And Sean Hull's book (with Andy Duncan):
http://www.oreilly.com/catalog/oracleopen/

even if you don't use his programs, the source is there for you to use.

-bdbafh

"¹ÚÇü¼®" wrote in message news:...
> 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.

Take a look at Karma:
http://freshmeat.net/projects/karma/
http://www.iheavy.com/karma/help/readme.html

And Sean Hull's book (with Andy Duncan):
http://www.oreilly.com/catalog/oracleopen/

even if you don't use his programs, the source is there for you to use.

-bdbafh

"¹ÚÇü¼®" wrote in message news:...
> 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