Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [goldengate]

Oracle cross-platform replication software.

Oracle GoldenGate is a managed service providing a real-time data mesh platform, which uses replication to keep data highly available, and enabling real-time analysis. Customers can design, execute, and monitor their data replication and stream data processing solutions without the need to allocate or manage compute environments.

30 questions
6
votes
1 answer

Global locking for multi-master Oracle GoldenGate replication

This is a very complex scenario, but I figured a state-of-the-art challenge might interest some of the many high-end users of dba.se. Problem I'm working on an intercontinental data replication solution for a document production system, somewhat…
Roy
  • 1,060
  • 5
  • 16
  • 39
4
votes
2 answers

Golden Gate realtime replication basic question

I have a task to replicate unidirectional real time data from source database A to target database B. I do not need all the table from A, only few tables and few columns inside those tables. Say 10 tables and 30 columns from A go into 6 tables on…
ABDev
  • 41
  • 2
4
votes
1 answer

Can two transactions share the same SCN?

Do all transactions have a unique SCN? Can two transactions share an SCN? I'm confused by this statement in the Oracle Golden Gate manual: The CSN is cross-checked with the transaction ID (displayed as XID in Oracle GoldenGate informational…
Mark Harrison
  • 829
  • 5
  • 20
  • 33
3
votes
2 answers

Tracking changes to a table via the update/insert cmds executed against it daily

We have an oracle database back end for our SAP ECC system. In it we have a table with over a billion records. We would like extract this table to our SAP BW, which happens to be on MSSQL Server. The table we are trying to extract has no change…
CodeMonkey
  • 133
  • 1
  • 5
2
votes
1 answer

Replicating data from Oracle to MySQL

I work with a vendor that does data analytics, and they currently receive a replication stream from some of our databases using a product called Goldengate (which is very expensive). Goldengate has been great - it replicates transactions from the…
SqlRyan
  • 1,206
  • 2
  • 17
  • 24
2
votes
1 answer

Whether or Not to Use DataPump with Oracle GoldenGate

We are setting up GoldenGate to keep 3 of our Oracle databases in sync. Regarding configuration:   We plan to have an instance of GoldenGate running on all 3 nodes. Each node will run an extract on (local) Transaction/Redo Logs to create local…
Lance Allison
2
votes
1 answer

Migration of table from MySQL to Oracle using GoldenGate

I have a table of size 120 GB in MySQL 5.7 which I need to migrate to Oracle 12c. I am using Oracle GoldenGate for initial load of the table. I tried with initial load of full table but it consumed complete RAM and I had to cancel it. Even trying to…
samir sahu
  • 21
  • 2
1
vote
0 answers

dblogin cannot connect to SYSTEM DSN

I'm trying to install golden 19.1.0.0 on Window Server. I try to connect to SQL Server 2019 with dblogin and got the error in the picture. Any idea how to solve it?
KhoiNguyen
  • 11
  • 1
1
vote
1 answer

Oracle Materialized View - Is it Safe to Use Only ROWID as Record Identifier?

this is a question related to Oracle 12c. I'm currently trying to create MVs as data sources for Golden Gate replication. We need fast refresh because We have to replicate 60,000 rows + at one time and deleting and reinserting all rows seem to be…
Lee
  • 61
  • 1
  • 3
1
vote
2 answers

Goldengate warning on table with primary key

Installed Goldengate Version 18.1.0.0.0 for Oracle 11gR2. Table has primary key and yet goldengate complains that there is no key found,see below GGSCI (server01.localdomain as gguser@UPGR) 3> add trandata scott.books 2019-01-23 22:44:42 …
user168186
1
vote
1 answer

timestamp with timezone issue with TZR vs TZH:TZM

I have a Hibernate with Oracle JDBC based application inserting/updating into the following column; COLUMN_A TIMESTAMP WITH TIME ZONE DEFAULT systimestamp NOT NULL but while it automatically appends timezone, it uses TZR, e.g. UTC, and weird thing…
bvrakvs
  • 111
  • 1
  • 4
1
vote
1 answer

Getting Error/Exception In GoldenGate Replication

I am planning to configure a simple GoldenGate configuration and want to implement an exception table that will store all the exceptions. I followed two links, neither of which work for me: Troubleshoot Oracle GoldenGate Using Exception…
Gaurav Bhaskar
  • 109
  • 2
  • 8
1
vote
1 answer

Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs

How can I use Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database? I want to have a replication/slave database to have all the records of the master but when a delete query is…
Siya Stoan Sosibo
  • 113
  • 2
  • 8
0
votes
1 answer

Oracle GoldenGate add trandata errors

I am trying to add trandata to GoldenGate from SQL Server 2008 r2. I am getting an error stating . ODBC error: SQLSTATE 01000 native database error 16954. [Microsoft][SQL Server Native Client 10.0][SQL Server]Executing SQL directly; no…
user
  • 141
  • 1
  • 6
0
votes
0 answers

ora-12715 - Oracle GoldaneGate can not connect to database

I install Oracle 21c database and Oracle GoldaneGate 21.3 on Windows server, I can connect to my PDB using sqlplus and SqlDeveloper from another pc, but when try to dblogin from GGSCI get error this is my environment I set in my server: ORACLE_HOME …
sadegh
  • 101
  • 1
1
2