Knowledge increases exponentially. Today, you probably own more books than great universities of times past—Cambridge University owned less than two hundred books in the fifteenth century. First came the invention of writing, then alphabets, then paper, then the printing press, then mechanization. Each step caused an exponential increase in the collective human knowledge. In our generation, Al Gore invented the internet and the last barriers to the spread of knowledge have been broken. Today, everybody has the ability to contribute, communicate, and collaborate. We are all caught up in a tsunami, an avalanche, a conflagration, a veritable explosion of knowledge for the betterment of humankind. This is the blog of the good folks at Database Specialists, a brave band of Oracle database administrators from the great state of California. We bid you greeting, traveler. We hope you find something of value on these pages and we wish you good fortune in your journey.

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

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.

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>