Something is missing?
If you find the information provided here is missing some context or confusing please comment on what You would like to have a more detailed explanation provided for.
Oracle Database Installed and Enabled Options via Query
The pattern executes an SQL Query against the Database, which returns a list of all Options and their Installed/Uninstalled status.
If the SQL query is successful, the pattern compares the results against a user configured list of installed options to search for.
The installed options searched for by default are:
Oracle Database In-Memory
Finally, the pattern models a Detail Node for each installed options, and links it to the Oracle RDBMS SI.
The result is an easy-to-read Table, visible directly from the Software Instance.
For Oracle Advanced Analytics a check is performed to confirm the presence of Oracle R installed on the host and Oracle Data Mining, if either of them is not found the detail is not created.
If the above SQL Query fails or is unable to be executed for any reason, the pattern attempts to get the installed options from the comps.xml file
The pattern models a Detail Node for each installed options, and links it to the Oracle RDBMS SI.
Query results for non-pluggable databases may be processed incorrectly in some cases. Fix is included in TKU October 2018.
Data Masking pack enabled via Oracle EM may not be found on the host(present as a detail on Oracle EM SI).