Oracle DB to AWS DBCSI Integration
Cloudamize supports exporting data gathered by our Windows Agent (only) from Oracle Databases present on servers monitored by those Agents directly; this export is available only for use as a plugin for the AWS DBCSI tool. If your AWS representative has discussed this with you, this guide will show you how to retrieve the data from Cloudamize. If you have questions about the DBCSI tool, please get in touch with your AWS representative.
You can find the report in the Reports tab in the main results screen once the results are published for your assessment:
Click “Download Report” to retrieve the data; the format is a compressed excel spreadsheet that is compatible with the AWS DBCSI tool.
Pre-requisites needed for the oracle assessment reports to be processed:-
For the Oracle assessment report to be processed, the customer has to enable two packages on machines running Oracle DB: Statspack and Diagnostic Pack. If they don’t enable these packages, we won’t be able to pull in all the data, and the report won’t be processed correctly.
Instructions to Enable StatsPack and Enable/Disable Diagnostic Pack:-
Enable Statistics Package (STATSPACK)
STATSPACK does not require a license.
Run Oracle SQL Developer and access a database and run the following. Select one line and press F9 to run that line.
@%ORACLE_HOME%/rdbms/admin/spcreate.sql; -- This will create the user, PERFSTAT. You need to specify a password for the user.
@%ORACLE_HOME%/rdbms/admin/spauto.sql; -- Automatically create a snapshot every 1 hour for database performance
@%ORACLE_HOME%/rdbms/admin/spdrop.sql; -- drop STATSPACK
Another way to do this is as follows.
“%ORACLE_HOME%\bin\sqlplus.exe” /@serviceName as sysdba @%ORACLE_HOME%/rdbms/admin/spcreate.sql
Enable/Disable Diagnostic Pack
Diagnostic Pack requires a license (i.e., licensed feature).
Run Oracle SQL Developer and access a database and run the following.
ALTER SYSTEM SET CONTROL_MANAGEMENT_PACK_ACCESS = "DIAGNOSTIC"; -- Enable diagnostic pack only
ALTER SYSTEM SET CONTROL_MANAGEMENT_PACK_ACCESS= "DIAGNOSTIC+TUNING" ; -- Enable diagnostic + tuning pack
ALTER SYSTEM SET CONTROL_MANAGEMENT_PACK_ACCESS = "NONE"; -- Disable diagnostic pack. Default value is NONE.
Note that the diagnostic pack includes AWR (Automatic Workload Repository).
show parameter control_management; -- Check the status of Diagnostic pack
show parameter statistics_level; -- Check the statistics level