Create Oracle Database 11gr2 home on ODA X5-2 with virtualization

This doc describe the steps to create additional Oracle database home with different version.

we are creating Oracle database 11gr2 home. Oracle database 12c is the default database home.


1. Download the End-User RDBMS Clone files from MOS 888888.1

I have downloaded below one.

End User RDBMS Clone file for 11.2.0.4.161018 Patch 17770873

2. Transfer the End user RDBMS clone to ODA. Use Winscp.

3. Check the existing database homes on the ODA.

[root@ bin]# oakcli show dbhomes
Oracle Home Name      Oracle Home version                  Home Location
----------------      -------------------                  ------------
OraDb12102_home1      12.1.0.2.161018(24006101,23854735)  /u01/app/oracle/product/12.1.0.2/dbhome_1

4. Unpack the patch bundle p17770873_121290_Linux-x86-64.zip using the following oakcli command on first node as root user

cd /opt/oracle/oak/bin

[root@ bin]# oakcli unpack -package /tmp/p17770873_121290_Linux-x86-64.zip
Unpacking will take some time,  Please wait...
Successfully unpacked the files to repository.

5. Create the home with new db version 11.2.0.4.161018

[root@ABC1x5-2 bin]# oakcli create dbhome -version 11.2.0.4.161018
INFO: 2017-03-07 09:53:26: Please check the logfile  '/opt/oracle/oak/log/ABC1x5-2/tools/12.1.2.9.0/createdbhome_929                                                 96.log' for more details

Please enter the 'root'  password :
Please re-enter the 'root' password:

Please enter the 'SYSASM'  password : (During deployment we set the SYSASM password to 'welcome1'):
Please re-enter the 'SYSASM' password:
INFO: 2017-03-07 09:54:08: Installing a new Home : OraDb11204_home1 at /u01/app/oracle/product/11.2.0.4/dbhome_1
INFO   : Logging all actions in the file /opt/oracle/oak/onecmd/tmp/ABC1x5-2-20170307095412.log and traces in the fi                                                 le /opt/oracle/oak/onecmd/tmp/ABC1x5-2-20170307095412.trc
INFO   : Loading the configuration file /opt/oracle/oak/onecmd/create_database.params...
INFO   : Creating the node list files...
INFO   : Setting up ssh for root...
INFO   : Setting up SSH across the Private Network...
............Completed
INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.27 /root/DoAllcmds.sh
INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.28 /root/DoAllcmds.sh
INFO   : Background process 97409 (node: 192.168.16.27) gets done with the exit code 0
INFO   : Background process 97473 (node: 192.168.16.28) gets done with the exit code 0
INFO   : Setting up SSH completed successfully
INFO   : Running the command /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.28:/opt/oracle/oak/onecmd -                                                 -exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm to sync directory</opt/oracle/oak/onecmd> on n                                                 ode <192.168.16.28>
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.28:/opt/oracle/oak/onecmd --exclude=*zip --                                                 exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0

............Completed
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /root/DoAllcmds.sh
INFO   : Background process 98681 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /root/DoAllcmds.sh
INFO   : Background process 98751 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095457.sh
INFO   : Background process 98924 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095457.sh
INFO   : Background process 99055 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Setting up SSH for user oracle...
...INFO   : checking nodes in /opt/oracle/oak/onecmd/tmp/db_nodes...
...
SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO   : Checking SSH setup for user (oracle) on nodes in /opt/oracle/oak/onecmd/tmp/db_nodes...
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC1x5-2 /opt/oracle/oak                                                 /onecmd/tmp/DoAllcmds-20170307095523.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095523.sh
INFO   : Background process 1000 (node: ABC1x5-2) gets done with the exit code 0
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC2x5-2 /opt/oracle/oak                                                 /onecmd/tmp/DoAllcmds-20170307095523.sh
INFO   : Background process 1061 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Creating DB homes on the nodes ABC1x5-2 ABC2x5-2....
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095524.sh
INFO   : Background process 1153 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095524.sh
INFO   : Background process 1214 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095524.sh
INFO   : Background process 1390 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095524.sh
INFO   : Background process 1462 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Running /usr/bin/scp /opt/oracle/oak/pkgrepos/orapkgs/DB/11.2.0.4.161018/Base/db112.tar.gz root@192.168.16.28:                                                 /opt/oracle/oak/pkgrepos/orapkgs/DB/11.2.0.4.161018/Base/db112.tar.gz to copy DB clone to the other node...
SUCCESS: Ran /usr/bin/scp /opt/oracle/oak/pkgrepos/orapkgs/DB/11.2.0.4.161018/Base/db112.tar.gz root@192.168.16.28:/opt                                                 /oracle/oak/pkgrepos/orapkgs/DB/11.2.0.4.161018/Base/db112.tar.gz and it returned: RC=0

INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095541.sh
INFO   : Background process 2505 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095541.sh
INFO   : Background process 2577 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095542.sh
INFO   : Background process 2726 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095542.sh
INFO   : Background process 2798 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Restoring the copy of DB home on all nodes...
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC1x5-2 /opt/oracle/oak                                                 /onecmd/tmp/DoAllcmds-20170307095543.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095543.sh
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC2x5-2 /opt/oracle/oak                                                 /onecmd/tmp/DoAllcmds-20170307095543.sh
INFO   : Background process 2941 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Background process 3015 (node: ABC2x5-2) gets done with the exit code 0
INFO   : INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095644                                                 .sh
Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095644.sh
INFO   : Background process 6243 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Background process 6316 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Cloning and relinking RAC home
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/fuser_mv.sh
INFO   : Background process 6470 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/fuser_mv.sh
INFO   : Background process 6541 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Running clone.pl on RAC home. Look at /opt/oracle/oak/onecmd/tmp/racclonepl.sh-20170307095412-log for more det                                                 ails
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/racclonepl.sh
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/racclonepl.sh
INFO   : Background process 6746 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Background process 6685 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Runing root.sh on all nodes...
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095756.sh
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307095756.sh
INFO   : Background process 13152 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Background process 13217 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Removing temporary templates
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/remove_temp.sh
INFO   : Background process 13421 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/remove_temp.sh
INFO   : Background process 13482 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Running asmgid
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC1x5-2 /opt/oracle/oak                                                 /onecmd/tmp/set_asm_gid.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/set_asm_gid.sh
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC2x5-2 /opt/oracle/oak                                                 /onecmd/tmp/set_asm_gid.sh
INFO   : Background process 13644 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Background process 13715 (node: ABC2x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/fuser_mv_bk.sh
INFO   : Background process 14141 (node: ABC1x5-2) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/fuser_mv_bk.sh
INFO   : Background process 14211 (node: ABC2x5-2) gets done with the exit code 0
SUCCESS: 2017-03-07 09:58:01: Successfully created the Database Home : OraDb11204_home1
INFO   : Resecuring the environment... ABC1x5-2 ABC2x5-2
INFO   : Removing the SSH setup for root...

INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 chmod 751 /opt/oracle/oak/onecmd/tmp

INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 chmod 751 /opt/oracle/oak/onecmd/tmp
INFO   : Running as root: /usr/bin/ssh -l root ABC2x5-2 /bin/rm -rf /root/.ssh
INFO   : Running as root: /usr/bin/ssh -l root ABC1x5-2 /bin/rm -rf /root/.ssh



6. Verify the newly created database home.


[root@ bin]# oakcli show dbhomes

Oracle Home Name      Oracle Home version                  Home Location
----------------      -------------------                  ------------
OraDb11204_home1      11.2.0.4.161018(24006111,23054319)  /u01/app/oracle/product/11.2.0.4/dbhome_1
OraDb12102_home1      12.1.0.2.161018(24006101,23854735)  /u01/app/oracle/product/12.1.0.2/dbhome_1

References:- READme and ODA Admin guide.

Cheers.