Checking in at the Golden Gate
https://paulguerin.medium.com/checking-in-at-the-golden-gate-e8af42eba786
git clone https://github.com/oracle/vagrant-projects
cd ~/vagrant-projects/OracleGoldenGate/19.3.0
Now just need to download the database and Golden Gate prerequisite files that are the following:
LINUX.X64_193000_db_home.zip
191004_fbo_ggs_Linux_x64_shiphome.zip (or later)
OGG_BigData_Linux_x64_19.1.0.0.1 (or later)
vagrant up
vagrant ssh
sudo su - oracle
cd /u01/oggbd
./ggsci
info all
vagrant script has an error related to KAFKA download :
https://downloads.apache.org/kafka/2.8.2/
curl https://downloads.apache.org/kafka/2.8.2/kafka_2.12-2.8.2.tgz -# -o /tmp/kafka_2.12-2.8.2.tgz
Other GoldenGate Links :
----------------------------------
The Ultimate Guide to Setup Golden Gate On Vagrant Box :
HOW TO PREPARE A GOLDENGATE TEST LAB?
Oracle GoldenGate - Basic Configuration :
Administering Oracle GoldenGate 19c :
https://docs.oracle.com/en/middleware/goldengate/core/19.1/admin/administering-oracle-goldengate.pdf
GoldenGate for Big Data and Kafka Handlers hands-on – part 1
https://blog.yannickjaquier.com/oracle/goldengate-for-big-data-and-kafka-handlers-hands-on-part-1.html
GoldenGate for Big Data and Kafka Handlers hands-on – part 2
https://blog.yannickjaquier.com/oracle/goldengate-for-big-data-and-kafka-handlers-hands-on-part-2.html
----------------------------------
HOW TO CREATE THE SAMPLE HR SCHEMA IN YOUR PDB?
https://ora-base.com/?p=1415
Step 1 ) Navigate to the DEMO folder
[oracle@ggs1 ~]$ cd /u01/app/oracle/product/19c/dbhome_1/demo/schema/human_resources
Step 2 ) Connect to the PDB and execute the “hr_main.sql”
[oracle@ggs1 human_resources]$ sqlplus / as sysdba
SQL> alter session set container=ORCLPDB;
SQL> @hr_main.sql
specify password for HR as parameter 1:
Enter value for 1: hr
specify default tablespeace for HR as parameter 2:
Enter value for 2: users
specify temporary tablespace for HR as parameter 3:
Enter value for 3: temp
specify log path as parameter 4:
Enter value for 4: /tmp
Step 3 ) Let’s connect as HR and check the tables
[oracle@ggs1 human_resources]$ sqlplus hr/hr@orclpdb
SQL> show user
SQL> set lin 200
SQL> col tname format a30
SQL> select * from tab;
----------------------------------
Oracle GoldenGate 12c
http://samiora.blogspot.com/2020/05/oracle-goldengate-12c.html
Oracle GoldenGate Processes
How GoldenGate Works :
ORACLE GOLDENGATE - critical components :
https://medium.com/@Xavient/oracle-goldengate-57b09329222
Oracle GoldenGate Windows and UNIX Administrator’s Guide 11g Release 2 Patch Set 1 https://docs.oracle.com/cd/E35209_01/doc.1121/e29397.pdf
