Managing Oracle Database Homes on an Oracle Exadata Database Service on Exascale 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.

Manage Database Home Using the Console

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

To view information about a Database Home

To view the details of a Database home, use this procedure.

  1. Open the navigation menu. Click Oracle Database, then click Exadata Database Service on Exascale Infrastructure
  2. Choose your Compartment.
  3. Navigate to the cloud VM cluster or DB system containing the Database Home.
    Under Oracle Exadata Database Service on Exascale 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
  4. On the VM Cluster 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 Exadata Database Service on Exascale Infrastructure
  2. Choose your Compartment.
  3. Navigate to the cloud VM cluster or DB system containing the Database Home you want to delete:

    Under Oracle Exadata Database Service on Exascale 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.

  4. On the VM Cluster 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

To add and modify metadata tags to help to manage your Database, use this procedure.

  1. Open the navigation menu. Click Oracle Database, then click Exadata Database Service on Exascale Infrastructure
  2. Choose your Compartment.
  3. Navigate to the cloud VM cluster or DB system containing the Database Home:
    Under Oracle Exadata Database Service on Exascale 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.
  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 (
    Action menu

    ) 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 Exadata Database Service on Exascale 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 Oracle Exadata Database Service on Exascale 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".