I run CentOS on a test cluster, and every time I patch it with a PSU or whatever, my ACFS installation is trashed as CentOS is not officially supported. To fix this, change the following section in $GRID_HOME/lib/osds_acfslib.pm… if ((defined($release))…
Month: April 2012
Using DBMS_LOGMNR with GoldenGate logdump
I honestly don’t know if we will ever use this, but I thought it was useful enough to document. One of the things I struggled with early in our GoldenGate testing was what an RBA was. The term was flipped…
How often does GoldenGate checkpoint?
While running a 10046 trace against a replicat session, I saw UPDATE statements against the checkpoint table. While this isn’t unexpected, as I had configured the replicat to use a checkpoint table, I was curious to see how often it…
Programmatically creating GoldenGate confliction detection filters
EDIT: 2012/05/01 I changed the PL/SQL code below, as I found that creating a filter per column eventually exhausts the hardcoded limit on the number of filters you can have for a table (20). I changed it to do a…
Print thread dump for a single thread
We had an issue where a single thread was using all the CPU. We wanted to check it at the command line while troubleshooting. We used what is below… [atg@CMHLDECOMAP01 ~]$ jstack 3000 | awk ‘{if ($1 == “\”Thread-9\””) {i…
GoldenGate simple conflict resolution example
I found it incredibly difficult to find a simple working example of an inventory type system where a user at SITE A updates the inventory for ‘Bowl’, while at SITE B another user updates the inventory at the exact same…