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

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,
>
> Shailesh

Regarding 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. Received on Fri Jan 19 2007 - 06:15:36 CST