Creating Gold Image from existing installed software(GI HOME and Oracle HOME)

By -

 Consider a situation where you need to repeatedly install an already-installed software, which also has several applied patches, in an environment. Installing the software first and then applying all the patches can significantly increase installation time and make the process more complex. Oracle provides a solution for this: creating a Gold Image from the existing installed software (including applied patches).

Creating a Gold Image from installed software can accelerate reinstallations and simplify the installation process. In this article, we will explain how to create a Gold Image from GI HOME and Oracle HOME.

Creating Gold Image from Grid Infrastructure

To create a Gold Image from the GI Home, you can use the gridSetup.sh tool with the -createGoldImage parameter.

For example, by executing the following command, we create a Gold Image from Grid Infrastructure 19cR9. This way, for reinstalling GI 19cR9, there is no need to apply patch number 31750108 on top of GI 19cR3:

[root@node2 ~]# mkdir /GoldImage

[root@node2 ~]# chown -R grid.oinstall /GoldImage

 [grid@node2 ~]$  cd /grid/home/

[grid@node2 home]$ ./gridSetup.sh -createGoldImage -destinationLocation /GoldImage

Launching Oracle Grid Infrastructure Setup Wizard…
Press enter or click to view image in full size
Press enter or click to view image in full size
[grid@node2 GoldImage]$ ls –lh

-rw-r–r– 1 grid oinstall 5.1G Mar 28 11:53 grid_home_2021-03-28_11-46-45AM.zip

A Gold Image can also be created in silent mode:

[grid@node2 home]$  ./gridSetup.sh -createGoldImage -destinationLocation /GoldImage -silent

Launching Oracle Grid Infrastructure Setup Wizard…

Successfully Setup Software.

Gold Image location: /GoldImage/grid_home_2021-03-28_11-35-38AM.zip

When creating a Gold Image, log directories are skipped. It is also possible to exclude certain files, such as those used for patch rollback operations. This can be done with the parameter -exclFiles $GI_HOME/.patch_storage:

[grid@node2 home]$ ./gridSetup.sh -createGoldImage -destinationLocation /GoldImage -silent -exclFiles $GI_HOME/.patch_storage

Launching Oracle Grid Infrastructure Setup Wizard…

The Grid Infrastructure software installed through the above Gold Image includes the following patches:

[grid@node2 ~]$ /grid/home/OPatch/opatch lspatches

31780966;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31780966)

31773437;ACFS RELEASE UPDATE 19.9.0.0.0 (31773437)

31772784;OCW RELEASE UPDATE 19.9.0.0.0 (31772784)

31771877;Database Release Update : 19.9.0.0.201020 (31771877)

OPatch succeeded.

Creating a Gold Image from Oracle Database Software

Similarly, you can create a Gold Image from Oracle Database Software:

[oracle@node2 ~]$ cd /oracle/home/

[oracle@node2 home]$ ./runInstaller -createGoldImage -destinationLocation /GoldImage -silent

Launching Oracle Database Setup Wizard…

Successfully Setup Software.

Gold Image location: /GoldImage/db_home_2021-03-30_09-39-13AM.zip

[oracle@node2 home]$ ls -lh /GoldImage/db_home_2021-03-30_09-39-13AM.zip

-rw-r–r– 1 oracle oinstall 3.5G Mar 30 09:47 /GoldImage/db_home_2021-03-30_09-39-13AM.zip

Comments

Post a Comment

Popular posts from this blog

Oracle 23ai — Speed up IMPDP Using NOVALIDATE Constraints

By -
  When executing the   IMPDP   command, some operations do not support parallel execution. Creating constraints is one such operation. Oracle must validate the current data in the table before creating a constraint, which requires a full table scan for each validation. This process can be very time-consuming. Consider the following constraints: ALTER TABLE VAHID.MYTB ADD CONSTRAINT CHECK1 CHECK (col3 > 50 ); ALTER TABLE VAHID.MYTB ADD CONSTRAINT CHECK2 CHECK (col9 IN ( 5 , 15 )); We drop the  MYTB  table and recreate it using a dump file: SQL > drop table mytb; Table dropped. W -1 Processing object type TABLE_EXPORT / TABLE / TABLE_DATA W -1 . . imported "VAHID"."MYTB" 19 GB 337830912 rows in 83 seconds using external_table W -1 Processing object type TABLE_EXPORT / TABLE / CONSTRAINT / CONSTRAINT W -1 Completed 2 CONSTRAINT objects in 208 seconds As shown, creating the two constraints ta...
Read more

Staging Tables in Oracle 23ai

By -
  As you may know, using   staging tables   is a common practice in   Data Warehouse   environments, primarily during the data loading process into the   Warehouse Database . Typically, raw data received from   source databases   is first loaded into a temporary area, referred to as   staging tables . After cleansing inconsistent and invalid data and transforming it into a standard format, the cleaned data is stored in the final operational tables. In addition to initial data loading,   staging tables   are also used for updates and are often truncated before reuse. In   Oracle 23ai , a new minor feature has been introduced for this purpose, allowing users to create tables specifically designed as   staging tables . This is achieved by adding the   FOR STAGING   clause to the   CREATE TABLE   statement. Creating Staging Tables Using the   FOR STAGING   clause, staging tables can be created as ...
Read more

Boolean Data Type in Oracle ِDatabase 23ai

By -
Image
  Oracle introduced the Boolean data type in SQL with version 23ai (although this data type has existed in PL/SQL previously). With this feature, you can define table columns as Boolean during table creation. SQL > CREATE TABLE jadval1 (id NUMBER, is_accept BOOLEAN ); Table created You can also use the keyword  BOOL  instead of  BOOLEAN : SQL > CREATE TABLE jadval1 (id NUMBER, is_accept BOOL); Table created You can set default values for Boolean columns: SQL > CREATE TABLE table1 (id NUMBER, is_accept BOOL DEFAULT FALSE ); Table created To populate the  is_accept  column, you can use the three keywords:  TRUE ,  FALSE , and  NULL : SQL > insert into table1 values ( 1 , true ); 1 row inserted SQL > insert into table1 values ( 2 , null ); 1 row inserted SQL > insert into table1 values ( 3 , false ); 1 row inserted SQL > select * from table1; ID IS_ACCEPT ---------- ---------- ...
Read more