Oracle 10.2.0.3 Patchset – Known Issues and Bugs

Jan 11, 2007 / By Alex Gorbachev

Tags: ,

Going through my feeds I read from Kevin Closson that Oracle 10.2.0.3 patchset is not functional on Solaris SPARC 64bit platform with datafiles on Veritas VxFS. Actually, Metalink Note for bug 5747918 says it’s for “any database related files on Veritas” so not sure if simple VxVM raw devices are affected as well as Veritas Cluster Filesystem.

However, you still have something to worry about even if you are not using that combination. You might want to check Metalink Note 5667023.8 if you are on Red Hat Linux and maybe even SUSE – you never know. RHEL AS Update 4 supposed to be fine while CRS might not start after patchset installation on Update 3. Workaround is available.

Other platforms to watch out with 10.2.0.3 patchset are Windows and Linux 32 bit – Metalink Note 403616.1 “Many Child Cursors create in 10.2.0.3 on Windows and Linux”. This will likely affect applications with heavy usage of bind variables (perhaps, ones with cursor_sharing=force/similar as well) and busy OLTP is a good candidate. See for yourself the note I mentioned above – it describes some symptoms and consequences (latch contention, ORA-4031, ORA-600) pretty well. The good news is that Linux platform has one-off patch available already – patch 5705795.

Finally, if you are using LDAP you might want to check Bug 4279598 out. It’s not a new bug but rather a behavior change that might affect you. Though, not very likely for generic scenarios.

Once again a confirmation of a golden rule – unless you are a brave tester, don’t rush into new Oracle patchsets. It’s also a good habit to review “Known Issues” Metalink Note for a particular patchset even in case it was out for a while – they tend to get updated. For 10.2.0.3 it’s Metalink Note 401435.1. Happy patching!

One Response to “Oracle 10.2.0.3 Patchset – Known Issues and Bugs”

  • After a small discussion on Oracle-L list here is the bug with open cursors:

    I saw the number bug only mentioned in the patch itself and it matches… well, patch number:
    5705795: MANY CHILD CURSORS CREATED FOR AMAZON-LIKE WORKLOAD IN 10.2.0.3

    On ML I found it as
    Bug 5705795 – Win/Linux: Many child cursors possible for SQL using BINDS

    Interesting, since when “Amazon-like” workload is used as wide-known adjective?

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>