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…
Category: Database
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 ==…
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…
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…
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…
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.(PhysicalConnection.java:535) at…
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…