Create DB systems

This page describes how to create Base Database Service resources, that is, DB systems in Google Cloud.

Oracle Database@Google Cloud lets you create an DB systems in the Google Cloud using Google Cloud console and Oracle Database@Google Cloud API.

You must create your DB system in the same region and zone as your ODB Network. This ensures optimal performance and seamless communication.

For a list of regions and zones in which you can create DB systems, see Supported regions and zones.

Before you begin

Create a Base DB system

The DB system provisioning workflow creates the following three resources:

  • A DB system
  • A container database (CDB)
  • A pluggable database (PDB)

To create a DB system, do the following:

Console

  1. Go to the Base Database Service page.

    Go to Base Database Service

  2. Click Create.

  3. Enter a Display name for your DB system. This name appears in the Google Cloud console. The display name must be unique within your Google Cloud project.

  4. For System ID, enter a unique identifier for your DB system. The DB system ID can't be changed later.

  5. Select a Region and a GCP Oracle zone. The region and zone choice is permanent and can't be changed later.

  6. In the Configure Shape section, enter the Number of ECPUs for Standard.x86 shape.

    The ECPU count can range from 4 to 256, in increments of 4. The value of Memory is automatically updated based on the number of ECPUs.

  7. From the Available data storage menu, select a storage size.

    The value of Recovery area storage is updated automatically based on the storage size you select.

  8. Select an Oracle Database software edition. The following editions are available:

    • Standard Edition
    • Enterprise Edition
    • Enterprise Edition high performance

    For information about these editions, refer to the Oracle documentation.

  9. Select your License type. The available options are License included and Bring Your Own License.

  10. In the SSH keys section, add the SSH keys you'd like to use for the DB system. To add a key, enter the SSH key name in the SSH Key 1 field. For each additional key, click ADD ITEM.

    For more information on how to generate SSH keys, see Generate SSH keys.

  11. In the Networking section, define the network configuration for the DB system:

    1. From the Network project list, select the project that contains your ODB Network.

    2. Select the ODB Network.

    3. Select a Client subnet.

    4. Enter a Hostname prefix. This prefix can only contain letters, numbers, or hyphens, and must start with a letter. The maximum allowed length is 12 characters.

    5. (Optional) In the Advanced network settings section, you can provide a Private IP address. This must be an available IP address within the subnet's CIDR.

      If you don't specify an IP address, a private IP address is automatically assigned from the subnet.

  12. In the Diagnostics collection section, configure monitoring for your DB system:

    1. Select the Enable diagnostic events checkbox to track all DB system diagnostic events.

    2. Select the Enable incident logs and trace collection checkbox to enable incident logging for your DB system.

  13. In the Advanced fields section, select a Timezone which you'd like to use for diagnostic collection. This timezone is used for event timestamps.