GoldenGate remote capture/delivery setup(Replication Hub)
edited Oct 27, 2019 5:06AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Hi,
My client requires the following setup for remote capture/delivery from Oracle to Kafka.
Database Server
- Linux 64bit(Exadata)
- Oracle Database 11.2.0.3 with required patch for integrated capture
- Database in force logging and supplemental logging
- Tablespace created for Goldengate admin user
- Goldengate admin user created and required grants done
Replication Hub
- Windows server 64bit
- Oracle client installed and tnsnames.ora setup completed
- Oracle Goldengate 12.3.0 and Oracle Goldengate for Big Data 12.3.2 combined instead of having two separate installations
Kafka Cluster
- Linux 64bit
Questions:
- When I start the remote capture extract on the windows server it is not capturing any changes. When tracing(trc and trc2) it it looks like it is taking hours to read through the onlinelogs with no checkpoints. Should online and archivelogs be mounted from the database server onto the replication hub in order to successfully perform remote capture or is it possible to capture via only database connection as per tnsnames.ora of the client installed on the replication hub? There is no load on the database at the time of my change and capture testing. If I move the Goldengate
1