Database
Which tables have changes in a GoldenGate trail file?
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 10937 ATGDB_CORE.DCS_USER_ABANDONED CMHLDECOMDB01:oracle:cmhecomd1:/u01/app/oracle/acfsmounts/ggate/oracle2/dirdat> »
ACFS install on CentOS
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 OEL if defined (($release =~ /^redhat-release/) || # straight RH... »
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 around in the documentation, sometimes with an EXT on the front (EXTRBA), sometimes not.... »
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 did. in other words, is it every 3 seconds, or every 100 rows, etc.... »
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 count of records where each and every column’s before value matches each and every... »
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 time. Normally, without conflict detection and resolution, each update would be replicated to the... »
ORA-12516 – Possible causes
At least one is when your processes parameter in the database instance(s) has/have been exceeded. java.sql.SQLException: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:451) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:535) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:218) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:401) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:288) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:205) at stressRetail.run(stressRetail.java:82)... »
Instance state values in crsctl
As far as I can tell, the following values represent possible values for the state of instance as reported by crsctl status resource -t expressdb1:oracle:ecomm1:/u01/app/11.2.0/grid/bin# strings -a crsctl.bin | sed -n "16887,16910 p" Not Supported Any State Abnormal Termination Instance Shutdown Corrupted Controlfile Corrupted Dictionary Lost Write Datafile Offline Inaccessible Logfile Stuck Archiver Instance... »
Recording SQL Server CPU utilization for later analysis
Since we are still on SQL Server 2005 (going to 2008 R2 in the next six months), we don’t currently have the performance repository that 2008 does. As such, we recently added a job to record CPU utilization for later analysis. We have a job that runs every five minutes and simply runs the... »
GoldenGate progress monitoring script
As noted in earlier posts, we are in the midst of building out an active-active site using Oracle RAC and Oracle GoldenGate. We want to ensure we know when either the extract or replicat processes are lagging. We found that at times, the extract or replicat processes would indicate they are not behind, but... »