On Aug 26, 7:21 am, Mark D Powell <Mark.Pow....TakeThisOut@eds.com> wrote:
> On Aug 22, 1:24 pm, "P.L." <panli....TakeThisOut@hotmail.com> wrote:
>
>
>
>
>
> > On Aug 22, 12:53 pm, DA Morgan <damor....TakeThisOut@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....TakeThisOut@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 >> Stay informed about: Oracle Client for 32 bit and 64 bit coexist 
FAQ
Profile
Private Messages
Log in
