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…
Month: March 2012
Java date difference in milliseconds
Every time I need to do math on a date in java, I end up googling it. While that isn’t the worst way to do things (hey, it’s probably how you found this :)), I wanted something I *knew* would…
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…
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…
Open ports by interface
I often use what is below to get a listing of currently open ports by interface. If you find you can’t “see” a port from another computer, and… it is open on the IP to which you are trying to…
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…
Skipping a transaction in GoldenGate
We are the midst of a mission critical implementation that involves an active-active setup. We have chosen GoldenGate to manage the distribution of data between the two sites (soon to be three). This is the first of a series of…
SQL Patch
Oracle comes up with some cool tricks for fixing poorly performing SQL, especially code to which you have no direct access. If you absolutely know a given hint will always work, the Oracle optimizer blog recently posted a method for…
Reverse engineering a SQL replay script from a 10046 trace file
This will be the coup de grâce (but in a good way:)) if I can ever finish it. I have wanted to do this for years, and keep getting closer. Search for awk 10046 in the search bar on this…