Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Are 32 bit apps with Oracle 9i possible?

Bill McGarry
Occasional Visitor

Are 32 bit apps with Oracle 9i possible?

Can anyone verify that you can build a 32 bit application with Oracle 9i on HP-UX?
Someone here at work believes that we must convert all of our applications to 64-bit in order to link with Oracle 9i libraries.
I've already seen that there is a 32-bit library with Oracle 9i and I don't see any reason why we need to convert.
I have the feeling that the fact that the Oracle 9i server requires a 64 bit platform has been distorted into "everything must be 64 bit". Unfortunately, I have not been able to find any statement in any of Oracle documents or web pages that clearly states "you CAN build a 32 bit app with Oracle 9i libraries."
So -- can I build a 32-bit app with Oracle 9i libraries? Is there any reason to switch my Oracle app to 64-bit other than if the app needs more memory or is there anything that I cannot do with the 32 bit libraries?

Thanks!
Bill
7 REPLIES
Christopher Caldwell
Honored Contributor

Re: Are 32 bit apps with Oracle 9i possible?

You can certainly point a 32-bit client at a 64-bit database (SQLNet "normalizes" the communication).

James A. Donovan
Honored Contributor

Re: Are 32 bit apps with Oracle 9i possible?

 
Remember, wherever you go, there you are...
A. Clay Stephenson
Acclaimed Contributor

Re: Are 32 bit apps with Oracle 9i possible?

I tesed a 32-bit client application against a 9i 64-bit server very extensively in December. Absolutely no problems were found. The Pro/C connections were made both directly to the 9i database and through an Oracle listener.
If it ain't broke, I can fix that.
Steven E. Protter
Exalted Contributor

Re: Are 32 bit apps with Oracle 9i possible?

We are running a 64 bit oracle database, 8.1.7.4 in this case against a 32 bit applicatoin server ias 1.0.2.2 PL 12 on HP-UX 11.11 64 bit on an rp5450 server.

No troulbes have been traced to this setup.

It is certified by Oracle.

Here is an oracle migration procedure for moving the datagbase from 32 bit to 64 bit environment.(Attached)

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
T G Manikandan
Honored Contributor

Re: Are 32 bit apps with Oracle 9i possible?

Just link against 32-bit libraries that are shipped with Oracle 9i. Just ensure proper SHLIB_PATH settings.

It works
Ravi_8
Honored Contributor

Re: Are 32 bit apps with Oracle 9i possible?

Hi Bill

it's possible to build 32 bit applications with oracle 9i. It's hassle free
never give up
TwoProc
Honored Contributor

Re: Are 32 bit apps with Oracle 9i possible?

No big trick here. Just install the 32 bit version of the database (from Oracle) instead of the 64 bit distribution version. The patch it up and relink it. We used to use the 32 bit version on 64 bit with no problem. In fact, when we first upgraded to Oracle Applications 11.0 on HPUX 11 (64 bit), the database we ran on was 32 bit. We didn't upgrade to 64 bit until we made the jump to Oracle Applications 11i. A general recommendation would be to run the 64 bit version of HPUX 11i (if possible), instead of 11.0.
We are the people our parents warned us about --Jimmy Buffett