Oracle 10.2.0.3 patchset is out

Posted in: Technical Track

My colleague Vamsi Chikkam noticed that the Oracle 10.2.0.3 patchset has been released for Linux and Windows 32-bit. The major bugfixes are the same as my original post with a few additions:

  • Identical SQL run in different schemas may modify the wrong schema’s tables (bug 5458753)… we have run into this problem at a client site and it’s not pretty. Workarounds include qualifying schema names in SQL and one-off patches for 10.2.0.2. MetaLink note 329673.1 has more details.
  • When cursors are being reloaded frequently in the shared pool, PLS-306/ORA-1722/ORA-1858 errors can occur (bug 4752541)
  • Under Windows platforms, triggers referencing :NEW/:OLD using NCHAR/NVARCHAR character sets can error out (bug 5388136)
  • The same issue as bug 5388136 above also causes compilation errors on 10.2.0.2 databases upgraded from previous releases under Windows(bug 5383828)

Interested in working with Marc? Schedule a tech call.

About the Author

Marc is a passionate and creative problem solver, drawing on deep understanding of the full enterprise application stack to identify the root cause of problems and to deploy sustainable solutions. Marc has a strong background in performance tuning and high availability, developing many of the tools and processes used to monitor and manage critical production databases at Pythian. He is proud to be the very first DataStax Platinum Certified Administrator for Apache Cassandra.

1 Comment. Leave new

I’ve seen that 5458753 problem since 9.2.0.6, in Linux!
Been trying to find any reference on it for ages, thanks for this post.

Unbelievable that such a BASIC security flaw is in Oracle’s code all the way
to 10gr2 and NO ONE has fixed it yet except, presumably, in the 2.0.3 patchset!

About time Oracle started fixing the basics of their flagship product rather than spending their R&D in flights of fancy and “flavour of the day” technologies!

Reply

Leave a Reply

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