+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 17

I want to know how to check oracle status

  1. I want to know how to check oracle status

    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.



  2. Re: 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

  3. Re: 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

  4. Re: 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

  5. Re: 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

  6. Re: 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

  7. Re: 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

  8. Re: 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

  9. Re: 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

  10. Re: 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.


    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

+ Reply to Thread
Page 1 of 2 1 2 LastLast