To my surprise CPUApr2008 is not available for latest patch-set of Oracle 10gR2 (10.2.0.4) that was released in first quarter 2008. In note that goes together with patch 6810189:
The following are the updated components of this patch set:Based on this I was expecting that CPUApr2008 will be also available for 10.2.0.4 patch-set. In note 552248.1 you will find then:
* Up to January 2008 CPU is included in this patch set
1.3 Database 10.2.0.4 Patch Set
The Database 10.2.0.4 Patch Set includes the CPUApr2008 content.
So the CPUApt2008 was available to all at least month before official release and was included in 10.2.0.4 patch set! Is this situation secure?
Anyway I had to install CPUApr2008. It's good that there is no need to recompile views this time. I've sucessfully installed it on test server, with minor problem. In installation log I've found one problem:
Hmm... After reconnecting, this commend run without errors:
BEGIN emd_maintenance.recompile_invalid_objects; END;
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "SYSMAN.EMD_MAINTENANCE" has been
ORA-06508: PL/SQL: could not find program unit being called:
ORA-06512: at line 1
SQL> conn / as sysdbaAfter all, server runs ok, and I do not find any problems within applications running on this.
SQL> BEGIN sysman.emd_maintenance.recompile_invalid_objects; END;
PL/SQL procedure successfully completed.
Related Articles on Paweł Barut blog: