From oracle-l-bounce@freelists.org Thu Mar 24 12:08:31 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2OI8PxG005531 for ; Thu, 24 Mar 2005 12:08:31 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2OI8Pem005527 for ; Thu, 24 Mar 2005 12:08:25 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6DE17889FE; Thu, 24 Mar 2005 12:06:35 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10412-10; Thu, 24 Mar 2005 12:06:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DBFDB88A32; Thu, 24 Mar 2005 12:06:34 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: oracle processes monitoring on linux Date: Thu, 24 Mar 2005 12:04:36 -0500 Message-ID: <59426D03782DBD42AED3E85C3DAFED833C9898@exch01.utsad.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: oracle processes monitoring on linux Thread-Index: AcUwkele837WRraYSkKzT3pIU8sl/AAAMoUAAAAJxhA= From: "Justin Mitchell" To: X-OriginalArrivalTime: 24 Mar 2005 17:04:38.0549 (UTC) FILETIME=[90141C50:01C53093] X-Spam-Processed: taxwise.com, Thu, 24 Mar 2005 12:04:41 -0500 (not processed: message from valid local sender) X-MDRemoteIP: 192.168.2.210 X-Return-Path: jmitchell@taxwise.com X-MDaemon-Deliver-To: oracle-l@freelists.org X-MDAV-Processed: taxwise.com, Thu, 24 Mar 2005 12:04:42 -0500 X-archive-position: 17685 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jmitchell@taxwise.com Precedence: normal Reply-To: jmitchell@taxwise.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: Our own system uses Argent which logs in and checks the results of a function. If it can't get results at all, or it gets anything besides a static string, we raise an alert. The function can check pretty much anything in the database, from job errors or library cache locks. Using this method, we can know how serious it is and where to start fixing it as soon as we have the alert. Returning if the database was online seemed like it was a bit of a waste. Being in a function, you can adjust the settings for what you want to look at and the thresholds easily enough. Thanks, Justin Mitchell -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Hollis, Les Sent: Thursday, March 24, 2005 12:00 PM To: jkstill@gmail.com; oracledbam@hotmail.com Cc: oracle-l@freelists.org Subject: RE: oracle processes monitoring on linux Most pre-canned programs such as Tivoli and BMC Patrol log in to the DB and do a select 'whatever' from dual; expecting a certain result and return a good or bad result set that the program then acts upon..... -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jared Still Sent: Thursday, March 24, 2005 10:52 AM To: oracledbam@hotmail.com Cc: oracle-l@freelists.org Subject: Re: oracle processes monitoring on linux Here's something to consider: Why monitor the Oracle processes? The fact that all the processes are present and accounted for is not a reliable indicator that your database is up and working. If you want to know if your database is up, you will have to logon on to it. Jared On Wed, 23 Mar 2005 15:04:54 -0500, Seema Singh wrote: > Hi, >=3D20 > I want to setup script on linux which check each 15 minutes whether oracle > processes are running or not ? > does any one have any script if yes can please send to me. > thanks in advance >=3D20 > -- > http://www.freelists.org/webpage/oracle-l >=3D20 --=3D20 Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l The information contained in this electronic message from Universal Tax Systems, Inc., and any attachments, contains information that may be confidential and/or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of this information is strictly prohibited. If you have received this communication in error, please notify Universal Tax Systems, Inc., immediately by e-mail or by telephone at 706/290-7200, and destroy this communication. Thank you. -- http://www.freelists.org/webpage/oracle-l