Oracle Patch 10.2.0.3 – Bugs We’ve Seen

When I read Note: 391116.1 with the full list, I noticed the following bugs that we’ve encountered are fixed.

• the ‘hash group by’ bug with incorrect results: bug 4604970
• the listener may hang in RAC: bug 4518443
• ora-600 [19004] on multitable join – a problem with histograms described in Note:371333.1 and Bug 5041016

Unfortunately, an important bug in 10.2.0.2 posted on the Sept. 29 is not listed as fixed in this patch list. The bug has to do with both data corruption, and security vulnerabilities when running queries that can be interpreted in multiple ways by the SQL parser — depending on what schema has namespace precedence for your signon. In this regard, I would recommend anyone who is running, for example, a test or development copy of their production schemas on the same database, to read the following metalink note without delay.

Note: 392673.1 Bug 5458753 “SQL can execute in wrong schema”.