xym-oracle.sh script

3 messages in this thread

list Paul Root · Thu, 21 Jun 2012 12:11:28 -0500 ·

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.

list Benjamin P. August · Thu, 21 Jun 2012 10:22:35 -0700 (PDT) ·

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 )

▸ quoted from Paul Root

----- Original Message -----
From: "Paul Root" <user-76fdb6883669@xymon.invalid>
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.

list Paul Root · Thu, 21 Jun 2012 12:53:48 -0500 ·

Thanks.


Paul Root    - Senior Engineer
Managed Services Systems - CenturyLink

-----Original Message-----
From: Benjamin P. August [mailto:user-e992dd5eb2a5@xymon.invalid]
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:

▸ quoted from Benjamin P. August


$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" <user-76fdb6883669@xymon.invalid>
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.

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.

xym-oracle.sh script 🔗 link

xym-oracle.sh script