RE: Unix script to check database status

From: Hrncirik, Debbie <DHrncirik_at_lexgen.com>
Date: Wed, 10 Mar 2004 08:01:32 -0600
Message-ID: <0B122847E2315446A3D91D423B845AE2012F57AE@wdexch01.lexgen.com>

I'd like a copy, too please.

-Debbie

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Goulet, Dick Sent: Tuesday, March 09, 2004 3:27 PM
To: oracle-l_at_freelists.org
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_at_ingenix.com] Sent: Tuesday, March 09, 2004 3:30 PM
To: 'oracle-l_at_freelists.org'
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

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

The contents of this communication are intended only for the addressee and may contain confidential and/or privileged material. If you are not the intended recipient, please do not read, copy, use or disclose this communication and notify the sender. Opinions, conclusions and other information in this communication that do not relate to the official business of my company shall be understood as neither given nor endorsed by it.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Mar 10 2004 - 08:05:15 CST