How to check a database is closed on W2000
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to check a database is closed on W2000

  1. #1
    Join Date
    Jun 2002
    Posts
    14

    How to check a database is closed on W2000

    Hi,

    Oracle 81.7.4
    W2000

    I would like to know if there is a way of checking using a script that a database is definately shutdown.

    This is quite easy on Unix (ps -ef | grep smon) but I'm unable to find the equivalent on W2000.

    I looked for the file which starts "ik" that is created on Unix everytime an instance is started but have failed to find one of those files on the W2000 machine.

    I've looked at views, etc that I could call from svrmgrl, but they all need the instance to be at the nomount stage atleast.

    Any suggestions would be very helpful.

    TIA

    Charlotte

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    To check for Oracle running in Windows you will neeed install some utilitity to check for threads, you will find one in www.sysinternals.com, and for Win2k MS offers one to download in MS technet, AFAIK.

    Regards,

    Chiappa

  3. #3
    Join Date
    Sep 2002
    Posts
    411
    stop the Oracle services, if it's not started then the database is not available

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Alert.log, will say in what state the DB is?

    or even you could check for process ORACLE.exe..
    of course you cant be for sure that if Oracle.exe is running, DB is UP...coz Oracle Process are considered/alloted as threads rather than seperate processes as in UNIX and so(I blv).

    But other ways round is true, that if Oracle.exe isnt running than DB is suerly down. ( I assume only 1 instance running )

    Better if you have WIN resource kit, by which you will be able to know if the threads ( oracle background processes ).
    Havent used it, but read it in Microsoft Sites.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Jun 2002
    Posts
    14
    Hi,

    Thanks for the help. I'll try these out and see how I get on.

    Regards

    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width