Oracle Cloud Infrastructure Documentation

Managing Oracle Database Homes on an Exadata Cloud Infrastructure Instance

You can delete or view information about Oracle Database Homes (referred to as "Database Homes" in Oracle Cloud Infrastructure) by using the Oracle Cloud Infrastructure Console, the API, or the CLI.

For information on how to perform these tasks manually, see About Using the dbaascli Utility on Exadata Cloud Infrastructure .

Parent topic: How-to Guides

Manage Database Home Using the Console

Use the OCI console to manage the various operations needed on a Database Home.

Parent topic: Managing Oracle Database Homes on an Exadata Cloud Infrastructure Instance

To view information about a Database Home

  1. Open the navigation menu. Click Oracle Database, then click Oracle Exadata Database Service on Dedicated Infrastructure
  2. Choose your Compartment.
  3. Navigate to the cloud VM cluster or DB system containing the Database Home:.
    • Cloud VM clusters (new resource model): Under Oracle Exadata Database Service on Dedicated Infrastructure, click Exadata VM Clusters. In the list of VM clusters, find the VM cluster you want to access and click its highlighted name to view the details page for the cluster
    • DB systems: Under Bare Metal, VM, and Exadata, click DB Systems. In the list of DB systems, find the Exadata DB system you want to access, and then click its name to display details about it.
  4. On the DB System Details page, under Resources, click Database Homes.
  5. In the list of Database Homes, find the Database Home you are interested in, and then click its name to display details about it.
(Optional) Enter the result of the procedure here.

To delete a database home

You cannot delete a Database Home that contains databases. You must first terminate the databases to empty the Database Home. See To terminate a database to learn how to terminate a database.

  1. Open the navigation menu. Click Oracle Database, then click Oracle Exadata Database Service on Dedicated Infrastructure
  2. Choose your Compartment.
  3. Navigate to the cloud VM cluster or DB system containing the Database Home you want to delete:

    • Cloud VM clusters (new resource model ): Under Oracle Exadata Database Service on Dedicated Infrastructure, click Exadata VM Clusters. In the list of VM clusters, find the VM cluster you want to access and click its highlighted name to view the details page for the cluster.

    • DB systems: Under Bare Metal, VM, and Exadata, click DB Systems. In the list of DB systems, find the Exadata DB system you want to access, and then click its name to display details about it.

  4. On the DB System Details page, under Resources, click Database Homes.
  5. In the list of Database Homes, find the Database Home you want to delete, and then click its name to display details about it.
  6. On the Database Home Details page, click Delete.

    If the Database Home contains databases, you will not be able to proceed. You must cancel the deletion, empty the Database Home as applicable, and then retry the deletion.

To manage tags for your Database Home

  1. Open the navigation menu. Click Oracle Database, then click Oracle Exadata Database Service on Dedicated Infrastructure
  2. Choose your Compartment.
  3. Navigate to the cloud VM cluster or DB system containing the Database Home:
    • Cloud VM clusters (new resource model): Under Oracle Exadata Database Service on Dedicated Infrastructure, click Exadata VM Clusters. In the list of VM clusters, find the VM cluster you want to access and click its highlighted name to view the details page for the cluster.
    • DB systems: Under Bare Metal, VM, and Exadata, click DB Systems. In the list of DB systems, find the Exadata DB system you want to access, and then click its name to display details about it.
  4. Under Resources, click Database Homes.
  5. In the list of Database Homes, find the Database Home you want to administer.
  6. Click the the Actions icon (three dots) on the row listing the Database Home, and then click Add Tags.

Using the Console to Move a Database to Another Database Home

Learn to move a database to another Database Home.

  1. Open the navigation menu. Under Oracle Database, click Oracle Exadata Database Service on Dedicated Infrastructure.
  2. Choose your Compartment that contains the VM cluster that hosts the database that you want to move.
  3. Click Exadata VM Clusters in the left hand navigation.
  4. Click the name of the VM cluster that contains the database that you want to move.
  5. In the Resources list of the VM Cluster Details page, click Databases.
  6. Click the name of the database that you want to move.
    The Database Details page displays information about the selected database.
  7. Click More Actions and Move To Another Home.
  8. In the resulting dialog, select the target Database Home.
    Note

    Oracle recommends using Database Homes, which are running the latest (N) to 3 versions from the latest (N-3) RU versions when updating the software version of the database by moving them to a target DB Home. Only DB Homes provisioned with database versions, which meet this best practice criterion are available as target homes to move your database.
  9. Click Move Database.

The database will be stopped in the current home and then restarted in the destination home. While the database is being moved, the Database Home status displays as Moving Database. When the operation completes, Database Home is updated with the current home. If the operation is unsuccessful, the status of the database displays as Failed, and the Database Home field provides information about the reason for the failure.

Using the API to Manage Oracle Database Home on Exadata Cloud Infrastructure

Review the list of API calls to manage Oracle Database home.

For information about using the API and signing requests, see "REST APIs" and "Security Credentials". For information about SDKs, see "Software Development Kits and Command Line Interface".

Use these API operations to manage Database Homes:
  • ListDbHomes
  • GetDbHome
  • DeleteDbHome

For the complete list of APIs, see "Database Service API".