Re: 32 bit or 64 bit Oracle on 64 bit OS?

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 19 Jan 2007 08:38:57 -0800
Message-ID: <1169224737.654947.135890@a75g2000cwd.googlegroups.com>

sybrandb wrote:
> On Jan 19, 1:15 pm, "Charles Hooper" <hooperc2..._at_yahoo.com> wrote:
> > Comments embedded.
> >
> > Shailesh wrote:
> > > Hello,
> >
> > > Do we need to install 64 bit Oracle as well?Yes, 64 bit Oracle is required on 64 bit Windows. The 32 bit version
> > of Oracle may work, but is not supported. The 64 bit Standard Edition
> > of Windows 2003 supports up to 32GB of memory. By comparition, the 32
> > bit Standard Edition of Windows 2000/2003 limits each process to 2GB of
> > memory.
> >
> > > Do we need to reinstall Oracle clients with 64 bit installable if
> > > Oracle Server is upgraded to 64 bit?No, you do not need to change the Oracle clients. I still have a
> > couple client computers running the Oracle 8.0.5 client that are
> > connecting to the 64 bit version of Oracle 10.2.0.2.
> >
> > > Is 32 bit Oracle is certified on 64 bit OS?No
> >
> > There have been two recent threads in this group that may help you
> > decide which platform is most appropriate for your needs.
> >
> > Charles Hooper
> > PC Support Specialist
> > K&M Machine-Fabricating, Inc.
>
>
> Charles
> Please refer to the certification matrix for win2003.
> 32-bit Oracle *is* certified, and there are several releases that will
> work with several processors only in 32-bit mode.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Sybrand,

Thanks for asking me to check the certification matrix - I dislike giving out incorrect information, so it is good to check once in a while to see what has changed. On Metalink I found Note:343737.1, last revised June 27, 2006. From that document:

"Oracle Server Product Support - 32-Bit running on 64-Bit x64

---

Oracle does not currently support running the 32-Bit versions of its database
or client software on Windows XP 64-Bit Itanium / Windows 2003 64-Bit Itanium
operating systems. Oracle has however certified the 32-Bit Client software
from 9.2.0.x onwards to run on the Windows XP 64-Bit x64 / Windows 2003 64-Bit
x64 operating systems."

So, it looks like running a 32 bit client on a 64 bit operating system is OK, but it is not supported to run the 32 bit version of the Oracle database on a 64 bit version of Windows 2003.

There could very well be another document on Metalink that contradicts the above quote.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Jan 19 2007 - 10:38:57 CST