- Cloud Control Basic Installation Guide
- 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:
- 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:
- 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. - 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. - 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:
- 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:
- Install the Oracle Database 18c software available.
- 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.
- Apply the Oracle Database 18.6 one-off patch 31145525.
For Oracle Database 19c:
- Install the Oracle Database 19c software available.
- 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.
- Apply the Oracle Database 19.5 one-off patch 31145525.
For instructions, refer to the Oracle Database Installation Guide available at:
- 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. - 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. - 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 beempdbrepos.<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.