GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center