Day 2 of 7 Week Learning Oracle Goldengate (Installation, Download and Options to install OGG)

This is Day 2 of 7 week learning Oracle Goldengate Classic Architecture session coducted on 10th Aug 2024. Below are the notes from the session:

In Day 2 of Oracle GOldengate Classic Architecture weekend training batch we discussed about below:
Recap of Oracle Goldengate Classic Architecture 19c Session 2:

1. The Goldengate training VM Has 12.2 Database and 19C Binaries are present in /home/oracle/softwares
2. For Goldengate binaries download, Before download and install Install , make a note of below
Source : DB Type , Version , Platform
Target : DB Type , Version , Platform
A.
1.Before you proceed with download and installation , always Check the certification matrix
--Follow the instructions to download the GG from OTN
--Check for system requirement and supported platform for oracle goldengate version we are installing use link :
https://www.oracle.com/middleware/tec...

--After copying the Software , invoke the runInstaller
2. Before proceeding with installation u need to define location where to install. You may install GG in:
A. Seperate mount point:
B. Existing mount point

C. To consider how much space u need for installation, Understand the requirement. Do Research and design

Hardware requirements:
1. CPUs- 4 or 8 cores
2. Space requirement/mount point size- Whether u want to add new mount point (/goldengate) or use exising mount point(/u01)
Space Calculation:
30/60 days day wise archive log generation.
20GB
1 GB
100 MB
100 GB
Average of 7 days highest archive log generation -25 GB*7=175 GB *2=350-500 GB of space
3. Which OS user to use to install Goldengate
(oracle or any other user ggadmin/gguser)
DBAs -oracle
Goldengate and DBA responsiblities are seggreagted then - gguser/ggadmin (oinstall group)

3. Below are the options available to Install GG:
--GUI Installation
--Silent Installation –
./runInstaller -silent -responseFile /home/oracle/Downloads/ggate/fbo_ggs_Linux_x64_shiphome/Disk1
/response/oggcore.rsp
--Silent installation , You can use the response file
--You need to have Different GG install for Different versions of the Database
GGSCI is the command to invoke the GG
--Go to GG home
--execute "./ggsci"
--To see all process in GG
--info all
J. Manager process is default for gg install

--Only one manager process for each GG install
--All parameter file folder
--$GG_HOME/dirprm
--Create directories in GG
--create subdirs
--"dirpcs" is the folder for all the process with running in GG
--"dirrpt" stores all the reports files
--if you restart the process new report file generates
--ggserr.log file is the log for GG , like alert log for Database
--Manager Parameter file
--mgr.parms

K. Manager Process
--Purpose is to manage all the GG resources
--differnt commands manager process :
--info all -- to gett all details
--edit params mgr -- Edit manager parameters
--view params mgr -- view teh manager parameters
--info mgr -- Manager info
--start mgr -- start the manager
--stop mgr -- stop the manger

L. There are total 3 processes involved in GG replication process (Classic Architecture)
Capture or Extract process
Pump process
Delivery or Replicat process
We will be configuring these process for setting up Oracle GG replication

Oracle GG installed in source and target. (Classis Architecture)
Source GG installation location - /u01/app/oracle/product/ogg_src
Target GG installation location - /u01/app/oracle/product/ogg_trg
We created database in multitenant architecture
SOURCE
Container database - OGGDB1
Pluggable database - PDB1

TARGET
Container database - OGGDB2
Pluggable database – PDB2
4. Below are the Options to Install Goldengate
--Install GG on ggate1 for local capture and on ggate2 for local apply
--install GG on ggate1 which will capture the data locally from ggate 1 DB and apply to ggate2 DB remotely
--Install GG on ggate2 which will capture the data remotely from ggate 1 DB and apply to ggate2 DB locally
--Install GG on intermediate server (eg ggate3) which will capture the remotely from ggate1 and apply the data remotely on ggate2

--Install GG on intermediate server (eg ggate3) which will capture the remotely from ggate1 but install GG on ggate2 as well for local apply

--Install GG on ggate1 which will capture the data locally from ggate1 but install GG on intermediate server (eg ggate3) which will apply data remotely to ggate2
Prior to setup there are certain pre-requisites we need to meet to setting up Oralce GG at Source and Target level.
Oracle GG already installed in source and target. (Classis Architecture)
Source GG installation location - /data/app/oracle/product/gg_src
Target GG installation location - /data/app/oracle/product/gg_trg
We created database in multitenant architecture
SOURCE
Container database - OGGDB1
-Pluggable database - PDB1
Created GGTRAINING1 under PDB1