VM Clusters is selected by default.

A list of VM Clusters is displayed for the chosen Compartment.

In the VM Cluster Details page, under Resources, Databases is selected by default.

(or)

1. Open the navigation menu. Under Oracle Database, click Exadata Cloud@Customer.

   VM Clusters is selected by default.

2. Choose your Compartment.

   A list of VM Clusters is displayed for the chosen Compartment.

3. Click the name of a VM cluster where you want to create the database.

   In the VM Cluster Details page, under Resources, Databases is selected by default.

4. Click Database Homes.
5. Click the name of the Database Home where you want to create the database.
6. Click Create Database.

Provide the requested information in the Create Database page:

• Provide the database name: Specify a user-friendly name that you can use to identify the database. The database name must contain only the permitted characters.
  Review the following guidelines when selecting a database name.

  • maximum of 8 characters
  • contain only alphanumeric characters
  • begin with an alphabetic character
  • cannot be part of first 8 characters of a db_unique_name on the VM cluster
  • unique within a VM cluster
  • DO NOT use grid because grid is a reserved name
  • DO NOT use ASM because ASM is a reserved name

• Provide a unique name for the database: Optionally, specify a unique name for the database. This attribute defines the value of the db_unique_name database parameter. The value is case insensitive.

  The db_unique_name must contain only the permitted characters. Review the following guidelines when selecting a database name.

  • maximum of 30 characters
  • can contain alphanumeric and underscore (_) characters
  • begin with an alphabetic character
  • unique across the fleet/tenancy

  If a unique name is not provided, then the db_unique_name defaults to the following format <db_name>_<3 char unique string>_<region-name>.

  If you plan to configure the database for backup to a Recovery Appliance backup destination, then the unique database name must match the name that is configured in the Recovery Appliance.

• Select a database version: From the list, choose the Oracle Database software release that you want to deploy.
• Database Home: Select an existing Database Home or create one as applicable. Note that this field is not available when you create a Database from the Database Home details page.
  • Select an existing Database Home: If one or more Database Homes already exist for the database version you have selected, then this option is selected by default. And, you will be presented with a list of Database Homes. Select a Database Home from the list.
  • Create a new Database Home: If no Database Homes exist for the database version you have selected, then this option is selected by default.
    1. Enter Database Home display name.
    2. Click Change Database Image to select your software version.

       Select a Database Software Image window is displayed.

    3. Select an Image Type, Oracle Provided Database Software Images, or Custom Database Software Images.

       If you choose Oracle Provided Database Software Images, then you can use the Display all available version switch to choose from all available PSUs and RUs. The most recent release for each major version is indicated with a latest label.

       Note
       
       For the Oracle Database major version releases available in Oracle Cloud Infrastructure, images are provided for the current version plus the three most recent older versions (N through N - 3). For example, if an instance is using Oracle Database 19c, and the latest version of 19c offered is 19.8.0.0.0, images available for provisioning are for versions 19.8.0.0.0, 19.7.0.0, 19.6.0.0 and 19.5.0.0.

• Provide the name of the first PDB: (Optional) Specify the name for the first PDB. A PDB is created with the database.

  To avoid potential service name collisions when using Oracle Net Services to connect to the PDB, ensure that the PDB name is unique across the entire VM cluster. If you do not provide the name of the first PDB, then a system-generated name is used.

• Provide the administration password: Provide and confirm the Oracle Database administration password. This password is used for administration accounts and functions in the database, including:

  • The password for the Oracle Database SYS and SYSTEM users.
  • The Transparent Data Encryption (TDE) Keystore password.

  For Oracle Database 12c Release 1 or later releases, the password for the PDB administration user in the first PDB (PDBADMIN) must be nine to 30 characters and contain at least two uppercase, two lowercase, two numeric, and two special characters. The special characters must be _, #, or -. In addition, the password must not contain the name of the tenancy or any reserved words, such as Oracle or Table, regardless of casing.

  • Use the administrator password for the TDE wallet: When this option is checked, the password entered for the SYS user is also used for the TDE wallet. To set the TDE wallet password manually, uncheck this option and enter the TDE wallet password.

• Backup Destination Type: Select a backup destination for the database. From the list, choose an option:

  • None: Select to not define a backup configuration for the database.
  • Local: Select to store backups locally in the Oracle Exadata Storage Servers on your Oracle Exadata Cloud at Customer system.

    This option is available only if you enabled backups on local Oracle Exadata storage in the VM cluster that you want to host the database.

  • Object Storage: Select to store backups in an Oracle-managed object storage container on Oracle Cloud Infrastructure.

    To use this option, your Oracle Exadata Cloud@Customer system must have egress connectivity to Oracle Cloud Infrastructure Object Storage.

  • NFS: Select to store backups in one of your previously defined backup destinations that use Network File System (NFS) storage. For more information, refer to the information about backup destinations in this publication.

    If you select this option, then you must also choose from the list of NFS Backup Destinations.

  • Recovery Appliance: Select to store backups in one of your previously defined backup destinations that use Oracle Zero Data Loss Recovery Appliance. Refer to the information about backup destination options in this document.

    If you select Oracle Zero Data Loss Recovery Appliance as your backup option, then you must also:

    • Choose from the list of appliance Backup Destinations.
    • Choose from the VPC User list, which contains the list of virtual private catalog (VPC) user names that are defined in the Oracle Zero Data Loss Recovery Appliance backup destination.
    • Provide the Password for the VPC user.
    Note
    
    

    If you select a backup destination, then you cannot change a backup location after the database is created. However, if you select None now, then you can select a backup destination after the database is created.

  • Enable automatic backups: Select this option to enable daily backups using the policy for automatic backups.

    This option is only enabled when you select a Backup Destination Type other than None. You can change this setting after database creation.

• (Optional) Select Show Advanced Options. From this window, you can select the following options:

  • Provide the Oracle SID prefix:
    Note
    
    Entering a SID prefix is only available for 12.1 databases and above.

    Optionally, specify the Oracle SID prefix for the database. The instance number is automatically appended to the SID prefix to become the instance_name database parameter. If not provided, then the SID prefix defaults to the db_name.

    Review the following guidelines when selecting a database name:

    • maximum of 12 characters
    • contain only alphanumeric characters
    • begin with an alphabetic character
    • unique in the VM cluster
  • Encryption Key: Choose an encryption option, Encrypt using Oracle-managed keys or Encrypt using customer-managed keys. The default option is Oracle-managed keys.

    To use customer-managed keys, select the Encrypt using customer-managed keys option, select the compartment where you have created the Key Store, and then select the Key Store. As part of the CDB creation, a new wallet is created for the CDB in Oracle Key Vault (OKV). Also, a TDE Master Key is generated for the CDB and added to the wallet in OKV.

    Note
    
    

    • Container Databases (CDB) and pluggable databases (PDB) only support 256-bit Hardware Security Module (HSM) Vault keys.
    • Validate OKV Key encryption post restart: OKV TDE Maser Key is validated every time you start or restart your CBD.
    • Start or restart fails if the key is not validated. Work requests and life cycle states indicate the reason for failure.
    • View OKV keys post database restore: When you restore a CDB, the master key associated with that backup is restored as well.
    • Enable CDB backups to capture wallet name: CDB backups information about the wallet associated with the backup.
    • OKV Wallet or TDE Master Key on CDB deletion: If you delete a CDB, then the wallet and TDE Master Key remain in OKV and will not be deleted.

  • Backup retention period: From the list, you can choose the length of time that you want automatic backups to be retained.

    For backups to local Exadata storage, you can choose a retention period of 7 days or 14 days. The default retention period is 7 days.

    For backups to Oracle Cloud Infrastructure Object Storage, or to an NFS backup destination, you can choose one of the following preset retention periods: 7 days, 14 days, 30 days, 45 days, or 60 days. The default retention period is 30 days.

    This option does not apply to Oracle Zero Data Loss Recovery Appliance backup destinations. For backups to Oracle Zero Data Loss Recovery Appliance, the retention policy that is implemented in the appliance controls the retention period.

  • Character set: The character set for the database. The default is AL32UTF8.
  • National character set: The national character set for the database. The default is AL16UTF16.
  • Tags: (Optional) You can choose to apply tags. If you have permissions to create a resource, you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, refer to information about resource tags.If you are not sure if you should apply tags, then skip this option (you can apply tags later), or ask your administrator.