Start DB Logging button disabled in RSA Identity Governance & Lifecycle

[#1]

Article Number

000040041

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.5.0, 7.2.1, 7.2.0
 

Issue

The "Start DB Logging" button is disabled (missing) in RSA Identity Governance & Lifecycle.

Image description

Cause

The Start DB Logging button is used to Starting database logging. This will take an initial snapshot of database statistics that will be used to generate additional database performance information in the ASR report.

This feature is enabled when an RSA Supplied Local Database is in use.
This feature is currently disabled when an RSA Supplied External Database is in use. 

Resolution

At this time this feature is not available for RSA Supplied External Databases.

Workaround

The Oracle stats pack is installed on RSA Supplied Remote Databases and can be used to get Oracle information.  This should be done by executing SQLPlus as the perfstat user in a command shell on the Remote Database server when logged in as the user oracle.

For example,

acm-750p03:~ # su - oracle
oracle@acm-750p03:~> sqlplus perfstat/secret

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 18 13:35:58 2022
Version 19.7.0.0.0

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

Last Successful login time: Tue Jan 18 2022 12:39:59 -05:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0

SQL>

 

1. Generate an Oracle StatsPack Snapshot on the remote database to use as a reference point for the start of the report.
 

EXEC statspack.snap;

 

2. Conduct the activity on the RSA Identity Governance & Lifecycle server that you wish to capture information for.

3. Generate another Oracle StatsPack Snapshot on the remote database to use as the reference point for the end of the report.
 

EXEC statspack.snap;

 

4. Generate the Oracle StatsPack report. 


 

SQL> @?/rdbms/admin/spreport.sql

Current Instance
~~~~~~~~~~~~~~~~
   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 1838199488 AVDB                1 AVDB
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   DB Id    Inst Num DB Name      Instance     Host
----------- -------- ------------ ------------ ------------
 1838199488        1 AVDB         AVDB         acm-750p03
Using 1838199488 for database Id
Using          1 for instance number

Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing <return> without
specifying a number lists all completed snapshots.

Listing all Completed Snapshots
                                                       Snap
Instance     DB Name        Snap Id   Snap Started    Level Comment
------------ ------------ --------- ----------------- ----- --------------------
AVDB         AVDB                 1 17 Jan 2022 16:58     5
                                  2 17 Jan 2022 16:59     5

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1
Begin Snapshot Id specified: 1

Enter value for end_snap: 2
End   Snapshot Id specified: 2


Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is sp_1_2.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name:

Notes

On Customer Supplied Oracle databases a AWR report can be generated instead.