Wednesday, February 3, 2021


 

Hello All,

In this video, We're going to discuss about step by step procedure used to clone an Oracle 19c database software ORACLE_HOME. 


As a one-time task, we use the new Oracle 19c option –createGoldImage to create a ‘master’ copy of the Oracle 19c database software (this will include April 2020 RU patch).


The generated zip file is then copied to the target servers and then extracted in the target ORACLE_HOME directory.


The note describes the ‘silent’ method as well as using the OUI to set up the Oracle 19c database software.


Step1: Create the RDBMS Binary Gold Image:


 $ORACLE_HOME/runInstaller -createGoldImage -destinationLocation /u03/softwares -silent


Step2: Copy the zip file to the target server: 


scp -rp Oralce 19c_Gold_Image.zip oracle@srlabgg2:/u03/softwares

 

Step3: Create the directory structure for the ORACLE_HOME on the target server: 


mkdir -p /u01/app/oracle/product/19.3.0.0/db_2


Step4: Unzip the file:


mv 19c_Jan_PSU_Gold_Image.zip /u01/app/oracle/product/19.3.0.0/db_2


cd /u01/app/oracle/product/19.3.0.0/db_2


unzip Oracle 19c_Gold_Image.zip


Step5: Oracle Universal Installer (OUI) Method:


./runInstaller


Silent Method:


$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/db_2

$ export ORA_INVENTORY=/u01/app/oracle/oraInventory

$ export ORACLE_BASE=/u01/app/oracle


./runInstaller -ignorePrereq -waitforcompletion -silent \

ORACLE_BASE=${ORACLE_BASE} \

> -responseFile ${ORACLE_HOME}/install/response/db_install.rsp \

> oracle.install.option=INSTALL_DB_SWONLY \

> UNIX_GROUP_NAME=dba \

> INVENTORY_LOCATION=${ORA_INVENTORY} \

oracle.install.db.OSDGDBA_GROUP=dba \

> ORACLE_HOME=${ORACLE_HOME} \

oracle.install.db.OSKMDBA_GROUP=dba \

> ORACLE_BASE=${ORACLE_BASE} \

> oracle.install.db.InstallEdition=EE \

> oracle.install.db.OSDBA_GROUP=dba \

> oracle.install.db.OSOPER_GROUP=dba \

> oracle.install.db.OSBACKUPDBA_GROUP=dba \

> oracle.install.db.OSDGDBA_GROUP=dba \

> oracle.install.db.OSKMDBA_GROUP=dba \

> oracle.install.db.OSRACDBA_GROUP=dba


Hope this helps!

Ramesh.









Post a Comment: