RE: oracle processes monitoring on linux

  • From: "Justin Mitchell" <jmitchell@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 24 Mar 2005 12:04:36 -0500

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.


Justin Mitchell

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hollis, Les
Sent: Thursday, March 24, 2005 12:00 PM
To: jkstill@xxxxxxxxx; oracledbam@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Thursday, March 24, 2005 10:52 AM
To: oracledbam@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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

If you want to know if your database is up, you will have
to logon on to it.


On Wed, 23 Mar 2005 15:04:54 -0500, Seema Singh <oracledbam@xxxxxxxxxxx>
> Hi,
> I want to setup script on linux which check each 15 minutes whether
> processes are running or not ?
> does any one have any script if yes can please send to me.
> thanks in advance
> --

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


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.


Other related posts: