1. Open the navigation menu Under Database, and 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 Create Database.

   (or)

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

     VM Clusters is selected by default.

   • Choose your Compartment.

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

   • 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.

   • Click Database Homes.
   • Click the name of the Database Home where you want to create the database.
   • Click Create Database.

5. 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 name doesn't need to be unique because an Oracle Cloud Identifier (OCID) uniquely identifies the database.

   • 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, it can be up to 30 characters in length, and include alphanumeric characters, underscore (_), number sign (#), and dollar sign ($).

     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.

   • 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 SYSTEMusers.
     • 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.

   • Choose the database workload type: Select the workload type that best suits your application from one of the following options:

     • Online Transactional Processing (OLTP): Select this option to configure the database for a transactional workload, with a bias toward high volumes of random data access.

     • Decision Support System (DSS): Select this option to configure the database for a decision support or data warehouse workload, with a bias toward large data scanning operations.

   • 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@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 uses 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 uses 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:

     • 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.

6. Click Create Database.

The database will be stopped in the current home and then restarted in the destination home. While the database is being moved, the Database Home status displays as Moving Database. When the operation completes, Database Home is updated with the current home. If the operation is unsuccessful, the status of the database displays as Failed, and the Database Home field provides information about the reason for the failure.