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.
![Thumbnail [60x60]](https://www.dbi-services.com/blog/wp-content/uploads/2022/11/CBL_web-min-min-scaled.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2022/08/JDU_web-min-scaled.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2022/08/ALA_web-min-scaled.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2024/02/XFG-web.jpg)
![Thumbnail [90x90]](https://www.dbi-services.com/blog/wp-content/uploads/2025/05/JDE_Web-1-scaled.jpg)