Create Database

This topic describes how to create a database in Oracle Base Database Cloud@Customer.

Before you begin, review the following:

You cannot modify the db_name, db_unique_name, or SID prefix after the database is created.
After the database is created, you cannot change the backup destination.

Procedure

Perform the following steps in the Console.

On the Data Infrastructures list page, select the Data Infrastructure that you want to work with. If you need help finding the list page or the Data Infrastructure, see List Data Infrastructures.
On the Data Infrastructure details page, select the VM Cluster tab to view the list of all VM Clusters.
On the VM Clusters tab, select the VM Cluster that you want to work with.
On the VM Cluster details page, select the Databases tab to view the list of all databases.
On the Databases tab, select Create Database.
On the Create Database page, provide the following details.
- Database name: Specify a user-friendly name to identify the database. The database name must follow these guidelines:
  - Maximum of 8 characters
  - Contains only alphanumeric characters
  - Begins with an alphabetic character
  - Must not match the first 8 characters of any db_unique_name on the VM Cluster
  - Must be unique within the VM Cluster
  - Do not use grid, because it is a reserved name
  - Do not use ASM, because it is a reserved name
- 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 db_unique_name must follow these guidelines:
  - The value is not case-sensitive.
  - Maximum of 30 characters
  - Can contain alphanumeric characters and underscores (_)
  - Begins with an alphabetic character
  - Must be unique across the fleet or tenancy
If you do not specify a unique name, the db_unique_name defaults to the following format:
```
<db_name>_<3-character unique string>_<region-name>
```
If you plan to configure the database for backup to a Recovery Appliance backup destination, the unique database name must match the name configured in the Recovery Appliance.
- Database version: From the list, select the Oracle AI Database software release that you want to deploy.
- PDB name: (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 VM Cluster. If you do not provide a PDB name, a system-generated name is used.
- Database Home:
  - Database Home source: Select an existing Database Home or create one, as applicable. 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 selected database version, this option is selected by default. Select a Database Home from the list.
    - Create a new Database Home: If no Database Homes exist for the selected database version, this option is selected by default.
  - Database Home: Specify the name for the new Database Home.
  - Unified Auditing: (Optional) Enable the unified auditing if required. This is enabled by default for Oracle AI Database 26ai.
  - Database image: Determines what Oracle AI Database version is used for the database. You can mix database versions, but not editions. By default, the latest Oracle-published database Software Image is selected.
    
    Select Change Database Image to use a different Oracle-published image or a custom database Software Image that you have created in advance, then select an Image type:
    - Oracle Provided Database Software Images: These images contain generally available versions of Oracle AI Database software.
    - Custom Database Software Images: These images are created by your organization and contain customized configurations of software updates. Use the Compartment and Database version filters to select the custom database Software Images from a specific compartment or Oracle AI Database software major release version.
      
      The custom database Software Image must be based on an Oracle AI Database release that meets the following criteria:
      - The release is currently supported by OCI.
      - The release is supported by the hardware model you are provisioning.
    After selecting a Software Image, select the Select button.
    
    For the available Oracle AI Database major version releases, 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.31.0.0, images available for provisioning are for versions 19.31.0.0, 19.30.0.0, 19.29.0.0 and 19.28.0.0.
- Administration password:
  - User name: Displays the user name.
  - Password: Enter the Oracle AI Database administration password.
    - This password is used for the following database administration accounts and functions:
      - The password for the SYS and SYSTEM users
      - The Transparent Data Encryption (TDE) keystore password
      - The PDBADMIN user in the first PDB.
    - The password must be:
      - 9 to 30 characters long
      - Contain at least:
      - Two uppercase letters
      - Two lowercase letters
      - Two numeric characters
      - Two special characters
      - Use only the following special characters:
        
        _
        
        #
        
        -
      - Must not contain the tenancy name
      - Must not contain reserved words, such as Oracle or Table, regardless of case
  - Confirm password: Reenter the password.
- Backups:
  - Enable automatic backups: Turn on to enable automatic backups. Automatic backups are performed daily if enabled.
  - Backup destination type: Select a backup destination for the database. Select one of the following options:
    - Recovery Appliance: Stores backups in a previously defined Oracle Zero Data Loss Recovery Appliance backup destination.
      - Compartment: Select the compartment for the Recovery Appliance backup.
      - Backup destinations: Select a Recovery Appliance backup destination from the list.
      - Recovery appliance connection string: Displays the connection string of the selected recovery appliance.
      - VPC user: Select a virtual private catalog (VPC) user from the list.
      - Password: Enter the password for the VPC user.
      - Enter the source database’s TDE wallet or RMAN password: Enter the password.
      - Real-time data protection: Turn on for continuous data protection. Real-time data protection minimizes the possibility of data loss.
    - Network File System (NFS): Stores backups in a previously defined Network File System (NFS) backup destination.
      - Compartment: Select the compartment for the NFS backup.
      - Backup destinations: Select a NFS backup destination from the list.
- Encryption:
  - Key management: Select a key management. The default option is Oracle Wallet.
    - Oracle Wallet:
      - Use the administrator password for the TDE wallet: When this option is turned on, the password entered for the SYS user is also used for the TDE wallet. To specify a different TDE wallet password, clear this selection, and then enter and confirm the TDE wallet password.
    - Oracle Key Vault:
      - Compartment: Select the compartment that contains the keystore.
      - Key Store: Select the keystore.
    - External Keystore:
      - TDE wallet password: Enter the TDE wallet password.
      - External keystore credentials: Enter credentials in the format supported by the external keystore provider.
- Advanced Options: Expand to provide additional details.
  - Management: Expand to provide additional details.
    - Oracle SID prefix: 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.
    - 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: Expand to provide additional details. You can add free-form tags or defined tags to this resource. You must have permission to use the tag namespace for defined tags. For more information about using tags to manage your resources, see Tags. Tags can be applied later or at any time to a resource.
Select Create.

The Database details page is now displayed. While the creation process is running, the state of the database is Provisioning. When the database creation process completes, the state of the database changes to Available.