Note:

Configure Oracle Exadata Database Service for Developers on Oracle Exadata Database Service on Cloud@Customer

Introduction

Users can now configure Oracle Exadata Database Service for developers on Oracle Exadata Database Service on Cloud@Customer. This feature will allow Oracle Exadata Database Service on Cloud@Customer users to develop applications on Oracle Exadata Database Service on Cloud@Customer using a no-cost Oracle Database license. Users can provision a new Exadata Database-Developer type of VM cluster to run Oracle Exadata Database Service and will only pay for the cost of the infrastructure. If using the previously idle capacity of an existing Oracle Exadata Database Service on Cloud@Customer, users will be able to develop in an Exadata Database–Developer VM cluster for no additional cost.

The Exadata Database–Developer VM cluster type is intended for developing applications only and is subject to limitations to prevent running production workloads in a developer VM cluster. Limits will be placed on the number of threads per pluggable database (PDB), the amount of memory per PDB, the size of the database per PDB, and the number of sessions per PDB. Advanced database features like Oracle Real Application Clusters and Oracle Data Guard will not be available.

Unlike other free alternatives targeted at developers that provide no support, Oracle Exadata Database Service for developers provides assistance from Oracle Support with SRs filed as Technical Issue or General Guidance.

Objectives

Prerequisites

Task 1: Create an Exadata Database-Developer VM Cluster on Oracle Exadata Database Service on Cloud@Customer

  1. Log in to the OCI Console, navigate to Oracle Database and click Oracle Exadata Database Service on Cloud@Customer.

    Image showing OCI Console Navigation

  2. Click Exadata VM Clusters and Create Exadata VM Cluster.

    Image showing Exadata VM Clusters

  3. In the Create Exadata VM Cluster page, enter the following information.

    • Select a compartment: Select a compartment where you want the VM cluster to be created.
    • Provide the display name: Enter the name for the VM cluster.
    • Select Exadata Infrastructure: Select the Exadata infrastructure to host the VM cluster.
    • Select a VM Cluster Network: Select the VM cluster network definition to use for the VM cluster.

    Image showing Exadata VM Clusters

  4. In VM Cluster Type, select Exadata Database-Developer.

    Image showing to configure VM Cluster type

  5. Complete the required fields in the Create Exadata VM cluster page as you would for any other cluster.

    You are limited to a single VM in the cluster, and only the License Included as License type is available. When finished, click Create VM Cluster.

    Image showing to configure VM Cluster

    In the VM Cluster Details page, the creation process is running, the lifecycle state of the VM cluster shows PROVISIONING.

    Image showing to create VM Cluster

    When the VM cluster creation process completes, the state of the VM cluster changes to AVAILABLE.

    Image showing create vm cluster

    The General information section shows the VM type configured, which, in this case, is Developer.

    Note: The resulting VM cluster will behave the same as any other VM cluster. You can create one or more CDBs, with any number of cores, memory, or storage. Each CDB can have one or more PDBs. The database will detect it is running in a developer VM cluster and limit the resources available to any one PDB as described:

    • Maximum 2 threads per PDB (enforced by the database).
    • Maximum 8GB memory per PDB (enforced by the database).
    • Maximum 20GB database size per PDB (enforced by the database).
    • Maximum 30 sessions per PDB (enforced by the database).
    • CDB/PDB only, no 19c non CDB databases.
    • Single-instance only (enforced by cloud automation).
    • No automation to create Oracle Data Guard association (enforced by cloud automation).
    • Manual Oracle Data Guard setup not allowed by policy.
    • Backup to same backup destinations as standard service. No cross region backup/restore (enforced by cloud automation).
    • Minimum RU 19.26 (Jan 2025) or 23.6 (Oct 2024).
    • You cannot switch the VM cluster type Exadata Database-Developer to another VM cluster type (enforced by cloud automation).
    • License type must be License Included. Bring Your Own License (BYOL) is not allowed.

Task 2: Provision an Oracle Database 23ai Container Database

  1. Go to the VM Cluster Details page, under Resources, select Databases and click Create Database.

    Image showing create database

  2. In the Create Database page, enter the following information.

    • Basic information for the container database:

      • Database name: Enter a name for the database.
      • Unique name (Optional): Enter a unique name for the database.
      • Database version: Select the database version available.
      • PDB name (Optional): Enter the name of the first PDB to be created.

      Image showing the basic container database information to enter

    • Specify a Database Home:

      • Database Home source: Select to use an existing Database Home or Create a new Database Home.
      • Database Home display name: Use the default database home name or enter a database home name.
      • Change Database Image (Optional): Determines what Oracle Database version is used for the database. By default, the latest Oracle-published database software image is selected. Select to use an older Oracle-published image or a custom database software image that you have created in advance.

      Image showing Database Home selection

    • Provide the administrator password:

      • Password: Enter password. Password must be 9 to 30 characters and contain at least 2 uppercase, 2 lowercase, 2 special, and 2 numeric characters. The special characters must be \, _, #, or -.
      • Confirm Password: Enter the same password.

  3. Complete the required fields in the Create Database page and click Create Database.

    Image showing the option confirm creation of container database

    Once the provisioning process of the Container Database is completed, the state of the container database will show as AVAILABLE.

    Image showing created container database

    Go to the Database details page, under Resources, select Pluggable Databases.

    Image showing created pdb

    Click the pluggable database to view the details.

    Image showing created pdb

Acknowledgments

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.