The management packs can be purchased only with Enterprise Edition. The features in these packs are accessible through Oracle Enterprise Manager Database Control, Oracle Enterprise Manager Grid Control, and APIs provided with Oracle Database software.
The pattern obtains the following management packs:
All management packs are enabled by default and require separate license until they are manually disabled.
|OS type||Trigger Node||Attribute||Condition||Argument|
|Unix, Windows||SoftwareInstance||type||=||Oracle Enterprise Manager Management Server|
The pattern executes an SQL Query against the Oracle Database Instance, unless this option has been disabled in the pattern configuration. The pattern uses 'success_login_cred' attribute of related "Oracle Database Server" SI to run DB Query.
Pattern tries to run sql query to system tables "sysman.mgmt_license_view" or "sysman.mgmt_admin_licenses", which could require additional privileges setup for oracle database User.
The following query obtains all enabled management packs.
The result is the list of enabled packs for specific Oracle instance.
For Oracle 11 pattern also tries to run sql query which obtains value of oracle parameter "control_management_pack_access":
An initialization parameter, CONTROL_MANAGEMENT_PACK_ACCESS, controls access to the Diagnostic Pack and Tuning Pack. This parameter can be set to one of three values:
If query method is not succeed for Oracle 11, then pattern tries to read information from the file:"<db_si.ora_home>\\ccr\\state\\<db_instance>.ll"
which contains "state" data which is collected once per day:
Windows:'findstr control_management_pack_access "<db_si.ora_home>\\ccr\\state\\<db_instance>.ll"
Unix:'grep control_management_pack_access "<%db_si.ora_home>/ccr/state/<db_instance>.ll"
Finally, the pattern models a Detail Node for each management pack, and links it to the Oracle RDBMS SI.
The result is an easy-to-read Table, visible directly from the Software Instance.
This pattern has been tested against Oracle Database Server running on multiple platforms (Unix/Linux and Windows) with different configurations
There are no known open issues with this pattern.