This chapter explains how you can create databases using Oracle Enterprise Manager Cloud Control (Cloud Control). In particular, this chapter covers the following:
Note:
This chapter also provides information about creating single-instance, Oracle Real Application Clusters (Oracle RAC), and Oracle Real Application Clusters One Node (Oracle RAC One Node) container databases.You can create a container database on a host only if Oracle Database 12c Release 1 (12.1), or higher, is installed on the host. For more information on container databases, view Oracle Database Administrator's Guide.
This section helps you get started with this chapter by providing an overview of the steps involved in creating databases. Consider this section to be a documentation map to understand the sequence of actions you must perform to successfully create a database using Cloud Control. Click the reference links provided against the steps to reach the relevant sections that provide more information.
Table 16-1 Getting Started with Creating Oracle Databases
| Step | Description | Reference Links |
|---|---|---|
|
Step 1 |
Selecting the Use Case This chapter covers a few use cases for creating databases. Select the use case that best matches your requirements. |
|
|
Step 2 |
Meeting the Prerequisites Before you run any Deployment Procedure, you must meet the prerequisites, such as setting up of the provisioning environment, applying mandatory patches, and setting up of Oracle Software Library. |
|
|
Step 3 |
Running the Deployment Procedure Run the Deployment Procedure to successfully create the database. |
|
This section provides information about creating an Oracle Database (also called single-instance database).
Important:
You can also use the information provided in this section to create a single-instance container database.You can create a container database on a host only if Oracle Database 12c Release 1 (12.1), or higher, is installed on the host. For more information on container databases, view Oracle Database Administrator's Guide.
This section covers the following:
To create single-instance databases using Cloud Control, ensure that you meet the following prerequisites:
Ensure that you meet the infrastructure requirements explained in Chapter 2.
Ensure that you have created and stored a database template in the Software Library or Oracle Home. For information about creating database templates, see Section 4.3.8.
Oracle Home for the database you want to create must be installed and you need to have credentials of the owner of the Oracle Home. If the Create Database wizard is launched from the Provision Database deployment procedure wizards, the Oracle Home need not be installed earlier. In such cases, the validations for Oracle Home will be skipped during the procedure interview and will be performed during execution of the deployment procedure.
The database plug-in that supports the corresponding database version should be deployed on OMS and Agent. For information about deploying plug-ins, see Oracle Enterprise Manager Cloud Control Administrator's Guide.
Ensure that you have sufficient space to create the database, and that you have write permissions to the recovery file location.
If you are using a template from the Software Library for database creation, you must have Write permission to the Staging Location.
If you are using Automatic Storage Management (ASM) as storage, ASM instances and diskgroups must be configured prior to creating database.
The Cloud Control user creating the database template must have CONNECT_ANY_TARGET privilege in Cloud Control.
To create an Oracle database, follow these steps:
From the Enterprise menu, select Provisioning and Patching, then select Database Provisioning.
In the Database Provisioning page, select the Create Oracle Database Deployment Procedure and click Launch. The Create Oracle Database wizard is launched.
In the Database Version and Type page, select the database Version and select Oracle Single Instance Database.
In the Hosts section, specify hosts and Oracle Home to provision the database. You can also specify Host Credentials and Common Oracle Home across all hosts. The Host Credentials can be Named or Preferred Credentials.
Click the plus (+) icon to add the host. Select the host and specify Oracle Home. Select Host Credentials or add new. Click the plus icon to add new credentials and specify User Name, Password, and Run Privileges and save the credentials.
Click Next.
In the Database Template page, choose the database template location. The location can be Software Library or Oracle Home. The template selected must be compatible with the selected Oracle Home version.
If you have selected Software Library, click on the search icon and select the template from the Software Library. Specify Temporary Storage Location on Managed Host(s). This location must exist on all hosts where you want to create the database.
Click Show Template Details to view details of the selected template. You can view initialization parameters, table spaces, data files, redo log groups, common options, and other details of the template.
If you have selected Oracle Home, select the template from the Oracle Home. The default location is ORACLE_HOME/assistants/dbca/templates.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Identification and Placement page, specify database configuration details. Specify Global Database Name and SID prefix.
In the Database Consolidation section, select Create As Container Database if you want to create a container database. By default, an empty container database is created. If you want to add one or more pluggable databases to that container database, then select Create a Container Database with one or more PDBs, and set the number of PDBs.
If you choose to create multiple PDBs, then the unique name you enter here is used as a prefix for all the cloned PDBs, and the suffix is a numeric value that indicates the count of PDBs.
For example, if you create five PDBs with the name accountsPDB, then the PDBs are created with the names accountsPDB1, accountsPDB2, accountsPDB3, accountsPDB4, and accountsPDB5.
Specify the Database Credentials for SYS, SYSTEM, and DBSNMP database accounts.
For database version 12.1 or higher, for Microsoft Windows operating systems, the database services will be configured for the Microsoft Windows user specified during Oracle home installation.This user will own all services run by Oracle software. In the Oracle Home Windows User Credentials section, specify the host credentials for the Microsoft Windows user account to configure database services. Select existing named credentials or specify new credentials. To specify new credentials, provide the user name and password. You can also save these credentials and set them as preferred credentials.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
Note:
SID must be unique for a database on a host. This means, the SID assigned to one database on a host cannot be reused on another database on the same host, but can be reused on another database on a different host. For example, if you have two databases (db1 and db2) on a host (host1), then their SIDs need to be unique. However, if you install the third database on another host (host2), then its SID can be db1 or db2.
Global database name must be unique for a database on a host and also unique for databases across different hosts. This means, the global database name assigned to one database on a host can neither be reused on another database on the same host nor on another database on a different host. For example, if you have two databases (db1 and db2) on a host (host1), then their global database names need to be unique. And if you install the third database on another host (host2), the global database name of even this database must be unique and different from all other names registered with Cloud Control.
The database credentials you specify here will be used on all the destination hosts. However, after provisioning, if you want to change the password for any database, then you must change it manually.
In the Storage Locations page, select the storage type, whether File System or Automatic Storage Management (ASM).
If you want to use a file system, then select File System and specify the full path to the location where the data file is present. For example, %ORACLE_BASE%/oradata or /u01/product/db/oradata.
If you want to use ASM, then select Automatic Storage Management (ASM), and click the torch icon to select the disk group name and specify ASMSNMP password. The Disk Group Name List window appears and displays the disk groups that are common on all the destination hosts.
In the Database Files Location section, specify the location where data files, temporary files, redo logs, and control files will be stored.
Select Use Database File Locations from Template to select defaults from the template used.
Select Use Common Location for All Database Files to specify a different location.
If you select Use Oracle Managed Files (OMF), in the Multiplex Redo Logs and Control Files section, you can specify locations to store duplicate copies of redo logs and control files. Multiplexing provides greater fault-tolerance. You can specify upto five locations.
In the Recovery Files Location section, select Use same storage type as database files location to use the same storage type for recovery files as database files. Select Use Flash Recovery Area and specify the location for recovery-related files and Fast Recovery Area Size.
Select Enable Archiving to enable archive logging. Click Specify Archive Log Locations and specify upto nine archive log locations. If the log location is not specified, the logs will be saved in the default location.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Initialization Parameters page, select the memory management type as Automatic Memory Management or Automatic Shared Memory Management. Select Specify Memory Settings as Percentage of Available Memory to specify memory settings as percentage of available physical memory. For Automatic Shared Memory management, specify Total SGA and Total PGA. For Automatic Memory Management, specify Total Memory for Oracle.
In the Database sizing section, specify the Block Size and number of Processes. If you have selected a database template with datafiles in the Database Template page, you cannot edit the Block Size.
Specify the Host CPU Count. The maximum CPU count that can be specified is equal to the number of CPUs present on the host.
In the Character Sets section, select the default character set. The default character set is based on the locale and operating system.
Select a national character set. The default is AL16UTF16.
In the Database Connection Mode section, select the dedicated server mode. For shared server mode, specify the number of shared servers.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Additional Configuration Options, all the available listeners running from the Oracle Home and Grid Infrastructure listeners are listed. You can either select a listener or create a new one. You can select multiple listeners to register with the database. To create a new listener, specify the Listener Name and Port. Select database schemas and specify custom scripts, if any. Select custom scripts from the host where you are creating the database or from Software Library. If you have selected multiple hosts, you can specify scripts only from Software Library.
If you have selected a Structure Only database template in the Database Template page, you can also view and edit database options.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Schedule page, specify a Deployment Instance name and a schedule for the deployment. If you want to run the procedure immediately, then retain the default selection, that is Immediately. If you want to run the procedure later, then select Later and provide time zone, start date, and start time details. Click Next.
In the Review page, review the details you have provided for the deployment procedure and if you are satisfied with the details, then click Finish to run the deployment procedure according to the schedule set. If you want to modify the details, then click Back repeatedly to reach the page where you want to make the changes. Click Save to save the deployment procedure for future deployment. Click Analyze to check for prerequisites and to ensure that all the necessary requirements for provisioning are met.
In the Procedure Activity page, view the status of the execution of the job and steps in the deployment procedure. Click the Status link for each step to view the details of the execution of each step. You can click Debug to set the logging level to Debug and click Stop to stop the procedure execution.
This section provides information about creating Oracle Real Application Clusters Database.
Important:
You can also use the information provided in this section to create a Oracle Real Application Clusters container database.You can create a container database on a host only if Oracle Database 12c Release 1 (12.1), or higher, is installed on the host. For more information on container databases, view Oracle Database Administrator's Guide.
This section covers the following:
Prerequisites for Creating an Oracle Real Application Clusters Database
Procedure for Creating an Oracle Real Application Clusters Database
To create an Oracle RAC databases using Cloud Control, ensure that you meet the following prerequisites:
Ensure that you meet the mandatory infrastructure requirements explained in Chapter 2.
Ensure that you have created and stored the database template in the Software Library or Oracle Home. For information about creating database templates, see Section 4.3.8.
Oracle Home for the database you want to create must be installed and you need to have credentials of the owner of the Oracle Home. If the Create Database wizard is launched from the Provision Database deployment procedure wizards, the Oracle Home need not be installed earlier. In such cases, the validations for Oracle Home will be skipped during the procedure interview and will be performed during execution of the deployment procedure.
The database plug-in that supports the corresponding database version should be deployed on OMS and Agent. For information about deploying plug-ins, see Oracle Enterprise Manager Cloud Control Administrator's Guide.
Ensure that you have sufficient space to create the database, and that you have write permissions to the recovery file location.
If you are using a template from the Software Library for database creation, you must have Write permission to the Staging Location.
If you are creating Oracle Real Application Clusters database, you must have Grid Infrastructure installed and configured. If the Create Database wizard is launched from the Provision Database deployment procedure wizards, Grid Infrastructure need not be installed and configured. In such cases, the validations for Grid Infrastructure will be skipped during the procedure interview and will be performed during execution of the deployment procedure.
If you are using Automatic Storage Management (ASM) as storage, ASM instances and diskgroups must be configured prior to creating database.
The Cloud Control user creating the database template must have CONNECT_ANY_TARGET privilege in Cloud Control.
To create an Oracle Real Application Clusters (Oracle RAC) database, follow these steps:
From the Enterprise menu, select Provisioning and Patching, then select Database Provisioning.
In the Database Provisioning page, select the Create Oracle Database Deployment Procedure and click Launch. The Create Oracle Database wizard is launched.
In the Database Version and Type page, select the database Version and select Oracle Real Application Clusters (Oracle RAC) Database.
In the Cluster section, select the Cluster and Oracle Home. Select a reference host to perform validations to use as reference to create database on the cluster.
Select Cluster Credentials or add new. Click the plus icon to add new credentials and specify User Name, Password, and Run Privileges and save the credentials.
Click Next.
In the Database Template page, choose the database template location. The location can be Software Library or Oracle Home. The template selected must be compatible with the selected Oracle Home version.
If you have selected Software Library, click on the search icon and select the template from the Software Library. Specify Temporary Storage Location on Managed Host(s). This location must be present on the reference node that you selected earlier.
Click Show Template Details to view details of the selected template. You can view initialization parameters, table spaces, data files, redo log groups, common options, and other details of the template.
If you have selected Oracle Home, select the template from the Oracle Home. The default location is ORACLE_HOME/assistants/dbca/templates.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Identification and Placement page, select the type of Oracle RAC database, whether Policy Managed or Admin Managed. Also, specify Global Database Name and SID prefix.
For admin-managed database, select nodes on which you want to create the cluster database. You must specify the node selected as the reference node in the Database Version and Type page.
For policy-managed database, select the server pools to be used for creating the database, from the list of existing server pools, or choose to create a new server pool. Policy-managed databases can be created for database versions 11.2 and higher. For database versions lower than 11.2, you will need to select nodes to create the Oracle RAC database.
In the Database Consolidation section, select Create As Container Database if you want to create a container database. By default, an empty container database is created. If you want to add one or more pluggable databases to that container database, then select Create a Container Database with one or more PDBs, and set the number of PDBs.
If you choose to create multiple PDBs, then the unique name you enter here is used as a prefix for all the cloned PDBs, and the suffix is a numeric value that indicates the count of PDBs.
For example, if you create five PDBs with the name accountsPDB, then the PDBs are created with the names accountsPDB1, accountsPDB2, accountsPDB3, accountsPDB4, and accountsPDB5.
Specify the Database Credentials for SYS, SYSTEM, and DBSNMP.
For database version 12.1 or higher, for Microsoft Windows operating systems, the database services will be configured for the Microsoft Windows user specified during Oracle home installation.This user will own all services run by Oracle software. In the Oracle Home Windows User Credentials section, specify the host credentials for the Microsoft Windows user account to configure database services. Select existing named credentials or specify new credentials. To specify new credentials, provide the user name and password. You can also save these credentials and set them as preferred credentials.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Storage Locations page, select the storage type, whether File System or Automatic Storage Management (ASM).
In the Database Files Location section, specify the location where data files, temporary files, redo logs, and control files will be stored. These locations must be on shared storage such as cluster file system location or ASM diskgroups.
Select Use Database File Locations from Template to select defaults from the template used.
Select Use Common Location for All Database Files to specify a different location.
If you select Use Oracle Managed Files (OMF), in the Multiplex Redo Logs and Control Files section, you can specify locations to store duplicate copies of redo logs and control files. Multiplexing provides greater fault-tolerance. You can specify upto five locations.
In the Recovery Files Location section, select Use Flash Recovery Area and specify the location for recovery-related files and Fast Recovery Area Size.
In the Archive Log Settings section, select Enable Archiving to enable archive logging. In the Specify Archive Log Locations, you can specify up to nine archive log locations. If the log location is not specified, the logs will be saved in the default location.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Initialization Parameters page, select the memory management type as Automatic Memory Management or Automatic Shared Memory Management. Select Specify Memory Settings as Percentage of Available Memory to specify memory settings as percentage of available physical memory. For Automatic Shared Memory management, specify Total SGA and Total PGA. For Automatic Memory Management, specify Total Memory for Oracle.
In the Database sizing section, specify the Block Size and number of Processes. If you have selected a database template with datafiles in the Database Template page, you cannot edit the Block Size.
Specify the Host CPU Count. The maximum CPU count that can be specified is equal to the number of CPUs present on the host.
In the Character Sets section, select the default character set. The default character set is based on the locale and operating system.
Select a national character set. The default is AL16UTF16.
In the Database Connection Mode section, select the dedicated server mode. For shared server mode, specify the number of shared servers.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Additional Configuration Options page, select custom scripts from the Software Library. If you have selected a Structure Only database template in the Database Template page, you can also view and edit database options.
Click on the Lock icon to lock the field. Click Next.
In the Schedule page, specify a Deployment Instance name and a schedule for the deployment. If you want to run the procedure immediately, then retain the default selection, that is Immediately. If you want to run the procedure later, then select Later and provide time zone, start date, and start time details. Click Next.
In the Review page, review the details you have provided for the deployment procedure and if you are satisfied with the details, then click Finish to run the deployment procedure according to the schedule set. If you want to modify the details, then click Back repeatedly to reach the page where you want to make the changes. Click Save to save the deployment procedure for future deployment. Click Analyze to check for prerequisites and to ensure that all the necessary requirements for provisioning are met.
In the Procedure Activity page, view the status of the execution of the job and steps in the deployment procedure. Click the Status link for each step to view the details of the execution of each step. You can click Debug to set the logging level to Debug and click Stop to stop the procedure execution.
This section provides information about creating Oracle Real Application Clusters One Node Database (also called as Oracle RAC One Node Database).
Important:
You can also use the information provided in this section to create a Oracle Real Application Clusters One Node container database.You can create a container database on a host only if Oracle Database 12c Release 1 (12.1), or higher, is installed on the host. For more information on container databases, view Oracle Database Administrator's Guide.
This section covers the following:
To create an Oracle RAC One databases using Cloud Control, ensure that you meet the following prerequisites:
Ensure that you meet the infrastructure requirements explained in Chapter 2.
Ensure that you have created and stored the database template in the Software Library or Oracle Home. For information about creating database templates, see Section 4.3.8.
Oracle Home for the database you want to create must be installed and you need to have credentials of the owner of the Oracle Home. If the Create Database wizard is launched from the Provision Database deployment procedure wizards, the Oracle Home need not be installed earlier. In such cases, the validations for Oracle Home will be skipped during the procedure interview and will be performed during execution of the deployment procedure.
The database plug-in that supports the corresponding database version should be deployed on OMS and Agent. For information about deploying plug-ins, see Oracle Enterprise Manager Cloud Control Administrator's Guide.
Ensure that you have sufficient space to create the database, and that you have write permissions to the recovery file location.
If you are using a template from the Software Library for database creation, you must have Write permission to the Staging Location.
If you are creating Oracle Real Application Clusters database, you must have Grid Infrastructure installed and configured. If the Create Database wizard is launched from the Provision Database deployment procedure wizards, Grid Infrastructure need not be installed and configured. In such cases, the validations for Grid Infrastructure will be skipped during the procedure interview and will be performed during execution of the deployment procedure.
If you are using Automatic Storage Management (ASM) as storage, ASM instances and diskgroups must be configured prior to creating database.
The Cloud Control user creating the database template must have CONNECT_ANY_TARGET privilege in Cloud Control.
To create an Oracle Real Application Clusters One Node database, follow these steps:
From the Enterprise menu, select Provisioning and Patching, then select Database Provisioning.
In the Database Provisioning page, select the Create Oracle Database Deployment Procedure and click Launch. The Create Oracle Database wizard is launched.
In the Database Version and Type page, select the database Version and select Oracle RAC One Node Database.
In the Cluster section, select the cluster and Oracle Home. Select a reference host to perform validations to use as reference to create database on the cluster.
Select Cluster Credentials or add new. Click the plus icon to add new credentials and specify User Name, Password, and Run Privileges and save the credentials.
Click Next.
In the Database Template page, choose the database template location. The location can be Software Library or Oracle Home. The template selected must be compatible with the selected Oracle Home version.
If you have selected Software Library, click on the search icon and select the template from the Software Library. Specify Temporary Storage Location on Managed Host(s). This location must be present on the reference node that you selected earlier.
Click Show Template Details to view details of the selected template. You can view initialization parameters, table spaces, data files, redo log groups, common options, and other details of the template.
If you have selected Oracle Home, select the template from the Oracle Home. The default location is ORACLE_HOME/assistants/dbca/templates.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Identification and Placement page, select nodes on which you want to create the cluster database. Specify Global Database Name and SID prefix. Select the type of Oracle RAC database, whether Policy Managed or Admin Managed. Specify the Service Name.
In the Database Consolidation section, select Create As Container Database if you want to create a container database. By default, an empty container database is created. If you want to add one or more pluggable databases to that container database, then select Create a Container Database with one or more PDBs, and set the number of PDBs.
If you choose to create multiple PDBs, then the unique name you enter here is used as a prefix for all the cloned PDBs, and the suffix is a numeric value that indicates the count of PDBs.
For example, if you create five PDBs with the name accountsPDB, then the PDBs are created with the names accountsPDB1, accountsPDB2, accountsPDB3, accountsPDB4, and accountsPDB5.
Specify the Database Credentials for SYS, SYSTEM, and DBSNMP database accounts.
For database version 12.1 or higher, for Microsoft Windows operating systems, the database services will be configured for the Microsoft Windows user specified during Oracle home installation.This user will own all services run by Oracle software. In the Oracle Home Windows User Credentials section, specify the host credentials for the Microsoft Windows user account to configure database services. Select existing named credentials or specify new credentials. To specify new credentials, provide the user name and password. You can also save these credentials and set them as preferred credentials.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Storage Locations page, select the storage type, whether File System or Automatic Storage Management (ASM).
In the Database Files Location section, specify the location where data files, temporary files, redo logs, and control files will be stored.
Select Use Database File Locations from Template to select defaults from the template used.
Select Use Common Location for All Database Files to specify a different location.
If you select Use Oracle Managed Files (OMF), in the Multiplex Redo Logs and Control Files section, you can specify locations to store duplicate copies of redo logs and control files. Multiplexing provides greater fault-tolerance. You can specify upto five locations.
In the Recovery Files Location section, select Use Flash Recovery Area and specify the location for recovery-related files and Fast Recovery Area Size.
In the Archive Log Settings section, select Enable Archiving to enable archive logging. In the Specify Archive Log Locations, you can specify up to nine archive log locations. If the log location is not specified, the logs will be saved in the default location.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Initialization Parameters page, select the memory management type as Automatic Memory Management or Automatic Shared Memory Management. Select Specify Memory Settings as Percentage of Available Memory to specify memory settings as percentage of available physical memory. For Automatic Shared Memory management, specify Total SGA and Total PGA. For Automatic Memory Management, specify Total Memory for Oracle.
In the Database sizing section, specify the Block Size and number of Processes. If you have selected a database template with datafiles in the Database Template page, you cannot edit the Block Size.
Specify the Host CPU Count. The maximum CPU count that can be specified is equal to the number of CPUs present on the host.
In the Character Sets section, select the default character set. The default character set is based on the locale and operating system.
Select a national character set. The default is AL16UTF16.
In the Database Connection Mode section, select the dedicated server mode. For shared server mode, specify the number of shared servers.
Click on the Lock icon to lock the fields you have configured. These fields will not be available for editing in the operator role.
Click Next.
In the Additional Configuration Options page, select custom scripts from the Software Library. If you have selected a Structure Only database template in the Database Template page, you can also view and edit database options. Click on the Lock icon to lock the field. Click Next.
In the Schedule page, specify a Deployment Instance name and a schedule for the deployment. If you want to run the procedure immediately, then retain the default selection, that is Immediately. If you want to run the procedure later, then select Later and provide time zone, start date, and start time details. Click Next.
In the Review page, review the details you have provided for the deployment procedure and if you are satisfied with the details, then click Finish to run the deployment procedure according to the schedule set. If you want to modify the details, then click Back repeatedly to reach the page where you want to make the changes. Click Save to save the deployment procedure for future deployment. Click Analyze to check for prerequisites and to ensure that all the necessary requirements for provisioning are met.
In the Procedure Activity page, view the status of the execution of the job and steps in the deployment procedure. Click the Status link for each step to view the details of the execution of each step. You can click Debug to set the logging level to Debug and click Stop to stop the procedure execution.