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.
Thanks,
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
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@xxxxxxxxxxx>
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
> --
> //www.freelists.org/webpage/oracle-l
>=3D20
--=3D20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
