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:
1 2 3 4 5 6 7 8 | [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:
1 2 | [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:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | [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:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 | [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:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | [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.