Tuesday, May 25, 2010

April CPU 2010 updated 12-May due to 239 invalid OLAP objects.

Ian Jones, Sr. Staff Consultant


On 12th May Oracle updated the 11.1.0.7 April CPU 2010 security patch (9369783) on all platforms.  The original April 13th patch causes 239 invalid objects in the database if the OLAP option is NOT installed.  So, if you were planning to apply this patch you should download the 12th May version.  You can find out the details in metalink note 1060969.1 “Critical Patch Update April 2010 Known Issues”

The presence of the invalid objects does not cause problems however ending up with an extra 239 invalids at the end of the patch that are not discussed in the patch notes would be a concern.  Of course, that is why Oracle have  document 1060969.1 to catch these things. 

If you applied the patch between its original release on April 13th and the update of the known issues on 12th May you should check for the presence of these invalids.  Metalink note 1091952.1 lists them and says ”As long as OLAP was not in use it is safe to drop all of the above objects”. 

I have not tested the April PSU patch (9352179), at the moment it has no similar update in its known issue document, which is note 1061315.1.

Read more here.

No comments:

Post a Comment