D Creating a Database Instance with Preconfigured Repository Using Database Templates

While installing Enterprise Manager Cloud Control, you must provide the details of a database where Oracle Management Repository (Management Repository) can be configured to store all Enterprise Manager-related data. Although the Enterprise Manager Cloud Control Installation Wizard is capable of configuring the Management Repository in the specified database, you can optionally choose to preconfigure the Management Repository in your database beforehand. This saves installation time.

To preconfigure the Management Repository in your database, use the database templates offered by Oracle. These database templates first create a database instance, and then preconfigure the Management Repository in it. The templates preconfigure the Management Repository with database parameters that are required for each deployment size—small, medium, and large.

To create a database instance with a preconfigured Oracle Management Repository using the database templates offered by Oracle, follow these steps:

  1. Install Oracle Database 11g Release 2 (11.2.0.3) software on the host where you want to create the database.

    Oracle recommends a software-only installation, although you can perform a normal, regular database installation and then invoke Database Configuration Assistant to use the template.

    Database Install Wizard - Select Installation Option screen

    For instructions, refer to the Oracle Database Installation Guide available at:

    http://www.oracle.com/technetwork/database/enterprise-edition/documentation/index.html

  2. From the following Oracle Technology Network (OTN) URL, download the 11.2.0.3_Database_Template_for_EM12_1_0_4_<platform>.zip file specific to the platform on which you have installed Oracle Database 11g Release 2 (11.2.0.3). This ZIP file will work only with Oracle Database 11g Release 2 (11.2.0.3).

    http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html

    Caution:

    Make sure that the 11.2.0.3_Database_Template_for_EM12_1_0_4_<platform>.zip file is used only for Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4). Do NOT use it for any earlier release of Enterprise Manager Cloud Control.
  3. Extract the 11.2.0.3_Database_Template_for_EM12_1_0_4_<platform>.zip file to the following location on the database host.

    $<DB_HOME>/assistants/dbca/templates

    For example,

    /u01/software/oracle/database/dbhome_1/assistants/dbca/templates

    Table D-1 lists the contents of the 11.2.0.3_Database_Template_for_EM12_1_0_4_<platform>.zip file:

    Table D-1 Contents of 11.2.0.3_Database_Template_for_EM12_1_0_4_<platform>.zip

    File Name Description

    11.2.0.3_Database_Template_for_EM12_1_0_4_Large_deployment.dbc

    The .dbc file for large deployments.

    11.2.0.3_Database_Template_for_EM12_1_0_4_Medium_deployment.dbc

    The .dbc file for medium deployments.

    11.2.0.3_Database_Template_for_EM12_1_0_4_Small_deployment.dbc

    The .dbc file for small deployments.

    DB11.2.0.3_EM_Seed_database.ctl

    The .ctl file required by the .dbc file .

    DB11.2.0.3_EM_Seed_database.dfb

    The .dbf file required by the .dbc file .

    set_repo_param_11.2.0.3_Database_SQL_for_EM12_1_0_4_Large_deployment.sql

    The .sql file for setting database parameters and converting the Management Repository to support large deployments.

    set_repo_param_11.2.0.3_Database_SQL_for_EM12_1_0_4_Medium_deployment.sql

    The .sql file for setting database parameters and converting the Management Repository to support medium deployments.

    set_repo_param_11.2.0.3_Database_SQL_for_EM12_1_0_4_Small_deployment.sql

    The .sql file for setting database parameters and converting the Management Repository to support small deployments.

    shpool_11.2.0.3_Database_SQL_for_EM12_1_0_4.sql

    The .sql file required by the .dbc file for setting shared pool size as per the requirement.


  4. Create the database by running Oracle Database Configuration Assistant from <DB_HOME>/bin/dbca. As shown in Figure D-1, on the Step 2 of 12: Database Templates screen, select the template that matches the deployment size of your choice.

    Caution:

    Large deployment is not supported on Linux 32-bit operating systems.

    Figure D-1 Creating and Configuring a Database with a Predefined Template

    DBCA - Database Templates Screen

    WARNING:

    When you run Oracle Database Configuration Assistant to create the database, on the Management Options screen, by default the Configure Enterprise Manager (EM) Database Express option is selected. Make sure you DESELECT it.

    DBCA Option Not To Be Selected

    This option creates DB Control objects in the database. If you select this option, then you will not be able to use the database because it will contain both DB Control objects and Cloud Control objects. The only way to overcome this issue is to re-create the database, and then proceed.

    WARNING:

    When you run Oracle Database Configuration Assistant to create the database, on the Database Content screen, by default the Run the following scripts option is selected to run the shpool script. The script sets the shared pool in the database. Make sure you RETAIN THE SELECTION. Do not deselect it.

    Custom Screen for Running shpool Script

    Note:

    While creating the database, if you see any option in the Oracle Database Configuration Assistant to unlock accounts, then ignore that option. Do not unlock any account while creating the database. These accounts will be automatically unlocked and set with a password you enter, by the the Enterprise Manager Cloud Control Installation Wizard when you install Enterprise Manager Cloud Control. Therefore, there is no need to unlock them now while creating the database.

Note:

For information about the configuration assistants run by the Enterprise Manager Cloud Control Installation Wizard when a database preconfigured with a Management Repository is used, see Oracle Enterprise Manager Cloud Control Advanced Installation and Configuration Guide.