This blog post covers how you can Create, Manage, & Delete Shared Oracle Database Home for Exadata DB System on Oracle Cloud (ExaCS).
Until now, you could create only one Database per Oracle DB Home. For every DB you create on Exadata, it used to create its own dedicated Oracle Home & there is one to one mapping between an Oracle Home & number of the database you can have on that Exadata DB System on Cloud (ExaCS).
If you are a beginner to Exadata Cloud Service (ExaCS) then check out K21 Academy’s blogs:
- Oracle Exadata Cloud Service (ExaCS): Overview for Beginners
- Oracle Exadata Cloud Service(ExaCS) Architecture
- Oracle Cloud Database Options (VMDB, BMDB, ExaCS, ExaCS & Autonomous (ADW, ATP)
What’s New?
Oracle recently announced that now you can add Oracle Database Homes to an existing Exadata DB system by using the Oracle Cloud Infrastructure (OCI)Console, the API (Rest API), or the CLI (dbaascli). It also allows the user to create Multiple Database Homes in a Single Database.
Before, If you want to create 3 databases, you have to create 3 DB Oracle Home for each DB, but now you can put all those Databases into single Oracle Home, which means you can now create, manage & delete these Oracle Home.
What Is Oracle Database Home?
A Database Home is a directory location on the Exadata database compute nodes that contain Oracle Database software binary files.
When you do Patching in Oracle Cloud, you first patch the DB System then you patch the Database home, DB System is nothing but the host machine where your database is installed. To know more check here
How To Manage DB Home In ExaCS?
You can also manage & delete Database Homes and perform other management tasks on a Database Home by using any of the three methods:
- Oracle Cloud Console
- dbaascli Utility (This tool is also used to patch an Exadata machine or Exadata DB on Cloud)
- REST API
1. Oracle Cloud Console
One can create DB Home and Database using the Oracle Console
Steps to create a new Database Home in an existing Exadata DB system
- Open the Hamburger menu. Go to Database, click Bare Metal, VM, and Exadata.
- Choose your Compartment. A list of DB systems is displayed.
- In the list of DB systems, find the Exadata DB system on which you want to create the Database Home, 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. Enter the name and select the DB version.
- Click Create. When the Database Home creation is complete, the status changes from Provisioning to Available.
A new database home is successfully created!
7. Now Open the Hamburger menu. Go to Database, click Bare Metal, VM, and Exadata
8. Click on Create New Database. Provide the DB name and choose the Existing Database Home you want to add the DB too.
9. Click on Create Database. When the Database Home creation is complete, the status changes from Provisioning to Available.
A new database is successfully created and added to the Database Home.
2. dbaascli Utility
We can use dbaascli utility to manage Database Home using Command Line Interface. Below are some of the most commonly used commands:
1) View information about Oracle Home directory locations by using
- # dbaascli dbhome info
2) Moving a Database to Another Oracle Home
- # dbaascli database move –dbname <dbname> –ohome <oracle_home>
3) Creating an Oracle Home
- # dbaascli dbhome create –version <software_version>
4) Deleting an Oracle Home
- # dbaascli dbhome purge
3. REST APIs
The Oracle Cloud Infrastructure APIs are typical REST APIs that use HTTPS requests and responses. Below is an example.
Example to Create Database Home with database details
POST /20160918/dbHomes Host: database.us-phoenix-1.oraclecloud.com <authorization and other headers> { "dbSystemId" : "ocid1.dbsystem.oc1.phx.<unique_ID>", "displayName" : "createdDbHome", "source": "NONE", "dbVersion" : "12.1.0.2", "database" : { "adminPassword" : "<password>", "dbName" : "myTestDb", "dbUniqueName" : "myTestDb_phx1cs", "dbBackupConfig" : { "recoveryWindowInDays" : 30, "autoBackupEnabled" : true } } }
Read more about REST APIs for DB Home
Related/Further Readings
- Oracle Exadata Cloud Service (ExaCS): Overview for Beginners
- Oracle Exadata Cloud Service(ExaCS) Architecture
- All About Oracle Database Cloud Service Certification [1Z0-998]
- All About Oracle Autonomous Database Cloud Certified Specialist [1Z0-931]
- Oracle Cloud Database Options (VMDB, BMDB, ExaCS, ExaCS & Autonomous (ADW, ATP)
- Oracle Exadata & Database Appliance: Understand the Difference
Next Task For You
If you want to upgrade your career from an Oracle DBA to Oracle Cloud DBA, and wants to clear Oracle Cloud Database Service Specialist[1Z0-1093-21] & Oracle Cloud Autonomous Database Certification[1Z0-931-21] with 18 Hands-On labs, then register for a FREE class, and don’t miss an opportunity to gain a plethora of insights on becoming a certified Oracle Cloud DBA.
Leave a Reply