Database Template (with EM 13.3.0.0 repository pre-configured) for Installing Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0)

Note: You can use following DB templates only with EM 13.3.0.0 release. Refer to the EM 13.3.0.0 Install guide to learn how to use these DB templates to setup database that will house the EM repository 13.3.0.0 DB templates are only for 12.1.0.2.0 and 18.1.0.0.0 version of DB with config types [ Single Instance and PDB ]

12.1.0.2.0 DB Templates

18.1.0.0.0 DB Templates

Instructions:

The following DB parameters need to set once the DB instance is created using the DB templates using 18.1 PDBs for all platforms.

SMALL:



alter system set parallel_max_servers=8 SCOPE=SPFILE;
alter system set session_cached_cursors=200 SCOPE=SPFILE;
alter system set sga_target=3000000000 SCOPE=SPFILE;
alter system set pga_aggregate_target=1000000000 SCOPE=SPFILE;
alter system set shared_pool_size='600000000';
alter system set "_allow_insert_with_update_check"=TRUE scope=both sid='*';

MEDIUM:



alter system set parallel_max_servers=8 SCOPE=SPFILE;
alter system set session_cached_cursors=200 SCOPE=SPFILE;
alter system set sga_target=5000000000 SCOPE=SPFILE;
alter system set pga_aggregate_target=1340000000 SCOPE=SPFILE;
alter system set shared_pool_size='600000000';
alter system set "_allow_insert_with_update_check"=TRUE scope=both sid='*';

LARGE:



alter system set parallel_max_servers=8 SCOPE=SPFILE;
alter system set session_cached_cursors=200 SCOPE=SPFILE;
alter system set sga_target=8000000000 SCOPE=SPFILE;
alter system set pga_aggregate_target=1600000000 SCOPE=SPFILE;
alter system set shared_pool_size='600000000';
alter system set "_allow_insert_with_update_check"=TRUE scope=both sid='*';