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

Home -> Community -> Mailing Lists -> Oracle-L -> Best way to monitor ASM disk groups for freespace

Best way to monitor ASM disk groups for freespace

From: Steve Perry <sperry_at_sprynet.com>
Date: Tue, 16 May 2006 21:38:12 -0500
Message-Id: <1294EF15-C00F-4A93-BB90-4A2A447B77F0@sprynet.com>


I ran into a problem a few weeks back where the ASM archive destination filled up.
I wrote a sql script to test the freespace in the disk groups against some thresholds and create a logfile. sqlplus will either exit with "0" - good or "number" numbers of exceptions or alerts. The shell script that calls it will tail the log for the #of lines returned from sqlplus and use "logger" to write a message to /var/log/ messages so our monitoring package will pick them up.

Is anyone else monitoring ASM for freespace? If so, how are you doing it? I heard that OEM will do it, but we aren't using it.

This works for us, but there are a lot of clever people on this list that come up with great solutions.
I was going to have the sql script use dbms_system to write the error to the alert log of the ASM clients, but one is a standby database and isn't open so dbms_system isn't available.

The OS is RH Linux and the db is 10.2 EE.

Thanks,
Steve

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 16 2006 - 21:38:12 CDT

Original text of this message

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