Oracle Released, Major Bug Fixes

Posted in: Technical Track

I was looking for known issues under (which are notoriously hard to find by searching MetaLink) and came across this note that mentioned

Looking up patch number 4547809 on Oracle’s FTP site (use your MetaLink credentials to log in), I see that it was released for Windows 32/64-bit, HP/UX 64-bit, and MVS (!) overnight:

C:\Documents and Settings\User>ftp
Connected to
220 FTP server ready.
User ( 
331 Username OK, please send password.
230-           Welcome to the Oracle Patch Download FTP Server
230- For detailed help, use command "quote site help".
ftp> cd 4547809
250 Changed directory OK.
ftp> ls -al
200 PORT command OK.
150 Opening data connection for file listing.
total 1
-r--r--r--   1 root     other    614741565 Aug 22 04:32
-r--r--r--   1 root     other    173812249 Aug 22 09:37
-r--r--r--   1 root     other    257710303 Aug 21 23:17
-r--r--r--   1 root     other    378323336 Aug 22 09:10
226 Listing complete. Data connection has been closed.
ftp: 336 bytes received in 0.00Seconds 336000.00Kbytes/sec.

There’s already one (minor) known issue: a problem with prefetch from pipelined table functions (bug 5068565).

Major bug fixes:

  • corruption in NOCACHE LOB’s under ASSM (5212539)
  • incorrect definitions/ORA-936 from dba_views (4192148)
  • memory corruption using INDIRECT_DATA_BUFFERS with RAC under Linux 32-bit (4926861)
  • ORA-6502 selecting max/min into a char variable (4458790)
  • system stats skewed by “ksu process alloc latch yield” event (4658188)
  • workaround for change of locking for “SELECT FOR UPDATE” operations introduced in (4969880)
  • archivelogs with duplicate names between primary/standby will be deleted by RMAN (2802688)
  • wrong results with max() function on a column with NULL values (4925103)

Full fix list: MetaLink note 358776.1 . Yes it says that AIX is available but there’s no sign of the AIX patchset in the patch download area.

Interesting to see Windows is yet again the first platform to receive the bugfix… a change in platform focus for Oracle perhaps? Then again, the third platform was MVS so maybe it means nothing.

Update: As of August 23, AIX 5L 64-bit, Linux Itanium, and Linux x86-64 have also come out.
Update: As of August 24, Solaris 32 and 64-bit are out
Update: As of August 29, Linux x86 (32-bit) is out

Want to talk with an expert? Schedule a call with our team to get the conversation started.

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

Direct download links for the patches:

AIX5L 64-bit
HP/UX 64-bit
Linux 32-bit
Linux AMD64/EM64T
Linux Itanium 64-bit
Solaris 32-bit
Solaris 64-bit
Windows 32-bit
Windows 64-bit


Leave a Reply

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