14 Change DB Parameters for OEM 12.1.0.4

Overview

During the upgrade to OEM 12.1.0.4 (described in 16 Upgrade OMS 12.1.0.4.0 ), several database changes were recommended.

References

• Oracle® Database Reference 11g Release 2 (11.2)
• 1 Initialization Parameters
• DB_CACHE_SIZE
• PGA_AGGREGATE_TARGET
• Oracle® Database SQL Language Reference 11g Release 2 (11.2)
• ALTER SYSTEM
• GRANT
• Oracle® Database PL/SQL Packages and Types Reference 11g Release 2 (11.2)
• 105 DBMS_RANDOM

Procedure

Review Recommended Changes

The changes recommended are reproduced below:

The change recommended for DB_CACHE_SIZE makes no sense at all for this parameter must be an integer rather than a Boolean.

Change Database Settings

The settings, other than for DB_CACHE_SIZE , were changed as follows:

ALTER SYSTEM set PGA_AGGREGATE_TARGET =1000000000 comment='EM12C Small Installation' scope=both;
GRANT execute on sys. DBMS_RANDOM to dbsnmp;