On October 31, 2019, I blogged about How To Use CreateGoldImage For Cloning In 19c.
CreateGoldImage seems like a nice new feature; however, it’s also very buggy.
Here are a few bugs:
I received a suggestion to use tar to clone Grid Home; however, I was uncertain if it would work.
Why would Oracle create a new process for CreateGoldImage when traditional tar works?
Out of curiosity, I decided to test this by creating tarball for GRID_HOME from 19.8 RAC.
Use the tarball to upgrade Oracle Restart 12.2 to 19.8
Source: 19c Oracle RAC is located at /u01/app/126.96.36.199/grid
### Create tarball for 19.8 GRID_HOME from RAC instance:
[[email protected] grid]# pwd /u01/app/19.0.0/grid [[email protected] grid]# time tar -cvzpf /tmp/grid19.8_clone.tar.gz . > /tmp/clone_grid19.8.log ; echo $?
### Transfer tarball to target.
TARGET: 19c Oracle Restart is located at /u01/app/oracle/188.8.131.52/grid
I know what you are thinking. Why is GRID_HOME at two different locations?
The two vagrant boxes I have used to create test cases were created by two different individuals.
### Review current patch for 12.2 Oracle Restart:
[[email protected] ~]$ $ORACLE_HOME/OPatch/opatch lspatches 27144050;Tomcat Release Update 184.108.40.206.0(ID:171023.0830) (27144050) 26839277;DBWLM RELEASE UPDATE 220.127.116.11.0(ID:170913) (26839277) 28163235;ACFS JUL 2018 RELEASE UPDATE 18.104.22.168.180717 (28163235) 28163190;OCW JUL 2018 RELEASE UPDATE 22.214.171.124.180717 (28163190) 28163133;Database Jul 2018 Release Update : 126.96.36.199.180717 (28163133) OPatch succeeded.
### Copy tarball to /u01/app/oracle/188.8.131.52.
[[email protected] 184.108.40.206]$ time cp -fv /media/swrepo/grid19.8_clone.tar.gz . ; echo $? ‘/media/swrepo/grid19.8_clone.tar.gz’ -> ‘./grid19.8_clone.tar.gz’ [[email protected] 220.127.116.11]$ ls -l total 7015760 -rwxr-xr-x 1 grid oinstall 7184131622 Aug 15 22:30 grid19.8_clone.tar.gz
### Unzip tarball to /u01/app/oracle/18.104.22.168
[[email protected] 22.214.171.124]$ time gunzip grid19.8_clone.tar.gz [[email protected] 126.96.36.199]$ ls -l total 13542216 -rwxr-xr-x 1 grid oinstall 13867223040 Aug 15 22:30 grid19.8_clone.tar
### Create directory for GRID_HOME – /u01/app/oracle/188.8.131.52/grid
[[email protected] 184.108.40.206]$ mkdir grid
### Untar to GRID_HOME – /u01/app/oracle/220.127.116.11/grid
[[email protected] 18.104.22.168]$ cd grid [[email protected] grid]$ time tar xf ../grid19.8_clone.tar . ; echo $?
### Upgrade 12.2 Oracle HAS to 19.8 using 19.8 tarball (GUI Method):
[[email protected] grid]$ ./gridSetup.sh
### Verify Oracle Restart is 19.8:
[[email protected] grid]$ $ORACLE_HOME/OPatch/opatch lspatches 31335188;TOMCAT RELEASE UPDATE 22.214.171.124.0 (31335188) 31305087;OCW RELEASE UPDATE 126.96.36.199.0 (31305087) 31304218;ACFS RELEASE UPDATE 188.8.131.52.0 (31304218) 31281355;Database Release Update : 184.108.40.206.200714 (31281355) OPatch succeeded. [[email protected] grid]$
In conclusion, there is an option to use tarball if CreateGoldImage does not work; thereby avoiding creating a ticket with Oracle support.
Please note: I am unaware whether using tarball is supported — it would be best to check with Oracle support.