Re: Oracle Client for 32 bit and 64 bit coexist

On Aug 22, 1:24 pm, "P.L." <panli..._at_hotmail.com> wrote:
> On Aug 22, 12:53 pm, DA Morgan <damor..._at_psoug.org> wrote:
>
>
>
>
>
> > P.L. wrote:
> > > Dear Experts,
>
> > > We met an issue with Oracle client, and hope you could give us some
> > > advice.
>
> > > On our Windows 2003 64 bit servers, currently we have Oracle Client 32
> > > bit installed using by an application. However, running our MS.NET
> > > programs on x64 Windows require Oracle client for 64 bit installed.
> > > Otherwise, an error would be given:
>
> > > "Exception: Attempt to load Oracle client libraries threw
> > > BadImageFormatException. This problem will occur when running in 64
> > > bit mode with the 32 bit Oracle client components installed."
>
> > > Is that possible to install both 32 bit Oracle client and 64 bit
> > > Oracle client on the same server so that different programs could talk
> > > to different Oracle clients?
>
> > > Or any other solutions would be highly appreciated.
>
> > > Thanks a lot,
>
> > > P.L.
>
> > Oracle 32bit and 64bit software can coexist. But I am puzzled as to
> > why you would put client software on a server.
> > --
> > Daniel A. Morgan
> > Oracle Ace Director & Instructor
> > University of Washington
> > damor..._at_x.washington.edu (replace x with u to respond)
> > Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text -
>
> > - Show quoted text -
>
> Thanks Daniel.
> The reason that we have to put the oracle client on servers is because
> the server application should connect Oracle databases on other
> database servers.- Hide quoted text -
>
> - Show quoted text -

The application should not run on the same server as the database. A database server should be dedicated to running the database. The application should be on its own server and the client should be installed on the application server. It is possible to run the client on the database server; it is just not generally a good idea from security, performance, and upgrade consideration points of view.

IMHO -- Mark D Powell -- Received on Tue Aug 26 2008 - 09:21:04 CDT