Creating Oracle Database Homes on an Exadata Cloud Service Instance
You can add Oracle Database Homes (referred to as "Database Homes" in Oracle Cloud Infrastructure) to an existing Exadata Cloud Service instance by using the Oracle Cloud Infrastructure Console, the API, or the CLI.
A Database Home is a directory location on the Exadata database compute nodes that contains Oracle Database software binary files. Compute nodes are also referred to as virtual machines in the Oracle Cloud Infrastructure Console
After you provision the Exadata Cloud Service instance, you can create one or more Database Homes in the instance, and add databases to any of the Database Homes.
You can also add and remove Database Homes, and perform other management tasks on a Database Home by using the dbaascli utility. For information and instructions, see Managing Oracle Database Homes Manually.
Required IAM Policy
To use Oracle Cloud Infrastructure, you must be granted security access in a policy by an administrator. This access is required whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you get a message that you don’t have permission or are unauthorized, verify with your administrator what type of access you have and which compartment you should work in.
For administrators: The policy in Let database admins manage Oracle Cloud database systems lets the specified group do everything with databases and related Database resources.
Using the Console
- Open the navigation menu. Under Oracle Database, click Bare Metal, VM, and Exadata.
- Choose your Compartment.
Cloud VM clusters (new resource model): Under Exadata at Oracle Cloud, 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.
Under Resources, click Database Homes.
A list of Database Homes is displayed.
Click Create Database Home.
In the Create Database Home dialog, enter the following:
- Database Home display name: The display name for the Database Home. Avoid entering confidential information.
Database image: Determines what Oracle Database version is used for the database. You can mix database versions on the DB system, but not editions. By default, the latest Oracle-published database software image is selected.
Click Change Database Image to use an older Oracle-published image or a custom database software image that you have created in advance, then select an Image Type:
- Oracle Provided Database Software Images: These images contain generally available versions of Oracle Database software.
- Custom Database Software Images: These images are created by your organization and contain customized configurations of software updates and patches. Use the Select a compartment and Select a Database version selectors to limit the list of custom database software images to a specific compartment or Oracle Database software major release version.
After choosing a software image, click Select to return to the Create Database dialog.
Click Show Advanced Options to specify advanced options for the Database Home.
Tags: If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, see Resource Tags. If you are not sure if you should apply tags, then skip this option (you can apply tags later) or ask your administrator.
When the Database Home creation is complete, the status changes from Provisioning to Available.
Using the API
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 the CreateDbHome API operation to create Database Homes.
For the complete list of APIs for the Database service, see Database Service API.