DBMS Patch Registration / Reporting
Description
DBAmon is capable of tracking which patches have been applied to your DBMS
software. This document describes how to configure this feature. Note that
each DBMS has its own procedure.
DBMS: Oracle on UX or Linux:
For Oracle on Unix or Linux, DBAmon reads the file
- $ORACLE_HOME/patch/applied.txt
to determine which patches are installed.
If this file did not previously exist in ORACLE_HOME, DBAmon will
automatically create it as a TEMPLATE which only contains comments on the correct
syntax for this file.
Note: YOU MUST POPULATE THIS FILE YOURSELF AFTER APPLYING ORACLE PATCHES.
Older versions of Oracle (pre-9i) do not record any information that can be retrieved later when
applying patches, so this must be done manually. In future versions of Oracle and DBAmon, this
data will be automatically collected.
A few tidbits:
- If you don't enter the correct data into the $ORACLE_HOME/patch/applied.txt file, then no data will be collected or reported.
- The format of the applied.txt file is COLUMN SENSITIVE. Be careful to align your entries to the template in the file.
- On the instance summary WWW page, the number of patches that have been applied (as per the applied.txt file) will be
reported as (+ 1P) (which mean plus one patch.) If you click on that URL, you will see the details of the patches.
- Do not manually create a new $ORACLE_HOME/patch/applied.txt file>. DBAmon is supposed to automatically create
it as an empty file. If this did not occur, contact DBAmon support.
