Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: oracle processes monitoring on linux

RE: oracle processes monitoring on linux

From: Justin Mitchell <jmitchell_at_taxwise.com>
Date: Thu, 24 Mar 2005 12:04:36 -0500
Message-ID: <59426D03782DBD42AED3E85C3DAFED833C9898@exch01.utsad.com>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hollis, Les Sent: Thursday, March 24, 2005 12:00 PM
To: jkstill_at_gmail.com; oracledbam_at_hotmail.com Cc: oracle-l_at_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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Thursday, March 24, 2005 10:52 AM
To: oracledbam_at_hotmail.com
Cc: oracle-l_at_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 <oracledbam_at_hotmail.com> 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
Received on Thu Mar 24 2005 - 12:08:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US