Licensing for Oracle Automatic Workload Repository (AWR) with RSA Identity Governance & Lifecycle

[#1]

Article Number

000037217

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.x
 

Issue

RSA Identity Governance & Lifecycle Support will often request an AWR report from customers to assist with troubleshooting product issues, when customer-supplied database is being used and the customer has the appropriate licensing to generate AWR. The right to use AWR is part of the Oracle Diagnostics Pack. Customers should contact their DBA team to find out whether they are licensed to run AWR reports.

If a customer has the appropriate Oracle licensing to generate AWR reports for their customer-supplied database, the Diagnostics feature must be enabled in the Oracle database to be able to generate an AWR report. This can be verified by running the following SQL statement:
 

oracle@acm-710:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Feb 26 14:02:44 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show parameter CONTROL_MANAGEMENT_PACK_ACCESS;

NAME                                   TYPE                       VALUE
------------------------------------   -------------              ------------------- 

control_management_pack_access          string                     DIAGNOSTIC
SQL>

Resolution

Seeing the value of DIAGNOSTIC in the above SQL query indicates that the Oracle Diagnostics Pack is enabled (subject to the customer having the required Oracle license) to run AWR reports in a customer-supplied database scenario.

RSA Identity Governance & Lifecycle provides the ability to generate a database performance statistics report, an alternative to AWR, for troubleshooting database performance issues.

Customers using an RSA-provided database for RSA Identity Governance & Lifecycle must generate a database performance statistics report for troubleshooting database performance issues. RSA Identity Governance & Lifecycle versions 7.1.1 P11, 7.2.0 P07, 7.2.1 P02, and all older versions, may have the Oracle parameter 'control_management_pack_access' set to DIAGNOSTIC. This Oracle parameter will be reset to NONE for RSA-provided database, effective 7.1.1 P12, 7.2.0 P08, 7.2.1 P03, and in future versions of RSA Identity Governance & Lifecycle.

For more information about generating the database performance statistics report, see the following: How to generate Oracle database performance statistics in RSA Identity Governance & Lifecycle