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;