- 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.
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 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:
http://www.oracle.com/technetwork/database/enterprise-edition/documentation/index.html
- From the following Oracle Technology Network (OTN) URL, download the
18.1.0.0.0_Database_Template_for_EM13_3_0_0_0_<platform>.zip
file specific to the platform on which you have installed Oracle Database 18c. This ZIP file will work only with Oracle Database 13c Release 3 (13.3.0.0.0).http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html
Caution:
Make sure that the
18.1.0.0.0_Database_Template_for_EM13_3_0_0_0_<platform>.zip
file is used only for Enterprise Manager Cloud Control 13c Release 3. Do NOT use it for any earlier release of Enterprise Manager Cloud Control. - Extract the
18.1.0.0.0_Database_Template_for_EM13_3_0_0_0_<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-1 lists the contents of the
18.1.0.0.0_Database_Template_for_EM13_3_0_0_0_<platform>.zip
file:Table C-1 Contents of 18.1.0.0.0_Database_Template_for_EM13_3_0_0_0_<platform>.zip
File Name Description 18_1_0_0_0__Database_Template_for_EM13_3_0_0_0_Large_deployment.dbc
The
.dbc
file for large deployments.18_1_0_0_0__Database_Template_for_EM13_3_0_0_0_Medium_deployment.dbc
The
.dbc
file for medium deployments.18_1_0_0_0__Database_Template_for_EM13_3_0_0_0_Small_deployment.dbc
The
.dbc
file for small deployments.18_1_0_0_0__Database_Template_for_EM13_3_0_0_0.ctl
The
.ctl
file required by the.dbc
file.18_1_0_0_0__Database_Template_for_EM13_3_0_0_0.dfb
The
.dbf
file required by the.dbc
file.set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Large_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support large deployments.set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Medium_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support medium deployments.set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Small_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support small deployments.shpool_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0.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 the
12.1.0.2.0_Database_Template_for_EM13_3_0_0_0_<platform>.zip
file:Table C-2 Contents of 12.1.0.2.0_Database_Template_for_EM13_3_0_0_0_<platform>.zip
File Name Description 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Large_deployment.dbc
The
.dbc
file for large deployments.12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Medium_deployment.dbc
The
.dbc
file for medium deployments.12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Small_deployment.dbc
The
.dbc
file for small deployments.12.1.0.2.0_Database_Template_for_EM13_2_0_0_0.ctl
The
.ctl
file required by the.dbc
file.12.1.0.2.0_Database_Template_for_EM13_2_0_0_0.dfb
The
.dbf
file required by the.dbc
file.set_repo_param_12.1.0.2.0_Database_SQL_for_EM13_2_0_0_0_Large_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support large deployments.set_repo_param_12.1.0.2.0_Database_SQL_for_EM13_2_0_0_0_Medium_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support medium deployments.set_repo_param_12.1.0.2.0_Database_SQL_for_EM13_3_0_0_0_Small_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support small deployments.shpool_12.1.0.2.0_Database_SQL_for_EM13_3_0_0_0.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 12c Release 1 (12.1.0.2.0) 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:
http://www.oracle.com/technetwork/database/enterprise-edition/documentation/index.html
- From the following Oracle Technology Network (OTN) URL, download the
12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_<platform>.zip
file specific to the platform on which you have installed Oracle Database 12c Release 1 (12.1.0.2.0). This ZIP file will work only with Oracle Database 12c Release 1 (12.1.0.2.0).http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html
Caution:
Make sure that the
12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_<platform>.zip
file is used only for Enterprise Manager Cloud Control 13c Release 3. Do NOT use it for any earlier release of Enterprise Manager Cloud Control. - Extract the
12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_<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
18.1.0.0.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_<platform>.zip
file:Table C-3 Contents of 18.1.0.0.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_<platform>.zip
File Name Description 18_1_0_0_0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_Large_deployment.dbc
The
.dbc
file for large deployments.18_1_0_0_0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_Medium_deployment.dbc
The
.dbc
file for medium deployments.18_1_0_0_0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_Small_deployment.dbc
The
.dbc
file for small deployments.18_1_0_0_0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0.ctl
The
.ctl
file required by the.dbc
file.18_1_0_0_0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0.dfb1
The
.dbf1
file required by the.dbc
file.18_1_0_0_0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0.dfb2
The
.dbf2
file required by the.dbc
file.18_1_0_0_0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0.dfb3
The
.dbf3
file required by the.dbc
file.set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Large_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support large deployments.set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Medium_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support medium deployments.set_repo_param_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0_Small_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support small deployments.shpool_18_1_0_0_0_Database_SQL_for_EM13_3_0_0_0.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 the
12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_<platform>.zip
file:Table C-4 Contents of 12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_<platform>.zip
File Name Description 12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_Large_deployment.dbc
The
.dbc
file for large deployments.12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_Medium_deployment.dbc
The
.dbc
file for medium deployments.12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0_Small_deployment.dbc
The
.dbc
file for small deployments.12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0.ctl
The
.ctl
file required by the.dbc
file.12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0.dfb1
The
.dbf1
file required by the.dbc
file.12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0.dfb2
The
.dbf2
file required by the.dbc
file.12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_3_0_0_0.dfb3
The
.dbf3
file required by the.dbc
file.set_repo_param_12.1.0.2.0_Database_SQL_for_EM13_3_0_0_0_Large_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support large deployments.set_repo_param_12.1.0.2.0_Database_SQL_for_EM13_3_0_0_0_Medium_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support medium deployments.set_repo_param_12.1.0.2.0_Database_SQL_for_EM13_3_0_0_0_Small_deployment.sql
The
.sql
file for setting database parameters and converting the Management Repository to support small deployments.shpool_12.1.0.2.0_Database_SQL_for_EM13_3_0_0_0.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.