[Xymon] xym-oracle.sh script

[Root, Paul]

Thanks.


Paul Root    - Senior Engineer
Managed Services Systems - CenturyLink



> -----Original Message-----
> From: Benjamin P. August [mailto:baugust at stanford.edu]
> Sent: Thursday, June 21, 2012 12:23 PM
> To: Root, Paul
> Cc: xymon at xymon.com
> Subject: Re: [Xymon] xym-oracle.sh script
>
> My oracle tablespace monitoring query (I stole it from the old bb-
> roracle.sh script) is this:
>
> $SQLPLUS -s $DBUSER/$DBPASS@$ORACLE_SID <<EOF > $TEMPFILE 2>&1
> (sqlplus variables go here)
> select d.tablespace_name "Tablespace Name", round((d.bytes /
> 1048576),1) "Size (M)", round((d.maxbytes / 1048576),0) "Max Size (M)",
> round((d.bytes / d.maxbytes) * 100,0) "% Used", autoextensible
> "AutoExtend ?"
> from dba_data_files d
> where d.tablespace_name NOT LIKE '%ROLLBACK%'
> order by 1;
> exit;
> EOF
>
> Then the logic in the script checks for a NO in the last column and a
> number larger than 96 in the next to last column like so:
>
> if test `grep -c "[97 98 99 100] NO" $TEMPFILE` -gt 0;
> then
>         COLOR=red
>         MSG="There is a full, non-extensible tablespace"
> fi
>
> (I am sure someone is going to come up with a better regex up there :D
> )
>
> ----- Original Message -----
> From: "Paul Root" <Paul.Root at CenturyLink.com>
> To: xymon at xymon.com
> Sent: Thursday, June 21, 2012 10:11:28 AM
> Subject: [Xymon] xym-oracle.sh script
>
> Hi,
>         I'm bringing up the xym-oracle script, version 1 from April 25,
> 2012. And it has one issue. Our dba have table spaces set to
> AUTOEXTEND, and so SYSTEM and SYSAUX were above 94%.   Is there a way
> in the script to see if they are set in AUTOEXTEND.
>
> Thanks,
> Paul.
>
> Paul Root    - Senior Engineer
> Managed Services Systems - CenturyLink
>
>
>
>
> This communication is the property of CenturyLink and may contain
> confidential or privileged information. Unauthorized use of this
> communication is strictly
> prohibited and may be unlawful.  If you have received this
> communication
> in error, please immediately notify the sender by reply e-mail and
> destroy
> all copies of the communication and any attachments.
> _______________________________________________
> Xymon mailing list
> Xymon at xymon.com
> http://lists.xymon.com/mailman/listinfo/xymon

This communication is the property of CenturyLink and may contain confidential or privileged information. Unauthorized use of this communication is strictly
prohibited and may be unlawful.  If you have received this communication
in error, please immediately notify the sender by reply e-mail and destroy
all copies of the communication and any attachments.