CPUJul2007

Received the auto generated mail from Metalink on the release of CPU July 2007 and food is ready for my colleague Ganesh for next few weeks.Ganesh is like a care taker for few hundred databases in our organization and ensure that all the databases are patched to meet the audit requirements.I used to crack jokes on him by saying that his breakfast and late supper is patching the databases on Development and UAT databases and during the weekends his breakfast,lunch and dinner is applying the CPU patches on to production systems once the UAT systems are signed of for the Patch applied by the application team.
The great news is we have automated the execution of the catcpu.sql script against each database after patching the Oracle binary.Otherwise it is going to be a monotonous and very boring job that everytime we are required to export the ORACLE_SID,ORACLE_HOME and other envrionment variables,
cd $ORACLE_HOME/cpu directory
executing sqlplus "/as sysdba" run the catcpu.sql against each database.. Oh my goodness it is going to be a laborious job to do all these especially after a longday.
Now only thing required is apply the patch by using the opatch utility and calling the Shell script to run the catcpu.sql against the each database running on the specific server, Life is so cool..
Link for summary on CPUJULY2007 is
http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpujul2007.html