Re: checkdb up/down script for Windows


"Chuck" <skilover_nospam@xxxxxxxxxxxxxx> wrote in message
news:90utg.16831$Wh7.9408@xxxxxxxxxxx
Matthias Hoys wrote:
"Chuck" <skilover_nospam@xxxxxxxxxxxxxx> wrote in message
news:AJbtg.7566$Zf.1085@xxxxxxxxxxx
Jigar2Reshma@xxxxxxxxx wrote:
Hey everyone : I wanted to see if any one can suggest me or pass any
windows related script tp me on ho to check if an Oracle database on
windows is up/down. if down then send email. I am not a windows expert
but i can write a little batch script.

any help is appreciated.

thanks

The first thing I do on any Windows system is install a copy of CygWIN
so I can use a *real* command line.

As a couple of other posters have already stated, depending on the
version of Oracle you installed either OEM or Grid Control already does
this for you.

You can do everything and beyond with VBS/WMI, no need to install a
"UNIX"
command interface on Windows.
But like everyone else was saying, the built-in 10g DB Console has
everything you need, and is very easy to configure (check the docs). Of
course if your DB Console is down, your monitoring is down also :-) So
you
could add a little vbs script (scheduled with the Windows task scheduler)
to
monitor the status of the DB Console service.

HTH
Matthias Hoys



With VBS, can I run sqlplus and pipe the output to a filter? Or launch
sqlplus in background and interactively communicate with it?

VBS is worlds better than batch files but IMO it still doesn't hold a
candle to cygwin or a real unix shell.

Yes, you can run external programs from within a VBS script with the
wscript.shell object.

Example (should work for sqlplus also) :

set oSh = createObject("Wscript.shell")
ret = oSh.run("%comspec% /c dir >dir.out",0,true)

As for your second question (running sqlplus in the background), I have no
clue how to do this with vbs but I wouldn't be surprised if it was
possible - it's more powerful than most people think (actually, it's not vbs
that's so powerful, it's the whole Windows Script Host environment; vbs is
just a language used to access WSH objects, you could also use another
language like JavaScript for example).


Matthias



.

Relevant Pages

  • Re: Microsoft Warns of New Windows Flaw (March 19, 2003 )
    ... In WINDOWS SETUP in ADD/REMOVE PROGRAMS of Control Panel ... Uninstall Outlook Express, ... Java, Javascript, ActiveX and all the other script runner toys Billy ... Install WebWasher the spammers are terrified of free from ...
    (comp.security.misc)
  • Re: Microsoft Warns of New Windows Flaw (March 19, 2003 )
    ... In WINDOWS SETUP in ADD/REMOVE PROGRAMS of Control Panel ... Uninstall Outlook Express, ... Java, Javascript, ActiveX and all the other script runner toys Billy ... Install WebWasher the spammers are terrified of free from ...
    (comp.security.firewalls)
  • [NT] Flaw in Windows Script Engine Could Allow Code Execution
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... The Windows Script Engine provides Windows operating systems with the ... blocked by Outlook Express 6.0 and Outlook 2002 in their default ...
    (Securiteam)
  • Re: Right click on text vs. right click on hyperlink
    ... I were to do that the built-in Windows way, I have to go down about ... >> me to open in one step the editing page of any archive page in my ... >> contains the below Windows script. ... >> that url and opens the editing page. ...
    (microsoft.public.scripting.vbscript)
  • Re: Turing of SP2 Firewall via registry entry?
    ... Group Policy that disables the firewall (see WF_XPSP2.doc ... Disabling the Use of Windows Firewall Across Your Network ... you create a script file that is read by ...
    (microsoft.public.windowsxp.security_admin)