Skip to content

ODA 19.11.: ORACLE_HOMEs on ACFS

Introduction

Beginning with Oracle Database Appliance (ODA) 19.11. the ORACLE_BASE and ORACLE_HOMEs are created on ACFS. That’s good news, because there is much more space on ASM than on the internal disks, i.e. no space issues with /u01 anymore. So how does it work?

ORACLE_BASE and ORACLE_HOME on ACFS

When installing an ODA from scratch then ORACLE_BASE and ORACLE_HOME are already on ACFS. See an example of a freshly installed ODA X8-2M:

[root@dbi-oda-x8 ~]# odacli list-dbhome-storages

============================================================================================================= 
ID                                     Node Description          Disk Group Volume      Size(GB)   Status     
-------------------------------------- ---- -------------------- ---------- ----------- ---------- ----------
3e5b27c0-f021-4cc8-9c4d-a68362aed23b   0    ORACLE_HOME          DATA       orahome_sh  30         CONFIGURED
a8fa8109-d8ec-4a4c-84f4-53b07661dc0f   0    ORACLE_BASE          DATA       odabase_n0  10         CONFIGURED
============================================================================================================= 

If there is no ORACLE_HOME on ACFS (e.g. after upgrading from an earlier version) then you should configure the database-home-storage. I.e. do that after step 14 (update of the storage components) of the upgrade process. In the following example I configure 100GB for my ORACLE_HOMEs on diskgroup DATA:

[root@dbi-oda-x8 ~]# odacli configure-dbhome-storage -dg DATA -s 100
DCS-10606:Database homes storage has already been created, no changes are allowed.

The command failed, because a dbhome-storage has already been configured on my machine.

With describe-dbhome-storage you can get more information about the dbhome-storage:

[root@dbi-oda-x8 ~]# odacli describe-dbhome-storage -i 3e5b27c0-f021-4cc8-9c4d-a68362aed23b
ORACLE_HOME storage details:
================================================================
                     ID: 3e5b27c0-f021-4cc8-9c4d-a68362aed23b
                  State: CONFIGURED
                Created: July 29, 2021 9:33:24 AM CEST
                Updated: July 29, 2021 9:58:33 AM CEST

 Volume Details
 --------------
                   Name: orahome_sh
             Disk Group: DATA
            Description: ORACLE_HOME
            Node Number: 0
        Allocated Space: 30.0 GB
             Used Space: 12.22 GB
             Free Space: 17.77 GB
               Location: /u01/app/odaorahome

 DiskGroup Details
 -----------------
                   Name: DATA
        Allocated Space: 4.65 TB
             Used Space: 352.31 GB
             Free Space: 4.31 TB
================================================================

[root@dbi-oda-x8 ~]# 

The size of the dbhome-storage can be changed with modify-dbhome-storage. E.g. here I resize it to 40GB:

[root@dbi-oda-x8 ~]# odacli modify-dbhome-storage -i 3e5b27c0-f021-4cc8-9c4d-a68362aed23b -s 40
{
  "jobId" : "bec8b73f-5537-4b59-87e9-bb780edf38d1",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "August 04, 2021 22:26:02 PM CEST",
  "resourceList" : [ ],
  "description" : "Modify database home storage",
  "updatedTime" : "August 04, 2021 22:26:02 PM CEST"
}
[root@dbi-oda-x8 ~]# odacli describe-job -i bec8b73f-5537-4b59-87e9-bb780edf38d1

Job details                                                      
----------------------------------------------------------------
                     ID:  bec8b73f-5537-4b59-87e9-bb780edf38d1
            Description:  Modify database home storage
                 Status:  Success
                Created:  August 4, 2021 10:26:02 PM CEST
                Message:  

Task Name                                Start Time                          End Time                            Status    
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Resizing database home storage           August 4, 2021 10:26:02 PM CEST     August 4, 2021 10:26:02 PM CEST     Success   

[root@dbi-oda-x8 ~]# odacli list-dbhome-storages

============================================================================================================= 
ID                                     Node Description          Disk Group Volume      Size(GB)   Status     
-------------------------------------- ---- -------------------- ---------- ----------- ---------- ----------
3e5b27c0-f021-4cc8-9c4d-a68362aed23b   0    ORACLE_HOME          DATA       orahome_sh  40         CONFIGURED
a8fa8109-d8ec-4a4c-84f4-53b07661dc0f   0    ORACLE_BASE          DATA       odabase_n0  10         CONFIGURED
============================================================================================================= 

[root@dbi-oda-x8 ~]# odacli describe-dbhome-storage -i 3e5b27c0-f021-4cc8-9c4d-a68362aed23b

ORACLE_HOME storage details:
================================================================
                     ID: 3e5b27c0-f021-4cc8-9c4d-a68362aed23b
                  State: CONFIGURED
                Created: July 29, 2021 9:33:24 AM CEST
                Updated: August 4, 2021 10:26:02 PM CEST

 Volume Details
 --------------
                   Name: orahome_sh
             Disk Group: DATA
            Description: ORACLE_HOME
            Node Number: 0
        Allocated Space: 40.0 GB
             Used Space: 12.24 GB
             Free Space: 27.75 GB
               Location: /u01/app/odaorahome

 DiskGroup Details
 -----------------
                   Name: DATA
        Allocated Space: 4.65 TB
             Used Space: 362.31 GB
             Free Space: 4.30 TB
================================================================

[root@dbi-oda-x8 ~]# df -h /u01/app/odaorahome
Filesystem               Size  Used Avail Use% Mounted on
/dev/asm/orahome_sh-250   40G   13G   28G  31% /u01/app/odaorahome
[root@dbi-oda-x8 ~]# 

Creating a new ORACLE_HOME is created on the dbhome-storage on ACFS:

[root@dbi-oda-x8 ~]# odacli list-dbhomes

ID                                       Name                 DB Version                               Home Location                                 Status    
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
e36a3f2f-22f8-4ff0-9935-9a4943f51349     OraDB19000_home1     19.11.0.0.210420                         /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1 CONFIGURED

[root@dbi-oda-x8 ~]# odacli create-dbhome -v 19.11.0.0.210420

Job details                                                      
----------------------------------------------------------------
                     ID:  aac4de69-bfde-496e-ac53-9f02ebcf36c2
            Description:  Database Home OraDB19000_home2 creation with version :19.11.0.0.210420
                 Status:  Created
                Created:  August 4, 2021 10:29:58 PM CEST
                Message:  Create Database Home

Task Name                                Start Time                          End Time                            Status    
---------------------------------------- ----------------------------------- ----------------------------------- ----------

[root@dbi-oda-x8 ~]# odacli list-dbhomes

ID                                       Name                 DB Version                               Home Location                                 Status    
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
e36a3f2f-22f8-4ff0-9935-9a4943f51349     OraDB19000_home1     19.11.0.0.210420                         /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1 CONFIGURED
9cc87345-67a5-41ae-b7b9-4c0c9f2a8be7     OraDB19000_home2     19.11.0.0.210420                         /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_2 CONFIGURED

[root@dbi-oda-x8 ~]# odacli describe-dbhome -i 9cc87345-67a5-41ae-b7b9-4c0c9f2a8be7
DB Home details                                                   
----------------------------------------------------------------
                     ID: 9cc87345-67a5-41ae-b7b9-4c0c9f2a8be7
                   Name: OraDB19000_home2
                Version: 19.11.0.0.210420
          Home Location: /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_2
                 Status: CONFIGURED
                Created: August 4, 2021 10:29:58 PM CEST
       Database Edition: SE
[root@dbi-oda-x8 ~]# 

Out of place patching

By having much more space for ORACLE_HOMEs, patching DB-Homes (odacli update-dbhome) is no longer happening in place. I.e. when new RDBMS clone files have been loaded in the repository and you run odacli update-dbhome a new ORACLE_HOME with the new version is created and the databases moved to the new ORACLE_HOME. That makes the whole patching process much more stable, because going back to the previous ORACLE_HOME is possible in case of an error.

Let’s work together

Ready to operate at
the next level?

Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.

Clemens Bleile

Clemens Bleile

Clemens Bleile has more than 30 years of IT experience, including 13 years in Oracle Support and 15 years in Oracle Consulting. He specializes in Oracle Database performance tuning and highly available, cost-efficient database architecture design. He holds Oracle Certified Professional (11g, 12c) and Oracle Certified Expert for Performance Management and Tuning credentials. Prior to dbi services, he managed the EMEA Database Performance team at Oracle Global Customer Support Services. Clemens holds a Master's degree in Business Information Systems from the Fachhochschule Furtwangen, Germany.View Author posts

68 posts since February 2016

Most read in Oracle

The Oracle posts our readers open most: the all-time favourites, and what is trending right now.

Leave a Comment

Your email address will not be published. Required fields are marked *