Oracle Cloud Infrastructure Documentation

Exadata Database

To create an Exadata Database and its associated components (Database Home, Container Database (CDB), and Pluggable Database (PDB)) using the OCI console, follow these steps.

    1. From Google Cloud dashboard, select the Exadata Database Service > Dedicated Infrastructure menu item.
    2. By default, the Exadata Infrastructure tab is selected. Select theExadata VM Cluster tab.
    3. Select the Manage in OCI icon which allows you to manage your Exadata VM Cluster in OCI.This screenshot shows the selected Exadata VM Cluster details.
    4. Subsequent steps for creation of Exadata Database are performed through the OCI Console.
    1. From the OCI console, select the Databases tab, and then select the Create database button.
    2. From the Create database page, complete the following steps.
    3. From the Basic Information section, enter the following.
      1. Enter a Database name. The Database name can contain alphanumeric characters and it can not be longer than 8 characters.
      2. Enter a name in the Database unique name field. If you do not specify it, the system automatically generates a database unique name. The Database unique name can be up to 30 characters.
    4. From the Database Home section, enter the following.
      1. The Database release dropdown list allows you select either 19c or 26ai versions.
      2. For your Database Home source, there are two available options. These options are Create a new Database Home and Select an existing Database Home. Based on your requirements, make a selection.
        1. If you select the Create a new Database Home option, complete the following steps:
          1. Enter a name in the Database Home display name field.
          2. Select the Enable Unified Auditing checkbox. This combines all database component audit trails into single unified audit file.
          3. From the Database image drop-down, select the image that will be used for database creation.
        2. If you select the Create a new Database Home option, enter a name in the Database Home display name field.
    5. From the Create administrator credentials section, enter the following.
      1. The administrator username is sys by default.
      2. Enter your Password. The Password must be 9 to 30 characters and contain at least 2 uppercase, 2 lowercase, 2 special, and 2 numeric characters. The only permitted special characters are underscore (_), hash (#), and hyphen (-).
      3. Enter your Confirm password to ensure that it matches Password.
    6. From the Database backups section, enter the following.
      1. Select the Enable automatic backups button to enable automatic incremental backups for your database.
      2. In the Backup destination drop-down, you can select either Object Storage or Autonomous Recovery Service.
        1. If you select the Object Storage option, complete the following substeps:
          1. In the Backup retention period of the backup, enter a value from 7 to 60 days.
          2. In the Scheduled day for full backup (UTC) section, choose a day of the week for the initial and future LO backups to start.
          3. In the Scheduled time for full backup (UTC) drop-down, select the time window when the full backups start.
          4. In the Scheduled time for incremental backup (UTC) drop-down, select the time window when the incremental backups start.
        2. If you select the Autonomous Recovery Service option, complete the following substeps:
          1. From the Compartment drop-down list, select the compartment.
          2. From the Protection policy drop-down list, make a selection based on your requirements.
          3. The backup location field is set to Backups will be stored in OCI.
          4. The Retention lock field is Disabled by default.
          5. Enable the Real-time data protection toggle to minimize the possibility of data loss.
          6. From the Scheduled time for daily backup (UTC) drop-down list, select the time window when the daily backup starts.
      3. Select the Take the first backup immediately button if you want to take your first backup immediately after successful database creation.
      4. From the Deletion options after database termination section, you can choose an option to retain protected database backups after the database is terminated. Based on your system requirements, make a selection.
    7. From the Encryption section, allows you to choose either Use Oracle-managed keys or Use customer-managed keys.
    8. The Use the administrator password for the TDE wallet toggle is enabled. When this option checked, the password entered for the SYS user is also used for the TDE wallet.
    9. The Advanced options section, which is optional and collapsed by default, you can enter the following:
      1. Enter your Oracle SID prefix.
        Note

        The Oracle Database instance number is automatically added to the SID prefix to create the INSTANCE_NAME database parameter.
      2. The Character set field is selected as AL32UTF8.
      3. The National character set field is selected as AL16UTF16.
    10. From the Tags section, enter the following.
      1. If you want to add a tag, select Add tag button.
      2. Select your Namespace from the drop-down. The default value is entered.
      3. Enter values for your Key and Value.
    11. Select the Create button to complete the process.
    12. Once your database is created, the Status changes from Provisioning to Available. From the database details page, select the specific Exadata Database. Navigate to Encryption section and select the Change button. This displays the current encryption settings for the selected Exadata Database.This screenshot shows the selected Exadata VM Cluster and the Exadata Database created on that cluster

  • There is currently no content for this page. Oracle AI Database@Google Cloud team intends to add content here, and this placeholder text is provided until that text is added. The Oracle AI Database@Google Cloud team is excited about future new features, enhancements, and fixes to this product and this accompanying documentation. We strongly recommend you watch this page for those updates.

  • There is currently no content for this page. Oracle AI Database@Google Cloud team intends to add content here, and this placeholder text is provided until that text is added. The Oracle AI Database@Google Cloud team is excited about future new features, enhancements, and fixes to this product and this accompanying documentation. We strongly recommend you watch this page for those updates.

  • You can provision an Exadata Database in Google Cloud using OCI Terraform provider.

    Prerequisites
    Sample Terraform Configuration Using OCI Terraform Provider
    # Create Database Home
resource "oci_database_db_home" "db_home" {
  vm_cluster_id   = google_oracle_database_cloud_vm_cluster.exadata_vm_cluster.properties[0].ocid
  source          = "VM_CLUSTER_NEW" 
  display_name    = "dbhome-26ai"
  db_version      = "23.26.0.0.0"
  freeform_tags   =  {
    "env" = "dev"
  }
}

# Create Container and Pluggable Database
resource "oci_database_database" "exa_database" {
  db_home_id                      = oci_database_db_home.db_home.id
  source                          = "NONE"
  database {
    db_name                       = "democdb"
    # db_unique_name              = var.database_database_db_unique_name
    pdb_name                      = "demopdb"
    # database_software_image_id  = oci_database_database_software_image.test_database_software_image.id  
    admin_password                = "********************" # Enter a strong password
    db_backup_config {
      auto_backup_enabled         = true
      auto_backup_window          = "SLOT_TWO"
      auto_full_backup_day        = "MONDAY"
      auto_full_backup_window     = "SLOT_TWO"
      backup_deletion_policy      = "DELETE_IMMEDIATELY" # Possible values: DELETE_IMMEDIATELY, DELETE_AFTER_RETENTION_PERIOD
      backup_destination_details {
        type                      = "OBJECT_STORE" # Possible values: OBJECT_STORE, RECOVERY_APPLIANCE
      }
      recovery_window_in_days     = 7
      run_immediate_full_backup   = true
    }    
    tde_wallet_password           = "********************" # Enter a strong password
    # sid_prefix                  = var.database_database_sid_prefix
    character_set                 = "AL32UTF8"
    ncharacter_set                = "AL16UTF16"   
    freeform_tags                 =  {
      "env" = "dev"
    }    
  }
}