Dontcheff

Patching the 11.2.0.2 database

In DBA, Oracle database on May 5, 2011 at 05:27

Oracle have already announced the following important changes to Oracle Database Patch Sets: “Starting with the first patch set for Oracle Database 11g Release 2 (11.2.0.2), Oracle Database patch sets are full installations of the Oracle Database software. In past releases, Oracle Database patch sets consisted of a set of files that replaced files in an existing Oracle home. Beginning with Oracle Database 11g Release 2, patch sets are full installations that replace existing installations.” Details can be found on Metalink Note 1189783.1.

That is good and fine unless we are not being bombarded with dozens of additional patches on top of these installations. It’s another story if 11.2.0.2 is really a patchset of 11gR2 or is it rather 11gR3.

As of yesterday, May 4th 2011, there are 324 different patches available for Linux x86-64 on top of 11.2.0.2. For Solaris SPARC 64-bit, they are only 214.

Looking at the bugs fixes you might have mixed feelings: while we are all used to seeing fixes for the never ending ORA-00600 and ORA-07445 errors, I really cannot understand how we still face issues with wrongly returned data. That should be so basis requirement from a database, right?

10190421 Possible wrong results in query using connect by clause with parrallelism
10353054 Wrong result due to loss of semi joins

Looking at the readme files those “wrongly returned data” errors might even be seen coming sequentially 🙂

As DBAs, when reading emails for example, we all probably have this mild smile on our faces when seeing words like “data base” and “table space”. Well, probably not a database guy who writes them? Or DB2 background. But how about when you find them in Oracle’s documents:

By the way, did you notice the typo above, the word parrallelism? How about using a spell checker? Here is a screenshot from the readme:

Another issue I am amazed with: if a junior developer does not handle his/her exceptions in the PL/SQL code, (s)he might be excused: (s)he is learning, we all make mistakes. So does Oracle:

And now back to the real issue: you install 11.2.0.2 and wonder if you have the latest release of Oracle. Well, yes but minus the patches that were created by “the bug department”. Of course you don’t want to install 100s of additional patches. Here is what Oracle recommends:

Just install patch 12311357 which is GI PSU 11.2.0.2.2 as it includes PSU 11.2.0.2.2 which on its behalf includes CPUAPR2011. If using RAC and ASM add 10157506 (11.2.0.2 RAC GI BUNDLE1) and the recommended bundle patches up to BP10 (BP10 is patch 12773458, the patch must be applied on the Oracle home of Oracle Database as well as Oracle Grid Infrastructure). For second opinion on this click here.

Important for Siebel users: if you run Siebel on top of Oracle RAC, check Metalink Note 1297080.1 Certification Siebel Applications 8.1.1.2 With 11gr2 Rac [ID 1297080.1]. It says at the end: “It was also clarified by product marketing that basically oracle database version 11.2.0.1 is the base version that is supported and implies that any 11.2.0.1 or higher version is included”. That is: put all patches mentioned above also for Siebel applications!

Looks like database bug fixes are released rather frequently, the day before yesterday 3 new fixes came for the Linux platform:

Hint: try opatch auto!

Advertisements
  1. Hi Julian,

    We missed you at the BGOUG and hope to see you next time.

    By the way you will be interested in the following MOS ID for a bug already fixed in BP2 for a possible data corruption:
    ORA-600 or Data Corruption possible during shutdown normal/transactional/immediate of RAC instances in a rolling fashion [ID 1318986.1]

    Regards,
    Sve

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: