Latest Story

Simple example of C# program accessing Oracle

Tuesday, May 15, 2012
By Steve

Nothing big, just a placeholder for an example of what is in the subject line. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 //C:\Users\showard>C:\Windows\Microsoft.NET\Framework\v2.0.50727\csc.exe /r:"C:\oracle\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll" checkConn.cs   using System; using Oracle.DataAccess.Client;   public class checkConn { public static void Main(String... »

Which tables have changes in a GoldenGate trail file?

Monday, May 7, 2012
By Steve

I use the following to identify which tables have changes recorded in a trail file, as well as how many changes each table has… 1 2 3 4 5 CMHLDECOMDB01:oracle:cmhecomd1:/u01/app/oracle/acfsmounts/ggate/oracle2/dirdat>strings -a r1000009 | grep ATGDB | sort | uniq -c 6 ATGDB_CORE.DAS_ID_GENERATOR 21873 ATGDB_CORE.DCSPP_ORD_ABANDON... »

ACFS install on CentOS

Wednesday, April 25, 2012
By Steve

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)) && # Redhat or... »


Using DBMS_LOGMNR with GoldenGate logdump

Monday, April 23, 2012
By Steve

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... »

How often does GoldenGate checkpoint?

Wednesday, April 11, 2012
By Steve

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... »

Programmatically creating GoldenGate confliction detection filters

Wednesday, April 11, 2012
By Steve

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... »