Are 32 bit apps with Oracle 9i possible?

[Bill McGarry]

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

[Christopher Caldwell]

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

[A. Clay Stephenson]

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.

[Steven E. Protter]

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

[T G Manikandan]

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

It works

[Ravi_8]

Hi Bill

it's possible to build 32 bit applications with oracle 9i. It's hassle free

[TwoProc]

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.