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).…
Author: Steve
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…
Passwords in 11.2.0
Oracle removed the password from the DBA_USERS view in 11g, but apparently it can be fetched from the USER$ table (to which no one should normally have access) by concatenating SPARE4 and the PASSWORD column with a semicolon between the…
Printing Oracle silent installer prerequisite failed checks
I use what is below to print out prerequisites that aren’t met when performing a silent install. It is a lot easier to read, and prints only those components that have a failed check. #!/bin/awk -f { if ($0 ==…
Simple example of C# program accessing Oracle
Nothing big, just a placeholder for an example of what is in the subject line. //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 []args){ OracleConnection conn = new OracleConnection(“User Id=biztalk;Password=********;Data Source=fn9dev”); OracleDataReader rdr;…
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… 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…
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))…
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…