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 :

--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
--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
--Manager Parameter file

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

[AshishAgarwal_GG]

Join my whatsapp channel for updates on upcoming batches and webinars on Oracle Goldengate. Also, I would be posting useful content over the channel. Do join it:

[AshishAgarwal_GG]

For Training and consulting requirement for Oracle Goldengate, Pls do fill out contact information form using below link:
Also u can directly reach out to me via below methods:
2. Call/whatsapp@[phone]