C Creating a Database Instance with Preconfigured Repository Using Database Templates

While installing Enterprise Manager, 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 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.

Enterprise Manager 24ai installation using database templates is performed using SYS database user.

Note:

  • The non-SYS database user cannot be used with the database templates when installing Enterprise Manager 24ai.

  • Preconfigured templates can be used only on Enterprise Manager 24ai base installation.

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

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 24ai Release 1 downloads page can only be used with Enterprise Manager 24ai Release 1. Do not use these files for any earlier releases of Enterprise Manager.

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 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. Download the database templates.

    Go to the Oracle Enterprise Manager Downloads page for the current Enterprise Manager version, click DB templates Download URL under the Database Templates for Installing Oracle Enterprise Manager 24ai Release 1 (24.1.0.0.0) section, and download the database template zip file for the specific database version (19c) and 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.

    The zip file name has the following naming convention:

    DB<Database Version>_SIDB_Template_for_<EM Version>_<platform>.zip

    For example, the zip file name for Oracle database version 19.22 for Linux platform is:

    DB19_22_SIDB_Template_for_EM24_1_0_0_0_Linux_x64.zip

  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 19c database template zip file, DB<Database Version>_SIDB_Template_for_<EM Version>_<platform>.zip file:

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

    File Name Description

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

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

    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 Enterprise Manager objects. The only way to overcome this issue is to re-create the database, and then proceed.

    • 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 Installation Wizard when you install Enterprise Manager. Therefore, there is no need to unlock them now while creating the database.

For information about the configuration assistants run by the Enterprise Manager Installation Wizard when a database preconfigured with a Management Repository is used, see Oracle Enterprise Manager 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 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 19c:

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

      For information about Oracle Database 19c RU 22, see My Oracle Support.

    3. Check for all relevant database patches from My Oracle Support.

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

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

  2. Download the database templates.

    Go to the Oracle Enterprise Manager Downloads page for the current Enterprise Manager version, click DB templates Download URL under the Database Templates for Installing Oracle Enterprise Manager 24ai Release 1 (24.1.0.0.0) section, and download the PDB database template zip file DB<Database Version>_CDBPDB_Template_for_<EM Version>_<platform>.zip for the specific platform on which you have installed Oracle Database 19c. This zip file will work only with the specific Oracle Database version that you have installed.

    The zip file name has the following naming convention:

    DB<Database Version>_CDBPDB_Template_for_<EM_Version>_<platform>.zip

    For example, the zip file name for Oracle database version 19.22 for Linux platform is:

    DB19_22_CDBPDB_Template_for_EM24_1_0_0_0_Linux_x64.zip

  3. Extract the DB<Database Version>_CDBPDB_Template_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-2 lists the contents of a typical 19c database template zip file, DB<Database Version>_CDBPDB_Template_for_<EM Version>_<platform>.zip file:

    Table C-2 Contents of a typical 19c database template zip file, DB<Database Version>_CDBPDB_Template_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 Enterprise Manager objects. The only way to overcome this issue is to re-create the database, and then proceed.

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

    • 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 Installation Wizard when you install Enterprise Manager. 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>.

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