Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: oracle processes monitoring on linux
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
--=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-lReceived on Thu Mar 24 2005 - 12:08:31 CST