Questions tagged [oracle-golden-gate]

Oracle Golden Gate is a heterogenous real-time data integration product. Use this tag for questions related to configuration or scripting of this tool.

0
votes
1answer
11 views

Using Oracle GoldenGate Microservices Architecture to get realtime updated data and sent to a rest api

I want to use OGG Microservices Architecture, to get real time updated data, and send the update to a rest api. The rest API is developed by ourselves. The REST api will accept a json data with POST ...
0
votes
1answer
14 views

How to Oracle GoldenGate Microservices Architecture with kafka handler

I want to use OGG Microservices Architecture and extract the data into Kafka. All I found in google is about ogg classic, not micro services. I am new for ogg, so if there is some detailed artical ...
0
votes
0answers
8 views

How to inject a password into ggsci

I'm trying to inject a password into DBLOGIN so it can be retrieved from CyberArk rather than being entered by the user. Is there a user_exit or some kind of hack that would allow me to do this? Using ...
0
votes
1answer
29 views

How can I configure the kafka connect handler in OGG for Hdfs

I am doing a POC on moving data from Oracle db to Hadoop file system using Kafka(new at this). I have configured my extract on oracle db and it publishes the changes done in my source table to my ...
1
vote
1answer
35 views

OracleGoldengate BigData for Kafka does not produce UPDATE messages

I'm experimenting with OGG BD (v12.3.2.1.1) to propagate all changes from an Oracle DB (11.2.0.4) to Kafka topics. I got the basic setup all working, and INSERT and DELETE to the schemas/tables I'm ...
0
votes
0answers
9 views

Oracle Golden Gate- Active/Passive : two entries in each table

I am a beginner and need your experts help on the below issue. ACTIVE - PASSIVE ORACLE - ORACLE Found that a table: PROCESSTASK being updated from both sites. Ideally it should not happen since ...
0
votes
0answers
15 views

Disable XA transaction in MariaDB 10.2

Oracle GoldenGate requires XA transaction to be disabled on MariaDB 10.2 to extract data. The parameter innodb_support_xa is set to ON by default. How can we set it OFF or disable it to enable Oracle ...
0
votes
1answer
21 views

How to avoid being prompted while deleting replicates in ggsci

I'm looking to automate the goldengate processes of stopping,deleting and adding new replicate files.This will be done in a gui which triggers a shell script in linux. While deleting the replicates it ...
-1
votes
1answer
40 views

realtime replication oracle 10g to kafka by goldengate

We have an old system running on oracle 10g, now we need to analyze its data, we prepare to replication the data to kafka in realtime, I learned goldengate through , but I don't know how to implement ...
1
vote
1answer
43 views

GoldenGate Replicat not putting all Columns in After

I have GoldenGate for Oracle(123015)'s Replicat process set up to get changes from the Oracle 12c database. I'm able to get all INSERT/UPDATE/DELETE changes to the trail files. However, during the ...
0
votes
1answer
74 views

Oracle Golden Gate for HANA target

We have Oracle as source and HANA and Hadoop as data warehouse. We wanted to replicate Oracle data to HANA and Hadoop on real-time basis. Golden gate has excellent integration with Hadoop components ...
0
votes
0answers
57 views

How to validate file data from HDFS and Hive table?

I have Requirement in my current project, I am retrieving data from Oracle source Database and load in to HDFS destination directory as a CSV file through Oracle goldengate data replication. Each ...
0
votes
0answers
44 views

Unable to add checkpoint table in GoldenGate

add checkpointtable <user>.<checkpoint> ERROR:Catalog name is missing from checkpoint table specification <user>.<checkpoint>. add trandata <user>.% ERROR: The catalog ...
0
votes
1answer
106 views

goldengate : Metadata format of the definitions file for table does not match trail format

getting the below error when starting replicat... 2019-02-01 12:46:28 INFO OGG-03059 Oracle GoldenGate Delivery, rms01.prm: Operating system character set identified as UTF-8. 2019-02-01 12:46:...
0
votes
0answers
125 views

How to replicate and sync a MySQL to graph database

I need to replicate and continuously sync a MySQL database to a graph database, to further query and analyze data from an eCommerce application. Came across DZone Article which talks about syncing ...
0
votes
0answers
35 views

Oracle golden gate replication master control table

This is the same post on https://community.oracle.com/thread/4194263 We have a design like this. The lock service lock records being requested by the App Service. And the lock service locks ...
0
votes
1answer
43 views

Error while setting up a golden gate replication process, for JSON document convert to rdbms table

I am trying to convert and replicate json document stored in oracle table (source) as clob value to target database (oracle) as rdbms table using oracle goldengate : GGSCI (ggsrv2.localdomain) 39>...
0
votes
1answer
42 views

Python OS Commands Not Work Due To New App Execution

I need to check GoldenGate processes' lag. In order to this, I execute Goldengate than I try to run GoldenGate's own commands "info all". import subprocess as sub import re import os location = str(...
1
vote
1answer
147 views

Convert Date field for Oracle GoldenGate

I have an Oracle GoldenGate setup with Oracle database as my source and a non-Oracle target. My source database is in Timezone A. Is there a way to configure my Extract/Replicat so that all data in my ...
0
votes
1answer
86 views

Configuring SQL Server to Oracle initial data load in Goldengate

As per my understanding before setting up transaction replication in Oracle Goldengate, we have to setup initial data load. In my case the source is SQL Server 2012 and the destination is Oracle 12 ...
0
votes
1answer
68 views

Sizing requirements for Oracle downstream mining database while using Oracle Golden gate Downstream Integrated Capture

I just want to know role of oracle downstream mining database machine in OGG downstream integrated capture mode. To be specific, I want to know whether the mining db also stores data or it only ...
0
votes
1answer
76 views

Reading AVRO file through java and passing as JSON

Ask is GoldenGate will push(Kafka) AVRO file ,need to read that and convert into JSON form push to google spanner.(New to AVRO ,google spanner) Seeking how to start with that?
0
votes
1answer
198 views

Oracle GoldenGate Big Data adapter for Kafka Handler

My question is about Kafka checkpointing with replicat, example, in Kafka producer asynchronous mode, replicat moved to 1 to 100 operations, let say kakfka processed 80 operations, at 81 Kafka is ...
0
votes
0answers
24 views

pre/postUpdate and pre/postPersist usage in code instead of Triggers in database

We have some triggers in Oracle database which are used for Auditing purposes and used for before update/insert operations. We need to replace all triggers with code. Is it possible to use pre/...
0
votes
1answer
229 views

How to extract data from multiple databases and replicate to one database having different table structure using Oracle Goldengate?

I have 6 tables to extract data from each one of the 4 databases. I have to replicate all that data in 6 tables of single database. Target tables have just one extra column 'instance_id' which shows ...
1
vote
1answer
614 views

How to handle lag in replicat in oracle goldengate while running housekeeping scheduler jobs in oracle database?

A scheduler job runs at 11PM every night to delete around 500,000 records in Source Oracle Database 12c. During this time, replication lag on target database suddenly increases from 4 seconds to 900 ...
0
votes
0answers
46 views

Compression | Oracle GoldenGate to HBASE

We are using Oracle GoldenGate 12c to replicate in HBASE-1.1.2.2.6.3.0-235. Is there a way for OGG to specify compression while creating replicated tables. Now I have already replicated 40 tables. Is ...
1
vote
1answer
218 views

Oracle Golden Gate or SQL Server Replication

I have detailed a scenario below in which we need to access our data in a vendors private cloud. I know sql server replication but am not very familiar with GoldenGate outside of the basic concept. ...
0
votes
0answers
63 views

Implementation of Kafka Handler's CreateProducerRecord Java Interface

Currently in the setup we have, data is being moved to Kafka through Oracle golden gate for big data using the Kafka handler. The topic at Kafka is partitioned but the data is being pushed without a ...
-2
votes
1answer
30 views

Big data adapter kafka handler

Am getting below error in Big data adapter to kafka connection Big Data Adapter to Kafka ERROR OGG-15051 : Unable To Commit Transaction, STATUS=ABEND(Doc ID 2216296.1)
0
votes
0answers
32 views

Oracle golden gate Monitor url -http://hostIpaddress:7003/monitor is not reachable

I have installed Weblogic and Oracle golden gate monitor server. I see boths servers up and running in Admin console at http:ggcoreIPaddress:7001/console. I see the monitor app in Active state under ...
1
vote
1answer
175 views

I have Golden Gate on oracle 12c. Is it possible to get subset of data (like Where condition) from source to replicate

I have Golden Gate on oracle 12c. Is it possible to get subset of data (like Where condition) from source to replicate in the target database. Second question: Is it possible to replicate data using ...
1
vote
1answer
238 views

Golden Gate Replication - Postgres Instances

Can golden gate be used for bidirectional replication of 2 postgres (RDS or Aurora) db instances in AWS?
1
vote
1answer
218 views

Moving tables from one running extract process to other extract in golden gate

The scenario at hand is that there are 2 extract - pump - replicat groups running currently. The requirement is to move one of the tables from group2 to group1. Can we just stop the extract-pump-...
0
votes
1answer
362 views

Goldengate Manager stopping with ACCESSRULE error

After a server reboot the Goldengate manager not starting. It starts up for few seconds then will go down with OGG-01877 missing explicit Accessrule for server collector. it was working from past 1 ...
0
votes
1answer
432 views

Oracle GoldenGate adapter for Kafka - JSON message contents

In My golden gate big data for kafka. when i try to update the record am getting only updated column and primary key column in after part in json file {"table":"MYSCHEMATOPIC.PASSPORTS","op_type":"...
0
votes
1answer
123 views

GoldenGate for SQL Server does not create extract files

I installed GOLDENGATE for SQL Server database two weeks ago. Everything was OK until yesterday. I noticed my target database (Oracle 12c) tables not actual. Then I check GoldenGate logs ggserr....
-1
votes
1answer
301 views

Golden gate adapter for kafka kafkahandler

ERROR [main] (DsHandler.java:293) - Unable to set property on handler 'kafkahandler' (oracle.goldengate.handler.kafka.KafkaHandler). Failed to set property: T opicName:="test" (class: oracle....
1
vote
3answers
2k views

Apache Kafka vs Oracle Goldengate for remote data streaming

Regarding a data consolidation scenario, are there any comparative analysis that compares Apache Kafka and Oracle Goldengate for remote data streaming? In the scenario, we have to integrate sensory ...
-1
votes
1answer
34 views

OracleGGCreateNextBatch table in different location?

I am trying to use Oracle GoldenGate to connect a read-only MSSQL-DB to an Oracle-DB. In ggsci when I try the command for the MSSQL source DB: ADD TRANDATA MySchema.TableName I get lots of errors ...
0
votes
1answer
408 views

Golden Gate ERROR OGG-05263 No GGSCHEMA clause

In OTN I am using these instructions to "try" and configure GoldenGate with a MSSQL Source DB to an Oracle12c Target DB http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-...
1
vote
1answer
109 views

Getting error to install rlwrap

I am trying to install rlwrap for Oracle Goldengate installation but at the time of installation I got following error. yum install rlwrap-0.37-1.el6.i686.rpm Loaded plugins: fastestmirror, langpacks ...
1
vote
0answers
104 views

AWS Oracle RDS : Parameter group missing ENABLE_GOLDENGATE_REPLICATION

I'm attempting to implement replication between two AWS Oracle RDS instances using Golden Gate. So far it has not been a pleasant experience lol. I'm currently stuck on enabling Golden Gate in the DB ...
1
vote
1answer
185 views

configured oracle goldengate DML replication both are oracle database

I had configure oracle D ML replication using oracle golden gate successfully but is there any query to check source and target is in sync or not or how to verify IT.
0
votes
2answers
276 views

oracle Golden gate for big data kafka adapter grouping data to kafka

Source: Oracle Database Target: kafka Moving data from source to target by oracle golden adapter for big data. Problem is data is moving fine but when am inserting 5 records its going as one file in ...
5
votes
1answer
305 views

How can be handle oracle decimal types with GoldenGate “Kafka” / “Kafka connect” handler?

I wanna use Oracle GoldenGate (it's orcale cdc tool) to integrate oracle with Kafka. i have find a two Handler: http://docs.oracle.com/goldengate/bd123110/gg-bd/GADBD/using-kafka-connect-handler.htm#...
-2
votes
2answers
309 views

Can Kafka be used as a messaging service between oracle and elasticsearch

Can Kafka be used as a messaging service between oracle and elastic search ? any downsides of this approach?
1
vote
0answers
84 views

Reading data from kafka topic via golden gate

I have a Spring Boot code which reads data from Kafka topic. The code works as expected when data is feed to the topic via Kafka Producer Console. When I try to push data into the kafka topic via ...
0
votes
1answer
137 views

Oracle Golden Gate for Integration with Microservices

I'm working on migration/integration of large on-premise Oracle monolithic app to cloud based Microservices. For a long time, microservices will need to be fed from and synchronized with the Oracle DB....
1
vote
1answer
350 views

Oracle Golden Gate User Exit - EXIT_CALL_PROCESS_RECORD not passed

I have problem with create custom User Exit in Oracle Golden Gate. I need to connect to the stream of changes during database replication and create JSON string of this changes. At this moment I have ...