…don’t work in 11.2.0. Perhaps more specifically, I (and everyone I have found blogging about it, as well as on oracle forums) can’t get it to work. The documentation states the following… “Tightly coupled XA transactions no longer require the…
Category: Database
GoldenGate conflict detection in 11.2.1.0 and ignore when multiple statements are in a transaction
In GoldenGate 11.2.1.0, they introduced out of the box CDR (conflict detection and resolution). This is really useful in a bi-directional replication environment such as the one we are building. One question I had about this surrounded what happened if…
Nessus scan of Oracle listener
I thought this was interesting. I found the following in our listener.log file after our security team ran a nessus scan… listener.log:TNS-12502: TNS:listener received no CONNECT_DATA from client listener.log:27-JUN-2012 09:30:52 * (CONNECT_DATA=(COMMAND=VERSION)) * version * 1189 listener.log:27-JUN-2012 09:30:52 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=nessus)(HOST=172.26.253.75)(USER=)))…
ATG primary key data types
Not much today, this is just a place holder as we evaluate conflict resolution schemes for ATG and Golden Gate. Out of the box, it uses an application based sequence generator (DAS_ID_GENERATOR table). You can (and are encouraged to) prepend…
Logdump, the GoldenGate swiss army knife
Logdump is the Swiss army knife of troubleshooting GoldenGate. With it, you can identify things like: * Identify the transaction for a given SCN in Oracle * Identify the transaction at an RBA in the trail file about which the…
ltrace kills ocssd.bin which reboots node
The occsd.bin process is the core process which belongs to the Cluster Synchronization Service. This service is responsible for node membership decisions, so when it no longer exists, the server is rebooted. I was attempting to better understand the library…
ApexSQL
We are currently migrating a given database environment from an external provider on SQL Server 2005 to Oracle 11.2.0.3. While we could use GoldenGate, it is a one time migration for which we don’t need the “big iron” (or cost).…
Instance not restarting after failure in 11.2.0.3
I thought this was interesting. I always assumed that the RESTART_ATTEMPTS parameter of a cluster resource was only incremented after a failure to restart it. However, after developing an internal training course for our team, I noticed that after a…
Missing GETBEFORECOLS with conflict detection enabled in target table
While we are configuring different environments, we sometimes will change the target to which a datapump points. While using INTEGRATED TRANLOG and the new built-in conflict resolution in GG 11.2.0.1, we found that the new replicat wouldn’t respect the before…
Supplemental logging when running add schematrandata
As I have mentioned in past posts, we are currently implementing GoldenGate with ATG. We want to compare all columns in an update to all columns on the target, as we are implementing bi-directional replication. We found that when we…