|DBMS Software Oversight
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:
For example, if you know that Oracle 220.127.116.11.0 is a "Good" version of Oracle and all 8.1.7 versions
below 18.104.22.168.0 have bugs that will affect you, you would code:
- DBMS - Pulldown this list of available DBMS's.
- Software Version Family - Specify the Software Version "Family". In otherwords,
Oracle version 22.214.171.124.0 could be considered part of the families: 8, 8.1, 8.1.7 or 126.96.36.199.
- Minimum "Good Version" For This Family - This is the minimum acceptable revision level for this
Software Version Family: 8.1.7
Minimum "Good Version" For This Family: 188.8.131.52
Then, DBAmon will flag any 8.1.7 version with a revision level less than 184.108.40.206 (220.127.116.11.0 for example) in exception status.
When an instance is in exception status, it will receive a USER-Severity (green) DBA652 event.