1.617.682.4508

Pythian Blog

The world discusses #Pythian on Twitter. Have a question? Use our hashtag and ask away.

Emergency

24x7 Support

Not a Pythian client but need help now? No problem. Click here.

Are you aware of an existing DBA opening or consulting requirement in your organization? Enter your email for a chance to win one year's access to Safari Books.

  

Oracle 10.2.0.3 Patchset - Known Issues and Bugs

By: Alex Gorbachev

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

  1. 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

Start NowWith Pythian - database design, management and emergency handling capabilities...

Pythian Blog

Connecting to Oracle with SQL Server 2005 x64
The quirks of connecting to Oracle from SQL 2005 64
more



Live Updates

pythian: Join us for a webinar June 4: Migrating to an Open Source DB Platform. Paul Vallee speaking. Register at
more



RSSTestimonials

  • Casey Dyke

    Database Team Manager Service Delivery and Applications , Telstra

    Pythian were recently engaged to take a lead role in a high end infrastructure build project at Telstra. Our requirements were a combination of... more