1. Cloud Control Basic Installation Guide
  2. Creating a Database Instance with Preconfigured Repository Using Database Templates

C 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.

This appendix describes how you can preconfigure the Management Repository. In particular, this appendix covers the following:

About Preconfiguring the Management Repository in Your Database

While installing Enterprise Manager Cloud Control, you must provide the details of a database where the 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 Management Repository using the database templates offered by Oracle, see Creating a Database Instance with Preconfigured Repository Using Database Templates.

Note:

The various database template zip files provided on the Enterprise Manager 13c Release 4 downloads page can only be used with Enterprise Manager Cloud Control 13c Release 4. Do not use these files for any earlier releases of Enterprise Manager Cloud Control.

Creating a Database Instance with Preconfigured Repository Using Database Templates

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 18c or 19c 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.

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

    https://www.oracle.com/database/technologies/

  2. Go to Enterprise Manager Database Templates Download and download the database template zip file for the specific database version (18c or 19c) and for the platform on which you have installed the Oracle Database. This ZIP file will work only with the specific Oracle Database version that you have installed.
  3. Extract the database template 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 C-1 lists the contents of a typical 18c database template zip file, <Database Version>_Database_Template_for_<EM Version>_<platform>.zip file:

    Table C-1 Contents of a typical 18c database template zip file, <Database Version>_Database_Template_for_<EM Version>_<platform>.zip

    File Name Description

    <Database Version>__Database_Template_for_<EM Version>_Large_deployment.dbc

    The .dbc file for large deployments.

    <Database Version>__Database_Template_for_<EM Version>_Medium_deployment.dbc

    The .dbc file for medium deployments.

    <Database Version>__Database_Template_for_<EM Version>_Small_deployment.dbc

    The .dbc file for small deployments.

    <Database Version>__Database_Template_for_<EM Version>.ctl

    The .ctl file required by the .dbc file.

    <Database Version>__Database_Template_for_<EM Version>.dfb

    The .dbf file required by the .dbc file.

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Large_deployment.sql

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

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Medium_deployment.sql

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

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Small_deployment.sql

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

    shpool_<Database Version>_Database_SQL_for_<EM Version>.sql

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

    Table C-2 lists the contents of a typical 19c database template zip file, <Database Version>_Database_Template_for_<EM Version>_<platform>.zip file:

    Table C-2 Contents of of a typical 19c database template zip file, <Database Version>_Database_Template_for_<EM Version>_<platform>.zip

    File Name Description

    <Database Version>_Database_Template_for_<EM Version>_Large_deployment.dbc

    The .dbc file for large deployments.

    <Database Version>_Database_Template_for_<EM Version>_Medium_deployment.dbc

    The .dbc file for medium deployments.

    <Database Version>_Database_Template_for_<EM Version>_Small_deployment.dbc

    The .dbc file for small deployments.

    <Database Version>_Database_Template_for_<EM Version>.ctl

    The .ctl file required by the .dbc file.

    <Database Version>_Database_Template_for_<EM Version>.dfb

    The .dbf file required by the .dbc file.

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Large_deployment.sql

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

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Medium_deployment.sql

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

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Small_deployment.sql

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

    shpool_<Database Version>_Database_SQL_for_<EM Version>.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. On the Database Templates screen, select the template that matches the deployment size of your choice.

    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. 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.

    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 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.

Creating a Database Instance with Preconfigured Repository Using Database Templates for CDB and PDB

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 18c or 19c 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.

    For Oracle Database 18c:

    1. Install the Oracle Database 18c software available.
    2. Apply the Oracle Database Release Update (RU) 18.6.

      For more information about Oracle Database 18c Release Update, refer to Doc ID 2369376.1 from My Oracle Support.

    3. Apply the Oracle Database 18.6 one-off patch 31145525.

    For Oracle Database 19c:

    1. Install the Oracle Database 19c software available.
    2. Apply the Oracle Database Release Update (RU) 19.5.

      For more information about Oracle Database 19c Release Update, refer to Doc ID 2521164.1 from My Oracle Support.

    3. Apply the Oracle Database 19.5 one-off patch 31145525.

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

    https://www.oracle.com/database/technologies/.

  2. Go to Enterprise Manager Download and download the <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_<platform>.zip file specific to the platform on which you have installed Oracle Database 18c or 19c. This ZIP file will work only with the specific Oracle Database version that you have installed.
  3. Extract the <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_<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 C-3 lists the contents of a typical 18c database template zip file, <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_<platform>.zip file:

    Table C-3 Contents of a typical 18c database template zip file, <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_<platform>.zip

    File Name Description

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_Large_deployment.dbc

    The .dbc file for large deployments.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_Medium_deployment.dbc

    The .dbc file for medium deployments.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_Small_deployment.dbc

    The .dbc file for small deployments.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>.ctl

    The .ctl file required by the .dbc file.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>.dfb1

    The .dbf1 file required by the .dbc file.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>.dfb2

    The .dbf2 file required by the .dbc file.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>.dfb3

    The .dbf3 file required by the .dbc file.

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Large_deployment.sql

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

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Medium_deployment.sql

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

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Small_deployment.sql

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

    shpool_<Database Version>_Database_SQL_for_<EM Version>.sql

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

    Table C-4 lists the contents of a typical 19c database template zip file, <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_<platform>.zip file:

    Table C-4 Contents of a typical 19c database template zip file, <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_<platform>.zip

    File Name Description

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_Large_deployment.dbc

    The .dbc file for large deployments.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_Medium_deployment.dbc

    The .dbc file for medium deployments.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>_Small_deployment.dbc

    The .dbc file for small deployments.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>.ctl

    The .ctl file required by the .dbc file.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>.dfb1

    The .dbf1 file required by the .dbc file.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>.dfb2

    The .dbf2 file required by the .dbc file.

    <Database Version>_Database_Template_with_cdbpdb_for_<EM Version>.dfb3

    The .dbf3 file required by the .dbc file.

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Large_deployment.sql

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

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Medium_deployment.sql

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

    set_repo_param_<Database Version>_Database_SQL_for_<EM Version>_Small_deployment.sql

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

    shpool_<Database Version>_Database_SQL_for_<EM Version>.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. On the Database Templates screen, select the template that matches the deployment size of your choice.

    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. 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.

    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 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:

    The pdb name will always be empdbrepos irrespective of the cdb name, if the pdb is created with the above listed templates. However, if the cdb is created with <domain name> then the pdb will be empdbrepos.<domain name>.

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.