RAC
Linux firewall rules for RAC
Most notes on the Oracle MOS support site suggest disabling the firewall supplied in most Linux distros as managed by the iptables program. I think this is a bit drastic, and results in lazy thinking at best, and an exposed database server subject to all sorts of hacker invasion at worst. If you don’t... »
Why won’t my VIP start?
After restarting a test server, I found the RAC VIP would not start. This post is just a quick note as to how I troubleshot the problem, as well as its ultimate resolution. I frequently use the find -mmin 5 -type f | xargs grep -i "whatever you want" command to find any recently... »
Runtime connection load balancing issues in 11.2.0.2
We upgraded our largest and most important databases last month to 11.2.0.2 from 10.2.0.4. We had a few issues, most of which have been resolved. However, one that continued to plague us until yesterday is the apparent inability of any version of the Oracle JDBC drivers to utilize runtime connection load balancing. For those... »
Querying load balancing information from the Load Balancing Advisory
I use what is below to periodically gather what the load balancing advisory posts. The data reflects the percentage of connections to distribute to each instance for a given service in a RAC. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21... »