Initial load from Oracle to PostgreSQL Using GoldenGate
Hosts and databases used in this environment. Category Source Target Host srvdb01.localdomain srvdb02.localdomain IP Address 192.168.56.81 192.168.56.82 Database Oracle PostgreSQL Database Name orcl hr Database Version 19.3.0.0.0 12.0 Database Home /u01/app/oracle/product/19.0.0/dbhome_1 /usr/local/pg12 Goldengate Version 19.1.0.0.4 21.3.0.0.0 Goldengate Home /u01/app/oracle/product/19.1.0/ogg_1 /ogg_1 Goldengate Schema oggadmin pggadmin Table for Replication Scott.dept Public.dept We will setup table replication between Oracle to PostgreSQL databases. Oracle (Source) PostgreSQL (Target) 1.Unzip the Ora...