Oracle Patchset – Known Issues and Bugs

Posted in: Technical Track

Going through my feeds I read from Kevin Closson that Oracle 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 patchset are Windows and Linux 32 bit – Metalink Note 403616.1 “Many Child Cursors create in 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 it’s Metalink Note 401435.1. Happy patching!

Interested in working with Alex? Schedule a tech call.

About the Author

What does it take to be chief technology officer at a company of technology experts? Experience. Imagination. Passion. Alex Gorbachev has all three. He’s played a key role in taking the company global, having set up Pythian’s Asia Pacific operations. Today, the CTO office is an incubator of new services and technologies – a mini-startup inside Pythian. Most recently, Alex built a Big Data Engineering services team and established a Data Science practice. Highly sought after for his deep expertise and interest in emerging trends, Alex routinely speaks at industry events as a member of the OakTable.

1 Comment. Leave new

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:

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

Your email address will not be published. Required fields are marked *