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 be empdbrepos.<domain name>.

Note: