| DBAmon |
|
|
Home |
Index/DBAmon Doc. |
|
|
| Parameter
| Description
| Example Value
| Default Value
| ORACLE_HOME: xxx
| The same value that you would set this environment variable
to. Note: if you set this to *, then DBAmon will read the ORACLE_HOME
value from your properly formatted /etc/oratab file.
| /opt/oracle/DX7/product/805
| None: This parameter must be specified.
| ORACLE_SID: xxx
| The same value that you would set this environment variable
to.
| DBA5
| None: This parameter must be specified.
| T_NUSERPROC: ww/cc:
| The Warning and Critical percentage thresholds for the current OS process
count vs. the HP-UX maxuprc Kernel value.
| 80/85
| Default_T_NUSERPROC: dbamonrc Value
| T_SGA_Full: ww/cc
| SGA Full Threshold - Format Warning_Threshold_%/Critical_Threshold_%. If N
is specified then SGA monitoring will not occur.
| 90/95
| None: If this parameter is not specified, the defaults will be used (98/99)
| T_TS_Full: pp
| Tablespace Full Threshold - Format Warning_Threshold_%/Critical_Threshold_%
| 90/95
| None: If this parameter is not specified, Tablespace Full Checking will not occur.
| T_TS_Free: nnnn
| (MB) This parm serves as an override to the T_TS_Full
tablespace critical thresholds. A ts will be
critical if it is > T_TS_Full % full -AND- the amount of
freespace is less than T_TS_Free.
| 500
| None.
| T_TS_Command: {Command To Add Datafile}
| This parameter is used to specify a command to execute
when the WARNING or CRITICAL threshold is reached for any
tablespace. In the text of the command that you specify,
the {TS} symbol will be replaced with the tablespace name
and the {SIZE} symbol will be replaced with the amount of
space the needs to be added to get the tablespace down to
the WARNING threshold less 5 additional percent. Here at
xyz we have a tool called ora_ts which is used
to add datafiles. Thus, if we specify this command for this
parameter with the syntax:
| /usr/local/dba/tools/ora_ts {TS} {SIZE}
DBAmon will invoke it (after substitution) as:
/usr/local/dba/tools/ora_ts users 50if it detects that the users tablespace needs 50MB to get to WARNING less 5%. Note: At this time, if the tablespace name contains the word TEMP, then no space will be added. This is to prevent out-of-control use of the TEMP tablespace from causing it to become too large. /usr/local/dba/tools/ora_ts {TS} {SIZE}
| None.
| T_Extents: pp [NOFIX]
| (Percent) A percentage is obtained by dividing the current
number of extents in a TABLE or INDEX by the current MAX_EXTENTS
setting. If that percentage is >= the T_Extents: threshold that
you set here, a USER event will occur. Also, unlesss you have
the word NOFIX as a second postional parameter, DBAmon will
attempt ALTER TABLE|INDEX OWNER.NAME STORAGE ( MAXEXTENTS UNLIMITED ).
| 80 NOFIX
| None. If not specified, then extent checking will not occur for this instance.
| T_Arclog_Full: ww/cc | -or- T_Arclog_Full: N The warning (ww) and critical (cc) thresholds when checking the
filesystem where the archive logs are placed. If you do not want
this check to occur, specify N. The default if this parm is
not coded is 80/90.
| 80/85
| 80/90
| T_Arclog_Command:
|
Note: This parameter only works if you are running our ora_backup
Oracle8/RMAN/Storage-Manager backup process. If specified, when
the Archive Log Full (see above) warning threshold or critical threshold
is reached, the command that you specify
here will instead be run under "at now".
| /usr/local/dba/tools/ora_backup {SID} ARC >> /opt/oracle/adm/cronlog/ora_backup_{SID}_DBAmon.log 2>&1
| None.
| T_Arclog_Full_Dest: {Destination Number} {ww/cc} | -or- T_Arclog_Full_Dest: N The warning (ww) and critical (cc) thresholds when checking the
filesystem where the archive logs are placed for ONE particular
archivelog destination. If you do not want
this check to occur, specify N.
| (None)
| 3 89/90
| T_Arclog_Cmd_Dest: {Destination Number} {Command}
|
If specified, when
the Archive Log Full (see above) warning threshold or critical threshold
is reached, the command that you specify
here will instead be run under "at now".
| /usr/local/dba/tools/ora_backup {SID} ARC >> /opt/oracle/adm/cronlog/ora_backup_{SID}_DBAmon.log 2>&1
| None.
| T_Read_Hit:
| DBAmon samples the DB_BLOCK_BUFFERS read hit ratio. This parameter
specifies the threshold at which events will occur if the observed threshold
falls below this value. To disable buffer hit ratio checking, specify N
here.
| 95
| 50
| T_Read_Hit_Sev:
| By default, DB_BLOCK_BUFFER read hit events have a USER severity.
Use this parameter to override to a different severity. Valid values are
C (Critical), W (Warning), I (Info), U (User).
| C
| U
| Backup_Age: nn [ARC]
|
Note: This parameter only works if you are running a backup
tool which populates the DBAMON.BACKUP_AGE table
on the monitored database.
The maximum tolerable age of the most recent LVL*
database backup, in hours. You can also specify this parameter as N
which informs DBAmon that it is OK to not run backups on this DB. In this
case, the backup type on the Instance Summary will be bkDBCOff.
If you specify the optional ARC 2nd parameter, age checking will only
occur for ARC backups.
| 32
| None. If not specified, then backup age checking will not occur for this instance.
| Backup_Command:
|
This parameter works the Backup_Age: parameter.
If specified, when
a backup age critical event would occur, the command that you specify
here will instead be run under "at now". If the following DBAmon iteration
still finds the backup age exceeded and there is not a backup running, then
a critical event will occur.
| /usr/local/dba/tools/ora_backup {SID} LVL1 >> /opt/oracle/adm/cronlog/ora_backup_{SID}_DBAmon.log 2>&1
| None.
| In_Sync_Pri_Host:
| (Optional)
Note: One of three MANDATORY Standby In-Sync parameters. If you specify one MANDATORY In_Sync* parameter, you must specify all three.
| This is the hostname of the server where the primary DB reside, relative to the standby server. server1.atlanta
| None.
| In_Sync_Pri_SID:
| (Optional)
Note: One of three MANDATORY Standby In-Sync parameters. If you specify one MANDATORY In_Sync* parameter, you must specify all three.
| This is the ORACLE_SID of the primary DB. OLTP
| None.
| In_Sync_Age:
| (Optional)
Note: One of three MANDATORY Standby In-Sync parameters. If you specify one MANDATORY In_Sync* parameter, you must specify all three.
| This is the maximum tolerable delta between the primary and standby DB's, in minutes. 20
| None.
| In_Sync_NL_Sev:
| (Optional)
| This optional parameter specifies the severity of "NOLOGGING Object(s) Found" events. Can be specified as C or W. W
| C
| In_Sync_Unrec_Sev:
| (Optional)
| This optional parameter specifies the severity of "Unrecoverable Changes Found" DBA668 events. Can be specified as C or W. W
| C
| Listener_Check:
| (Optional)
By default, DBAmon checks to see if the Oracle Listener is active.
If for some reason you wish to disable this particular check,
specify N here.
| N
| Y
| Prevent_DB_Restart:
| (Optional)
If you have the Monitor: parameter set to Y, DBAmon will automatically attempt to
restart the Oracle Instance when in crashes. This may not always be desirable. So, if you specify
Prevent_DB_Restart: Y DBAmon WILL NOT attempt to restart a crashed instance.
| N
| Y
| Alert_Log_Check:
| (Optional)
If you specify this parameter as N then DBAmon will perform Oracle Alert Log checking.
By default DBAmon will check the Alert Log for errors.
| N
| Y
| FS_Check_Mask:
| (Optional)
If you specify this parameter then DBAmon will perform Filesystem Capacity checking.
You specify here is mask that is used to match filesystem names as they appear in the 'df -k'
command. For example, if you wish to monitor filesystems /var/opt/oracle/disk001/ABC, /var/opt/oracle/disk001/ABC
then you would specify a FS_Check_Mask: of /var/opt/oracle/disk.../ABC
|
| /var/opt/oracle/disk.../ABC
| FS_Check_Threshold:
| (Optional)
If you have turned on FS_Check_Mask: this parameter specifies the percent full threshold
at which events will occur. If the filesystems that match the FS_Check_Mask: are >= this
percent full, then an event will occur.
|
| 85
| FS_Check_EMail:
| (Optional)
If you have turned on FS_Check_Mask: this parameter specifies the EMail recipient(s)
that will receive notification if the threshold is exceeded. More than one address may
be specified, separated by a space.
|
| bill_smith@a.com june_taylor@b.com
| DF_Offline_Sev:
| (Optional)
Specifies the severity of the Oracle/UX "Offline Datafiles" event.
| W
| C
| T_DFCount_Pct:
| (Optional)
Specifies the percentage threshold for TS datafile count monitoring.
| 90/95
| 70/75
| | |||