1. Using Oracle Data Integrator Cloud
  2. Creating Service Instances for Oracle Data Integrator Cloud
  3. Provisioning Oracle Database Cloud Service Instances
  4. Creating an Oracle Database Cloud Service Instance

Creating an Oracle Database Cloud Service Instance

Using Oracle Data Integrator Cloud requires a subscription to Oracle Database Cloud Service and instance created. Learn to create an Oracle Database Cloud Service instance for use with Oracle Data Integrator Cloud.

Before you begin

To create a Database Cloud Service instance, you'll use the Create Service wizard as described in the following procedure.

When you create a Database Cloud Service instance, you provide information used to create the instance itself and the Oracle database it hosts. Additionally, you may need to provide information about other resources, such as:

  • An Oracle Database Cloud Service subscription

  • Enough CPUs to create an Oracle Database Cloud Service instance

  • An Oracle Cloud Infrastructure Object Storage Classic subscription

Procedure

To create Database Cloud Service instance:

  1. Open the Oracle Database Cloud Service console.

    For detailed instructions, see Access the Oracle Database Cloud Service Console.

  2. Click Create Instance.

    The Create Service wizard starts and the Service page is displayed.

  3. On the Service page, provide a name and description for the database service instance, and provide information about its high-level characteristics. When you’re finished, click Next to advance to the Service Details page.

    Field Name Description
    Instance Name

    The name of your database service instance. The name:

    • Must start with a letter.

    • Can’t be more than 50 characters.

    • Can’t contain any special characters except for a hyphen.
    Description

    A description for your new database service instance.
    Notification Email

    Enter your email address to receive notifications and status updates about this service instance.
    Region

    Select your region from the drop down menu or select No Preference.
    Tags

    Assign a tag from the list of tags or create a new tag.
    Bring Your Own License

    Check this box if you want to use your non cloud license.
    Software Release

    Select the release number from the drop down menu.
    Software Edition

    You can choose from:

    • Standard Edition

    • Enterprise Edition

    • Governance Edition
    Database Type

    You can choose from:

    • Single Instance

    • Database Clustering with RAC

    • Single Instance with Data Guard Standby

    • Data Guard Standby for Hybrid DR

    • Database Clustering with RAC and Data Guard Standby

  4. On the Service Detail page, complete the Database Configuration section by providing information about the Oracle Database you want to create.

    Field Name Description
    DB Name (SID)

    The name of the database instance. The name:

    • Must not exceed 8 characters.

    • Must start with a letter.

    • Must contain only letters, numbers, or these symbols: _ (underscore), # (hash sign), or $ (dollar sign).
    PDB Name

    (Available only for Oracle Database 12c.)

    The name of the default pluggable database (PDB). The name:

    • Must not exceed 8 characters.

    • Must start with a letter.

    • Must contain only letters, numbers, or these symbols: _ (underscore), # (hash sign), or $ (dollar sign).

    Administration Password

    Confirm Password

    The password for the following administrative users:

    • Oracle Database administrative users

    • Oracle Application Express admin user

    The password:

    • Must be 8 to 30 characters in length.

    • Must contain at least one lowercase letter

    • Must contain at least one uppercase letter

    • Must contain at least one number

    • Must contain at least one of these symbols: _ (underscore), # (hash sign), or $ (dollar sign).

    • Must not contain the word “oracle”.

    Usable Database Storage (GB)

    The amount of storage in GB for actual database data.

    Total Data File Storage (GB)

    The computed amount of storage in GB that will be allocated to the deployment, including space for operating system and product binaries, supporting files, database data and configuration files, and so on.

    Compute Shape

    The number of Oracle Compute Units (OCPUs) and amount of memory (RAM) for each compute node of the new database deployment.

    SSH Public Key

    Edit

    The SSH public key to be used for authentication when using an SSH client to connect to a compute node that is associated with your database deployment.

     

    To display the public key input for VM access, click Edit and specify the public key using one of the following methods:

    • Select Key File Name to select a file that contains a Secure Shell (SSH) public key to assign to this service instance

    • Select Key Value, then copy and paste the value to associate the value of an existing SSH public key with this service instance.

    • Click Create a New Key to create a public and private key file, zipped, and ready for you to save both files on your computer. This option saves the public key information for the service instance.

    For more information, see Creating SSH Keys for Use with Oracle Cloud Services

  5. On the Service Details page, complete the Advanced Settings fields by providing information about the following:

    Field Name Description

    Listener Port

    The port number for the Oracle Net Listener.

    The port number must be between 1521 and 5499 (inclusive).

    Timezone

    The time zone for the new database deployment. The default is Coordinated Universal Time (UTC).

    Character Set

    The database character set for the database. The database character set is used for:

    • Data stored in SQL  CHAR  data types (CHAR,  VARCHAR2,  CLOB, and  LONG)

    • Identifiers such as table names, column names, and PL/SQL variables

    • Entering and storing SQL and PL/SQL source code

    This option is not available if Create Instance from Existing Backup is set to Yes.

    National Character Set

    The national character set for the database. The national character set is used for data stored in SQL  NCHAR  data types (NCHAR,  NCLOB, and  NVARCHAR2).

    This option is not available if Create Instance from Existing Backup is set to Yes.

    Enable Oracle GoldenGate

    Configures the database for use as the replication database of an Oracle GoldenGate Cloud Service instance.

    Include “Demos” PDB

    You can deselect this option to save some space. Selecting this option configures several PDB demos in the database with the service instance creation. These demos are for 12c new features.

  6. On the Service Details page, complete the Backup and Recovery Configuration section, choosing a backup option for the database service instance and, depending on your choice, providing information about the Oracle Cloud Service container where cloud backups are to be stored.

    Field Name Description

    Backup Destination

    Controls how backups for the deployment are to be configured. Select Both Cloud Storage and Local Storage. All other options are incompatible with Data Integration Platform Cloud.

    For more information about backups and backup configurations, see About Backing Up Database Deployments on Database Cloud Service

    Cloud Storage Container

    The name of an existing Oracle Storage Cloud Service container or a new one to be created in the format:

    instance-id_domain/container

    where  instance  is the name of the Oracle Storage Cloud Service instance,  id_domain  is the id of the identity domain, and  container  is the name of the container.

    Note:

    Do not use the Oracle Storage Cloud container that you are using to back up  Database Cloud Service  deployments to cloud storage for any other purpose. For example, do not also use it to back up Oracle Java Cloud Service instances to cloud storage. Using the container for multiple purposes can result in billing errors.

    Username

    The user name of a user who has read/write access to the specified Oracle Storage Cloud Service container.

    Password

    The password of the user specified in  Cloud Storage User Name .

    Create Cloud Storage Container

    Create a new Oracle Storage Cloud Service container as part of the database deployment creation. Specify the container name and the Cloud Storage user name and password in the preceding fields.

    Total Estimated Monthly Storage (GB)

    Storage for data files and backups.

  7. On the Service Details page, complete the Initialize Data From Backup section if you are having the new database populated, or "instantiated," from the data stored in the Database Backup Cloud Service backup. When you're finished, click Next to advance to the Confirmation page.

  8. On the Confirmation page, review the information listed. If you’re satisfied with the information, click Create.

    If you need to change the information, use the navigation bar or Previous button at the top of the wizard to step back through the pages in the wizard. Click Cancel to cancel out of the wizard without creating a new Database Cloud service instance.

You can follow the steps in this tutorial to provision and access Oracle Data Integrator Cloud Service Instance, Provisioning and Accessing Oracle Data Integrator Cloud Service Instance. If you have a clustered Oracle Data Integrator Cloud Service Instance, then follow the steps in this tutorial to provision and access it, Provisioning and Accessing the Clustered Oracle Data Integrator Cloud Instance