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

On Jan 19, 1:15 pm, "Charles Hooper" <hooperc2..._at_yahoo.com> wrote:
> Comments embedded.
>
> Shailesh wrote:
> > Hello,
>
> > Currently our environment is on 10g Release 2, OS windows 2000/2003
> > standard edition 32 bit. We use shared server to take advantage of
> > scalability and connecting maximum no of simultaneous connections to
> > the database. Now we take advantage of memory beyond 4GB we are
> > planning to check following.
>
> > 64 bit Windows 2003 standard edition on AMD64/EM64T Servers.
>
> > 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
>
> > Do we need to take care of any other issues?Take a look at large page support, and consider using it with Oracle.
> Read the platform specific manuals provided by Oracle.
>
> > Kindly share your experiences and help me to get the answers of these
> > questions.
>
> > Thanks & Regards,
>
> > ShaileshRegarding your other questions about switching to Linux, that decision
> should depend on your familiarity with Linux. If you have no
> experience with Linux, it likely will be best to stay with the Windows
> version of the database. If you have extensive experience with Linux,
> consider using an enterpise version of Linux - verify that the version
> selected is a supported platform.
>
> 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