Java & Linux : Fishing in the Desert: Checking in at the Golden Gate 19c

Saturday, January 21, 2023

Checking in at the Golden Gate 19c

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 :

https://itnext.io/the-ultimate-guide-to-setup-golden-gate-on-vagrant-box-5f73fc67ebd6

HOW TO PREPARE A GOLDENGATE TEST LAB?

https://ora-base.com/?p=1419

Oracle GoldenGate - Basic Configuration :

http://www.juliandyke.com/Research/GoldenGate/GoldenGateBasicConfiguration.php

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;