From oracle-l-bounce@freelists.org Tue Mar 9 15:56:05 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i29Lu4s32601 for ; Tue, 9 Mar 2004 15:56:04 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i29Ltxo32588 for ; Tue, 9 Mar 2004 15:56:00 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2DB463952F6; Tue, 9 Mar 2004 16:53:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 09 Mar 2004 16:51:44 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from dtagsmtp1.dtg.local (unknown [65.218.31.111]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 3B40D39512B for ; Tue, 9 Mar 2004 16:51:40 -0500 (EST) Received: by dtagimc.dtg.local with Internet Mail Service (5.5.2657.72) id ; Tue, 9 Mar 2004 15:53:00 -0600 Message-ID: From: Stephen.Lee@DTAG.Com To: oracle-l@freelists.org Subject: RE: Unix script to check database status Date: Tue, 9 Mar 2004 15:56:16 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain X-archive-position: 239 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Stephen.Lee@DTAG.Com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l > -----Original Message----- > > 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? On 2/19, I posted a ready-to-run ksh function under the subject of "writing job dependencies shell script" which you are welcome to snag and use. "All" you need to do is build a driver script around it ... which ... in the case of my driver script is approximately 2,000 additional lines. Keep in mind that once you send out a page, you don't want to keep on and keep on and keep on sending out the same page. And it is really nice if the script runs on two boxes and can monitor the copy of the script running on the other box. And it's nice to have a config file where you can say when to monitor this or that instance, and whether it should page or just e-mail about this instance, if you don't want to get paged in the middle the night about some pitiful development database. And the script needs to read its passwords from someplace because you're probably not going to daemon agents running on the remote boxes listening for magic words on certain sockets. And it's nice if the script can read a file to get the addresses to send pages and/or e-mails because people do come and go. And it goes without saying that it should be able to detect syntax errors in its config files and tell you about it so that you can fix it. In other words: Are the requirements for REAL monitoring, or are we talking Sears monitoring? (OK. You would have to be pretty old and a Frank Zappa listener to get that one.) I'm just curious: Did you volunteer for this, or did some bonehead "volunteer" you without understanding why the commercial boys don't generally give this kind of software away for free? > 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. I would love to have a spiffy example of Pro C programming. PLEASE!! > Ite missa est, perl is the best. What's Jar-Jar got to do with this? Missa thinks youssa is wrong. === ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------