Monday, April 16, 2012

AIX and Oracle 11.2 Patches galore

11.2.0.3 isnt all that new with PSU1  already out i decided that this should be  a good time to build all new environments with 11.2.0.3 PSU1 .
After building the GI and the DB's (RAC and Non-RAC). I stumbled upon this document
AIX: Top Things to DO NOW to Stabilize 11gR2 GI/RAC Cluster [ID 1427855.1]
This
This is an interesting note and should be followed after the install since it talks about how many bugs Oracle 11.2.0.3 has on the AIX Platform.
The most important one is the orarootagent memory leak  for which the following is recommended
If you are running 11.2.0.3, apply 11.2.0.3 GI PSU1 (patch 13348650) and patch 12709476
There are also other issues that the above note will let you know including OS fixes that you need to put in.
It is very important to follow some of the  recommendation to avoid service interruptions.
Some of the bugs seem to be fixed in 11.2.0.3 PSU2 which should be out shortly.
There is also this noteto consider which takes about the optimizer problems. Most of  these will not be in the PSU and oneoffs will need to be considered.
Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results [ID 1392633.1]

So off to patching and fixing my new environments and builds .

Google Search