Skip to main content

Questions tagged [goldengate]

The tag has no usage guidance, but it has a tag wiki.

Filter by
Sorted by
Tagged with
0 votes
0 answers
53 views

Oracle GoldenGate SqlExec Error

I've recently intertied some Legacy code and was provide no documentation. I'm trying to understand where the issue is. Problem My Golden Gate replicats abend atleast once a week while trying to load ...
OptionalProgrammer's user avatar
0 votes
0 answers
44 views

Practices to maintain historical data via replication?

We have a use case like of banks, where we generate large number of transactions, say in transaction table and few other tables with large number of inserts, every day. Transactions are most inserted ...
Sachin Verma's user avatar
1 vote
0 answers
24 views

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's user avatar
0 votes
1 answer
924 views

Upgrade Oracle DB from 12C to 19C with minimum downtime

We are planning to apply the below steps --> Export Live DB setup on the Oracle version 12C Import on the new DB setup on version 19C At this point, V12, and V19 schema structures will be exactly ...
rajan dawra's user avatar
0 votes
0 answers
83 views

Converting Wire Protocol from Oracle to Postgres and Vice-Versa

Naive Question Assume we have an Application which was originally written for ORACLE as DBMS. If I want write an intermediary layer that gives this application independence to be able to work with ...
ultimate cause's user avatar
-2 votes
1 answer
95 views

AWS TO OCI GOLDENGATE REPLICATION

I want to use oracle Goldengate to my Multi cloud setup database, I'm just wondering if Im required to down my primary database to avoid data discrepancy? or goldengate can sync the data even if my ...
GoodGuyChaddy's user avatar
0 votes
1 answer
798 views

Goldengate timestamp (FFF)

Working with Goldengate 19.1.0.0.211019 replicat inbound to Oracle 19.0.0.0.0 consuming a trail file incoming from Nonstop (ie a non-Oracle database). Column in question from Nonstop is a string ...
Ditto's user avatar
  • 504
0 votes
1 answer
300 views

Do we need additional license to dump goldengate trail logs to kafka?

We have a Oracle (12c) GoldenGate license only (we do not have an oracle goldengate for big data). We need to transfer the gg trail logs to kafka then to hdfs. Do we need to buy the oracle goldengate ...
jimmiing's user avatar
0 votes
1 answer
418 views

oracle goldengate replication

Please I need help. Actually i am working on oracle 19c to perform a data base replication using the goldengate. I created two data bases (source and destination) the 3 processes (extract, pump and ...
Franck Yoba's user avatar
0 votes
1 answer
437 views

Exclude Supplemental Logs from Import

I am trying to import tables from a production environment, to a test environment. The production environment has supplemental logs on a number of tables for golden gate replication. The ...
Patrick's user avatar
  • 688
0 votes
1 answer
2k views

How to enable "only" drop partition DDL for Oracle Golden Gate?

I'm struggling with how to do this, and hoping somebody could assist with some ideas. Oracle Golden Gate - general question. Version shouldn't be specific, however, I am currently running on: Golden ...
Ditto's user avatar
  • 504
0 votes
1 answer
243 views

Oracle golden gate to BigQuery

Im trying to setting up the Golden gate to sync the data to BigQuery. When I start pushing the initial load, my extractor exported all the data and even from the replicat stats Im able to see the ...
TheDataGuy's user avatar
  • 1,950
2 votes
1 answer
527 views

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 (...
user avatar
0 votes
1 answer
3k views

Oracle goldengate service is not starting: Failed to retrieve the name of a missing Oracle redo log

I am trying to start GG service, when try 'start my_service' then starting but it didn't start, status is changed always starting to stopped. I need to start goldengate service.. I don't know what ...
J.Col's user avatar
  • 9
1 vote
1 answer
472 views

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 ...
Lee's user avatar
  • 61
1 vote
2 answers
2k views

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> ...
user avatar
2 votes
1 answer
997 views

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 ...
samir sahu's user avatar
1 vote
1 answer
5k views

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 ...
buræquete's user avatar
0 votes
1 answer
336 views

Golden Gate activity auditing with SQL?

In a scenario where Oracle Golden Gate is used to replicate a primary site with an Oracle RAC database to a secondary site (and active/active back) we suspect unexpected changes from the unused ...
eckes's user avatar
  • 1,456
0 votes
1 answer
2k views

Create User, Tablespace Replication in Oracle GoldenGate

How to replicate - Create User, Procedure and Tablespace using Oracle GoldenGate. I am able to replicate DDL under schema, however above is not getting replicated i.e. when I create an user, ...
Gaurav Bhaskar's user avatar
0 votes
1 answer
3k views

Update is not happening in Golden Gate

I have configured GoldneGate and Extract, Data pump and Replicat everything is working fine. However Update is not happening. Below are my Extract, Data Pump and Replicat file. Extract File: extract ...
Gaurav Bhaskar's user avatar
-1 votes
1 answer
2k views

Golden Gate Privilege Missing for using Encryption

dblogin userid ogg_user, password AADAAAAAAAAAAAIAKAQIJAGAMFUFKFBGQHXBJIWGECTEIAZHJFYALFFIBGHGJBPFBCPBKEPCRCRHAESJ, AES128, encryptkey securekey1 ERROR: Unable to connect to database using user ...
Gaurav Bhaskar's user avatar
1 vote
1 answer
2k views

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: ...
Gaurav Bhaskar's user avatar
4 votes
2 answers
1k views

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 ...
ABDev's user avatar
  • 41
4 votes
1 answer
844 views

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 (...
Mark Harrison's user avatar
1 vote
1 answer
881 views

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 ...
Siya Stoan Sosibo's user avatar
0 votes
1 answer
1k views

BI-DIRECTIONAL Oracle Golden Gate for Oracle 12c and SQL Server 2014

I have two servers (both servers are on Windows OS): Server_A running Oracle 12c Server_B running SQL Server 2014 I want to implement data synchronization between them with Oracle Golden Gate ...
SajjaD's user avatar
  • 187
0 votes
1 answer
2k views

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][...
user's user avatar
  • 141
6 votes
1 answer
3k views

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 ...
Roy's user avatar
  • 1,060
3 votes
2 answers
4k views

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. ...
CodeMonkey's user avatar
2 votes
1 answer
4k views

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 ...
SqlRyan's user avatar
  • 1,228