Description:
When managing a complex environment where you are running many different versions
of DBMS software, it is important to keep the DBMS software at supportable,
and reliable fix levels. The DBMS Software Oversight feature of DBAmon
allows you to specify "Know Good" versions of each version family for a product
and DBAmon will inform you of any instances which need to be upgraded.
Be default, the DBMS Software Oversight configuration table is empty, so no
oversight will occur. To configure DBMS Software Oversight, select the
"Configure DBMS Software Oversight Data" option. You will see a screen with
placeholders and the prompts:
- DBMS
- Pulldown this list of available DBMS's.
- Software Version Family
- Specify the Software Version "Family". In otherwords,
Oracle version 8.1.7.4.0 could be considered part of the families: 8, 8.1, 8.1.7 or 8.1.7.4.
- Minimum "Good Version" For This Family
- This is the minimum acceptable revision level for this
family.
For example, if you know that Oracle 8.1.7.4.0 is a "Good" version of Oracle and all 8.1.7 versions
below 8.1.7.4.0 have bugs that will affect you, you would code:
DBMS: Oracle-UX
Software Version Family: 8.1.7
Minimum "Good Version" For This Family: 8.1.7.4
Then, DBAmon will flag any 8.1.7 version with a revision level less than 8.1.7.4 (8.1.7.2.0 for example) in exception status.
When an instance is in exception status, it will receive a USER-Severity (green) DBA652 event.