Infrastructure at your Service

GoldenGate Archives - Blog dbi services

Daniel Westermann

Oracle OGG JAGENT 12.2 installation for GoldenGate monitoring using the Cloud Control plugin

By | Database Administration & Monitoring | No Comments

This post is mainly for self documentation as I have to search my old notes every time I want to do this (I am faster by searching on our blog ): If you want to monitor GoldenGate with Cloud Control using the GoldenGate plugin you’ll have to install the JAGENT on the host where GoldenGate is running on and the documentation is not quite clear on what you have to do exactly (at least when…

 
Read More
Daniel Westermann

A new OGG challenge: Migrate an Oracle 8.1.7.4 instance to 10.2.0.5

By | Database Administration & Monitoring | No Comments

Yes, these beasts still exist in production: [/u01/appl/ora817]$ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 – Production on Thu Apr 27 09:54:20 2017 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> connect / as sysdba Connected. SQL> select * from v$version; BANNER —————————————————————- Oracle8i Enterprise Edition Release 8.1.7.4.0 – Production PL/SQL Release 8.1.7.4.0 – Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.4.0 – Production NLSRTL Version 3.4.1.0.0 – Production  

 
Read More
Daniel Westermann

OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2

By | Database Administration & Monitoring | No Comments

Another GoldenGate 12.2 one: Some days ago I had this in the GoldenGate error log: 2017-04-12 14:56:08 WARNING OGG-02901 Oracle GoldenGate Capture for Oracle, extimch.prm: Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting. Using fetch instead. 2017-04-12 14:56:08 ERROR OGG-02912 Oracle GoldenGate Capture for Oracle, extimch.prm: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later. Seemed pretty obvious that…

 
Read More
Daniel Westermann

Failed to set logmining server parameter MAX_SGA_SIZE to value XX

By | Database Administration & Monitoring | No Comments

When you see something like this in your GoldenGate error log when you try to start an extract: 2017-04-12 14:51:38 ERROR OGG-02039 Oracle GoldenGate Capture for Oracle, extxxx.prm: Failed to set logmining server parameter MAX_SGA_SIZE to value 24. 2017-04-12 14:51:38 ERROR OGG-02042 Oracle GoldenGate Capture for Oracle, extxxx.prm: OCI Error 23605. 2017-04-12 14:51:38 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extxxx.prm: PROCESS ABENDING. … then you should increase the streams_pool_size (maybe you need to increase…

 
Read More
Daniel Westermann

GoldenGate 12.2: ERROR: Unable to create a new wallet

By | Database Administration & Monitoring | No Comments

Today I had a very strange issue when setting up a brand new GoldenGate 12.2 installation. Installation went fine, patch went fine (PSU 170221) and then I started to configure GoldenGate. One of the first commands we usually do is: GGSCI (xxxxx) 2> create wallet I really never had any issues with this, but today I got: GGSCI (psrdbap03n1) 2> create wallet ERROR: Unable to create a new wallet.  

 
Read More
Daniel Westermann

OGG: Unable to lock file “/xxx/de000000″ (error 11, Resource temporarily unavailable).

By | Database Administration & Monitoring | No Comments

When you see the above message in the GoldenGate logfile there are usually orphan processes that prevent GoldenGate from locking the file (typically when your trail files are on NFS). In a case I had at a customer last week this was not the case. It could be confirmed that there are no other processes sitting on the file by doing an fuser on the file on all nodes of the cluster (This was an…

 
Read More
Daniel Westermann

Letting GoldenGate automatically maintain the insert and update timestamps on the target

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

Today at one of our GoldenGate customers we were faced with the following requirement: For one of the tables on the target we needed two additional columns which shall hold the insert and update timestamps for when the row was either inserted or updated. Just to be clear: It was not about getting the timestamps for the inserts or updates as they happened on the source but the target. In this post we’ll look at…

 
Read More
Franck Pachot

Dbvisit replicate allows DDL replication even when source and destination have different structure

By | Database Administration & Monitoring | No Comments

I’ve tested a little thing for a customer, and as usual I spool the result into a blog post in case it helps others. Not all replication software – at least in their current version – can manage both different target structure (which is often the main reason for logical replication) and keep up with new DDL on the source (which you can’t avoid – applications evolves). Let’s see how smart is Dbvisit replication with…

 
Read More
Daniel Westermann

If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?

By | Database Administration & Monitoring | No Comments

This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp Using GoldenGate event actions to suspend replication for end of day reporting One question that pops up when stopping the replication by using an event marker is: What happens…

 
Read More