Re: Oracle Client for 32 bit and 64 bit coexist

On Aug 26, 7:21 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> 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-Hidequoted 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 --

Just for completeness, I must argue that some apps run much better on the server, since they aren't continuously blabbing back and forth over the network. And the security can be much tighter.

It depends. If the alternative is IIS running the app and talking to the db on a risc or such, versus running it together with Oracle on the risc, you can guess why I bother to say this. Sometimes the new ways aren't better ways. On an app where I tested this (uses OCI), even running app on one risc machine and db on another was noticeably slower at the end user level - that also is why they re-architected 9iAS Portal, I'm convinced. The newer version of my app says it "requires" two-task, though, so may be slower having to bother with tcp layers on the hp-ux Itanium I'm now using. I haven't yet figured out exactly what that issue is (since it's working sometimes with the local protocol but not other times), but just thinking out loud here gives me some ideas on what to investigate, so thanks!

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20080826/news_1b26idtheft.html