Monday, June 19, 2023

Setup Oracle Golden Gate 21.3 Microservice software in silent mode using response file and command line argument

Setup Golden Gate Microservice software in silent mode using response file and command line argument


Setup environment details:

Hostname: vcentos79-oracle-sby1
IP: 192.168.194.6
Is it db server: Yes
DB Name: DBCASLNT
CDB: NO
DB Version: 19c
OS version: RHEL7.9

Please refer to the following blog for PreReqs,binary download & OS certification info.
blog url: Oracle Golden Gate Setup using GUI

OGG_SOFTWARE unzip location:

ls -ld /u01/app/software/21.3.0_oggsc [will fail saying path not found]
mkdir -p /u01/app/software/21.3.0_oggsc
ls -ld /u01/app/software/21.3.0_oggsc [path will be there now]

Unlike oracle home, the Oracle Golden Gate Software still needs to be copied using runInstaller. In case of ORACLE_HOME, the download is a golden image, where we unzip the software into the target ORACLE_HOME itself.

OGG_HOME:

ls -ld /u01/app/oracle/product/21.3.0/ogg_home_1 [will fail saying path not found]
mkdir -p /u01/app/oracle/product/21.3.0/ogg_home_1
ls -ld /u01/app/oracle/product/21.3.0/ogg_home_1 [path will be there now]

Step Unzip the GG binary into the OGG_SOFTWARE location:

[oracle@vcentos79-oracle-sby1 21.3.0_oggsc]$ unzip /vagrant/213000_fbo_ggs_Linux_x64_Oracle_services_shiphome.zip
Archive:  /vagrant/213000_fbo_ggs_Linux_x64_Oracle_services_shiphome.zip
   creating: fbo_ggs_Linux_x64_Oracle_services_shiphome/
...
  inflating: fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/install/.oui
  inflating: fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/runInstaller
  inflating: OGG-21.3.0.0-README.txt
  inflating: oracle-goldengate-release-notes_21.3.pdf
[oracle@vcentos79-oracle-sby1 21.3.0_oggsc]$ pwd
/u01/app/software/21.3.0_oggsc
[oracle@vcentos79-oracle-sby1 21.3.0_oggsc]$

Let us kick off the install in silent mode [pls note, we are using the default response file only, no customization, we are supplying all the input variables in command line]

Response file presence validation:
[oracle@vcentos79-oracle-sby1 Disk1]$ ls -altr /u01/app/software/21.3.0_oggsc/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/response/oggcore.rsp
-rw-rw-r--. 1 oracle oinstall 3440 Jul 29  2021 /u01/app/software/21.3.0_oggsc/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/response/oggcore.rsp

Go to the runInstaller path:
[oracle@vcentos79-oracle-sby1 Disk1]$ pwd
/u01/app/software/21.3.0_oggsc/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1

Launch runInstaller:
Command:
./runInstaller -silent -showProgress -waitForCompletion \
-responseFile /u01/app/software/21.3.0_oggsc/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/response/oggcore.rsp \
INSTALL_OPTION=ORA21c \
SOFTWARE_LOCATION=/u01/app/oracle/product/21.3.0/ogg_home_1 \
START_MANAGER=false \
INVENTORY_LOCATION=/u01/app/oraInventory \
UNIX_GROUP_NAME=dba


Actual command output:
[oracle@vcentos79-oracle-sby1 Disk1]$ ./runInstaller -silent -showProgress -waitForCompletion \
> -responseFile /u01/app/software/21.3.0_oggsc/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/response/oggcore.rsp \
> INSTALL_OPTION=ORA21c \
> SOFTWARE_LOCATION=/u01/app/oracle/product/21.3.0/ogg_home_1 \
> START_MANAGER=false \
> INVENTORY_LOCATION=/u01/app/oraInventory \
> UNIX_GROUP_NAME=dba
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB.   Actual 3710 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3071 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2023-06-18_04-39-46PM. Please wait ...You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2023-06-18_04-39-46PM.log
Prepare in progress.
..................................................   10% Done.
Prepare successful.
Copy files in progress.
..................................................   53% Done.
..................................................   58% Done.
..................................................   64% Done.
..................................................   70% Done.
..................................................   75% Done.
..................................................   80% Done.
..................................................   85% Done.
..................................................   91% Done.
Copy files successful.
Link binaries in progress.
Link binaries successful.
Setup files in progress.
..................................................   95% Done.
..................................................   96% Done.
..................................................   97% Done.
..................................................   99% Done.
Setup files successful.
Setup Inventory in progress.
Setup Inventory successful.
..................................................   95% Done.
Successfully Setup Software.
..................................................   100% Done.
Finish Setup successful.
The installation of Oracle GoldenGate Services was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2023-06-18_04-39-46PM.log' for more details.
[oracle@vcentos79-oracle-sby1 Disk1]$

Outcome: The installation of Oracle GoldenGate Services was successful.

Logfile Message:
INFO: Executing command find /u01/app/oraInventory/logs -type f -exec chmod  -f 0640 {} ";"
INFO: Current Inventory:
        Oracle Home: OraDB19Home1
                This Oracle Home has not been changed in this session.
        Oracle Home: OraGI19Home1
                This Oracle Home has not been changed in this session.
        Oracle Home: OraHome1
                Java Development Kit 1.8.0.291.09
                oracle.swd.oui.core.min 12.2.0.9.0
                Installer SDK Component 12.2.0.9.0
                Oracle One-Off Patch Installer 12.2.0.1.17
                Oracle Universal Installer 12.2.0.9.0
                Oracle GoldenGate Services for Oracle Database 21c and lower supported versions 21.1.0.0.0
                oracle.swd.commonlogging 13.3.0.0.0
                oracle.swd.opatchautodb 12.2.0.1.5
                Oracle GoldenGate Services 21.1.0.0.0
INFO: OiicSaveInvWCCE:After saving the inventory. This is an Install session.
INFO: OiicSaveInvWCCE:After saving the inventory. The platform is unix.
INFO: OiicSaveInvWCCE:After saving the inventory. The location of root.sh is /u01/app/oracle/product/21.3.0/ogg_home_1/root.sh
INFO: Setting permission on dir : /u01/app/oracle/product/21.3.0/ogg_home_1/inventory
INFO: Executing command find /u01/app/oracle/product/21.3.0/ogg_home_1/inventory -type d -exec chmod  -f 0750 {} ";"
INFO: Executing command find /u01/app/oracle/product/21.3.0/ogg_home_1/inventory -type f -exec chmod  -f 0640 {} ";"
INFO: InstallProgressMonitor: Completed phase 16
INFO: SaveInvWCCE JRE files in Scratch :0
...
INFO: Adding iterator oracle.sysman.oii.oiif.oiifw.OiifwRootShWCDE
INFO:
*** End of Installation Page***
The installation of Oracle GoldenGate Services was successful. <<<<<<<<<<<<<< message
INFO: Updating the global context
INFO: Path To 'globalcontext.xml' = /u01/app/oracle/product/21.3.0/ogg_home_1/install/chainedInstall/globalcontext
INFO: Since operation was successful, move the current OiicAPISessionDetails to installed list
INFO: Number of root scripts to be executed = 0 <<<<<<<<<<<<<<< No need to excute root.sh
INFO: isSuccessfullInstallation: true
INFO: isSuccessfullRemoteInstallation: true
..
INFO: Exit Status is 0
INFO: Shutdown Oracle GoldenGate


Binary validation:

[oracle@vcentos79-oracle-sby1 logs]$ cd /u01/app/oracle/product/21.3.0/ogg_home_1
[oracle@vcentos79-oracle-sby1 ogg_home_1]$ pwd
/u01/app/oracle/product/21.3.0/ogg_home_1
[oracle@vcentos79-oracle-sby1 ogg_home_1]$ ls -altr
total 16
drwxr-xr-x.  3 oracle oinstall   24 Jun 18 16:31 ..
drwxr-xr-x.  3 oracle oinstall   20 Jun 18 16:40 diagnostics
drwxr-xr-x.  3 oracle oinstall   19 Jun 18 16:40 srvm
drwxr-xr-x.  2 oracle oinstall   26 Jun 18 16:40 deinstall
drwxr-xr-x.  8 oracle oinstall 4096 Jun 18 16:40 lib
drwxr-xr-x.  2 oracle oinstall  127 Jun 18 16:40 jlib
drwxr-xr-x.  2 oracle oinstall   63 Jun 18 16:40 include
drwxr-xr-x.  7 oracle oinstall  247 Jun 18 16:40 jdk
drwxr-xr-x. 13 oracle oinstall 4096 Jun 18 16:40 OPatch
drwxr-xr-x.  2 oracle oinstall 4096 Jun 18 16:40 bin
drwxr-xr-x.  8 oracle oinstall  226 Jun 18 16:40 oui
-rw-r-----.  1 oracle oinstall  127 Jun 18 16:40 oraInst.loc
drwxr-x---. 13 oracle oinstall  218 Jun 18 16:40 inventory
drwxr-xr-x.  3 oracle oinstall   28 Jun 18 16:41 install
drwxr-xr-x.  3 oracle oinstall   17 Jun 18 16:41 cfgtoollogs
drwxr-xr-x. 15 oracle oinstall  209 Jun 18 16:41 .
[oracle@vcentos79-oracle-sby1 ogg_home_1]$

Before install:
/dev/mapper/appdata--vg-u01--lv       30G   14G   17G  46% /u01
after install:
[oracle@vcentos79-oracle-sby1 ogg_home_1]$ df -h .
Filesystem                       Size  Used Avail Use% Mounted on
/dev/mapper/appdata--vg-u01--lv   30G   16G   15G  51% /u01

[oracle@vcentos79-oracle-sby1 ogg_home_1]$ pwd
/u01/app/oracle/product/21.3.0/ogg_home_1
[oracle@vcentos79-oracle-sby1 ogg_home_1]$

2GB is consumed as expected by the OGG_HOME binary install.

So the silent install of Oracle Golden Gate Binary is done.
Let us now move forward with next step which is deploying Oracle Golden Gate Services in silent mode.

Thank you!

No comments:

Post a Comment

Flashback data archive steps

 Objective: Ways to track DML changes in a table Detailed objective: We should be able to track the changes in the table at any point in tim...