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 9.2.0.8 Released, Major Bug Fixes

By: Marc Fielding

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

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 updates.oracle.com
Connected to bigip-aru.oracle.com.
220 FTP server ready.
User (bigip-aru.oracle.com:(none)):
331 Username OK, please send password.
Password:
230-
230-           Welcome to the Oracle Patch Download FTP Server
230-
230- For detailed help, use command "quote site help".
230
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 p4547809_92080_HP64.zip
-r--r--r--   1 root     other    173812249 Aug 22 09:37 p4547809_92080_MVS.zip
-r--r--r--   1 root     other    257710303 Aug 21 23:17 p4547809_92080_WINNT.zip
-r--r--r--   1 root     other    378323336 Aug 22 09:10 p4547809_92080_WINNT64.zip
226 Listing complete. Data connection has been closed.
ftp: 336 bytes received in 0.00Seconds 336000.00Kbytes/sec.
ftp>

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 9.2.0.6 (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

One Response

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