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 ==…
Month: May 2012
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…