Silent Upgrade Oracle GoldenGate 12.1.2.0.0 to 12.1.2.1.2

Today I worked on silent upgrade of Oracle GoldenGate from 12.1.2.0.0 to 12.1.2.1.2, so thought to blog it which might help some of you. These are the steps I performed Current GoldenGate Home --> /oracle/app/product/ogg12.1.2 1. Gather the details of GoldenGate Processes before stopping them GGSCI> INFO EXTRACT EXTL, SHOWCH INFO EXTRACT DPUMP, SHOWCH GGSCI> …

Advertisement

ORA-00353: log corruption near block change time – 11.2.0.3

Recently I came across "ORA-00353: log corruption near block change time" error. Errors in file /oracle/app/diag/rdbms/test/test/trace/test_ms00_54284.trc (incident=1490189): ORA-00353: log corruption near block change time ORA-00353: log corruption near block 4631374 change 263470473806052 time 04/16/2015 06:53:16 ORA-00312: online log 43 thread 3: '+REDO02/test/onlinelog/group_43.258.875922665' ORA-00312: online log 43 thread 3: '+REDO01/test/onlinelog/group_43.258.875922633' Incident details in: /oracle/app/diag/rdbms/test/test/incident/incdir_1490189/test_ms00_54284_i1490189.trc Thu Apr …

UPGRADE CHECKPOINTTABLE – Goldengate

We have a goldengate setup wherein 3 different GoldenGate clients connects and replicat to one target database.Below are the versions being currently used 11.1.1.1, 11.2.1.0.0 and 11.2.1.0.3. The version 11.2.1.0.3 was recently added, and below are the steps performed GGSCI (myhost) 2> obey ./dirprm/add_rep.oby GGSCI (myhost) 3> GGSCI (myhost) 3> DBLOGIN USERID ggate@test PASSWORD 'xxxxxxxx' …

ORA-26723: user “XXXXX” requires the role “DV_GOLDENGATE_REDO_ACCESS”

While starting the extract on UAT DB env which had been recently moved to exadata we got the below error.As we had redo and archive logfiles on ASM, we used "TRANLOGOPTIONS DBLOGREADER" in extract parameter file. 2012-10-24 22:35:48 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, emos_cc.prm: Opening ASM file +RECO_UMO1/archivelog/2012_10_24/thread_1_seq_224.955.797517005 in DBLOGREADER mode: (26723) ORA-26723: …

Extract keeps ABENDING – No valid archive log dest for Thread N – OGG

Recently we refreshed one of the 2-node UAT database from 3-node production.The 2-node UAT acts as the source for the GoldenGate.After the refresh of source and the initial load on the target, we started the extract and replicat process.As, the source was 2-node RAC, extract was added with 2 Threads information ADD EXTRACT ext, TRANLOG, …

OGG replication failing with “ORA-12899: value too large for column“

Recently while working on Oracle GoldenGate, when i started the replicat it failed with "ORA-12899: value too large for column" 2011-09-25 22:19:52 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rep3.prm: SQL error 12899 mapping anand.tab1 to andy.tab2 OCI Error ORA-12899: value too large for column "ANDY"."TAB2"."CITY" (actual: 68, maximum: 50) (status = 12899), SQL <UPDATE …

ERROR -OGG-00446 -Oracle GoldenGate Capture for Oracle: No valid log files for current redo sequence XXX, thread X

I was trying to setup Oracle GoldenGate (OGG) on my test box having 11gR2 database with ASM. On starting the extract process on the source showed - GGSCI (anand-lab) 6> START EXTRACT ext1 Sending START request to MANAGER ... EXTRACT EXT1 starting GGSCI (anand-lab) 7> INFO EXTRACT ext1 EXTRACT EXT1 Initialized 2011-07-17 14:22 Status STOPPED …

ERROR: No checkpoint table specified for ADD REPLICAT – Oracle GoldenGate

This is just a quick note for myself to remember and reference for in case someone comes across this error while setting up Oracle GoldenGate. While configuring the online synchronization replication, a default checkpoint table is created.The table's name is mentioned in file named GLOBALS. GGSCI (anand-lab) 29> EDIT PARAMS ./GLOBALS GGSCHEMA GG_OWNER CHECKPOINTTABLE GG_OWNER.CKPTAB …