Installing Oracle Home need Oracle Software and manual work involved. Whereas in ODA we have to add the Oracle Home Binary Image and later we can use ODACLI to install Oracle Home with one single command.
List and Describe the current Installed Oracle Homes
[root@oda-x1 ~]# odacli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
0e68fa05-7b74-4a9a-a562-dabf45e42c44 OraDB12102_home18 12.1.0.2.180717 /u01/app/oracle/product/12.1.0.2/dbhome_18 Configured
[root@oda-x1 ~]# odacli describe-dbhome -i 0e68fa05-7b74-4a9a-a562-dabf45e42c44
DB Home details
----------------------------------------------------------------
ID: 0e68fa05-7b74-4a9a-a562-dabf45e42c44
Name: OraDB12102_home18
Version: 12.1.0.2.180717
Home Location: /u01/app/oracle/product/12.1.0.2/dbhome_18
Status: Configured
Created: March 27, 2021 12:07:45 PM CDT
Database Edition: EE
[root@oda-x1 ~]#We can see only one Oracle Home was installed, Now we will install another Oracle Home using the preloaded image of ODA.
[root@oda-x1 ~]# odacli create-dbhome -v 12.1.0.2.180717
Job details
----------------------------------------------------------------
ID: 235bb806-500d-462b-9209-677ada213b95
Description: Database Home OraDB12102_home19 creation with version :12.1.0.2.180717
Status: Created
Created: April 5, 2021 10:27:45 AM CDT
Message: Create Database Home
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
[root@oda-x1 ~]#After initiating the RDBMS Home installation we can view the running jobs as below
[root@oda-x1 ~]# odacli list-jobs |grep Running
235bb806-500d-462b-9209-677ada213b95 Database Home OraDB12102_home19 creation with version :12.1.0.2.180717 April 5, 2021 10:27:45 AM CDT Running
[root@oda-x1 ~]#Please note this installation of Oracle Home will be done on the both nodes. Now let’s review the job status and current task.
[root@oda-x1 ~]# odacli describe-job -i 235bb806-500d-462b-9209-677ada213b95
Job details
----------------------------------------------------------------
ID: 235bb806-500d-462b-9209-677ada213b95
Description: Database Home OraDB12102_home19 creation with version :12.1.0.2.180717
Status: Running
Created: April 5, 2021 10:27:45 AM CDT
Message: Create Database Home
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance April 5, 2021 10:27:45 AM CDT April 5, 2021 10:27:45 AM CDT Success
Validating dbHome available space April 5, 2021 10:27:46 AM CDT April 5, 2021 10:27:46 AM CDT Success
Validating dbHome available space April 5, 2021 10:27:46 AM CDT April 5, 2021 10:27:46 AM CDT Success
Creating DbHome Directory April 5, 2021 10:27:46 AM CDT April 5, 2021 10:27:46 AM CDT Success
Extract DB clones April 5, 2021 10:27:46 AM CDT April 5, 2021 10:27:46 AM CDT Running
[root@oda-x1 ~]#
From the above output we can see the prerequisites are completed and now extracting the RDBMS gold image. Let’s run the same command again to review the latest status
[root@oda-x1 ~]# odacli describe-job -i 235bb806-500d-462b-9209-677ada213b95
Job details
----------------------------------------------------------------
ID: 235bb806-500d-462b-9209-677ada213b95
Description: Database Home OraDB12102_home19 creation with version :12.1.0.2.180717
Status: Success
Created: April 5, 2021 10:27:45 AM CDT
Message: Create Database Home
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance April 5, 2021 10:27:45 AM CDT April 5, 2021 10:27:45 AM CDT Success
Validating dbHome available space April 5, 2021 10:27:46 AM CDT April 5, 2021 10:27:46 AM CDT Success
Validating dbHome available space April 5, 2021 10:27:46 AM CDT April 5, 2021 10:27:46 AM CDT Success
Creating DbHome Directory April 5, 2021 10:27:46 AM CDT April 5, 2021 10:27:46 AM CDT Success
Extract DB clones April 5, 2021 10:27:46 AM CDT April 5, 2021 10:29:55 AM CDT Success
Clone Db home April 5, 2021 10:29:55 AM CDT April 5, 2021 10:31:09 AM CDT Success
Enable DB options April 5, 2021 10:31:09 AM CDT April 5, 2021 10:31:25 AM CDT Success
Run Root DB scripts April 5, 2021 10:31:25 AM CDT April 5, 2021 10:31:25 AM CDT Success
Removing ssh keys April 5, 2021 10:31:31 AM CDT April 5, 2021 10:31:33 AM CDT Success
[root@oda-x1 ~]#All the steps were performed successfully, also let’s review the oracle inventory status as well.
[root@oda-x1 ContentsXML]# pwd
/u01/app/oraInventory/ContentsXML
[root@oda-x1 ContentsXML]# cat inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.1.0.2.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraGrid180" LOC="/u01/app/18.0.0.0/grid" TYPE="O" IDX="1" CRS="true"/>
<HOME NAME="OraDB12102_home18" LOC="/u01/app/oracle/product/12.1.0.2/dbhome_18" TYPE="O" IDX="2">
<NODE_LIST>
<NODE NAME="oda-x1"/>
<NODE NAME="oda-x1"/>
</NODE_LIST>
</HOME>
<HOME NAME="OraDB12102_home19" LOC="/u01/app/oracle/product/12.1.0.2/dbhome_19" TYPE="O" IDX="3">
<NODE_LIST>
<NODE NAME="oda-x2"/>
<NODE NAME="oda-x2"/>
</NODE_LIST>
</HOME>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
[root@oda-x1 ContentsXML]#
We can see from the inventory the new home was updated. Using single command able to install Oracle Home successfully on both nodes.
