Please cc me too.
Thanks
GovindanK Certified DBA(8,8i) Brainbench Master(8)
Dick,
I would love to look at it if you would send it to me.
Thanks,
Mike
michael.milligan@xxxxxxxxxxx
-----Original Message----- From: Goulet, Dick [mailto:DGoulet@xxxxxxxx] Sent: Tuesday, March 09, 2004 2:27 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Unix script to check database status
Michael,
Well, I don't have a script to do that, I wrote a Pro*C program that does that & a ton more, in less than a minute per db, normally. Your welcome to that if it would meet your needs. BTW: It e-mails & pages with all kinds of stuff too. Currently it runs on Windows so that it acts like a real client.
Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA
-----Original Message----- From: Michael Milligan [mailto:Michael.Milligan@xxxxxxxxxxx] Sent: Tuesday, March 09, 2004 3:30 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: Unix script to check database status
Hi,
I have to write an HP-UX Korn shell script to check the status of 20 databases - up or down - and send an email if any are down. I'm a relative newbie at Unix. I'm not asking anyone to "do it for me", but does anyone know of any scripts to check database status by greping or otherwise looking at the oratab or other file and checking the status?
Thanks,
Mike
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------