Showing results for 
Search instead for 
Did you mean: 

Oracle 9i and 32 bit app?

Dan Maytum
Occasional Visitor

Oracle 9i and 32 bit app?

We just upgraded from Oracle 8.1 to 9.2 on HP-UX 11.11. I'm using a Brio reporting tool that has a repository on the Oracle database. Brio is a 32 bit app so I changed the SH_LIB PATH to SH_LIB_PATH=$ORACLE_HOME/lib32 and these lib files are installed, but I'm getting the following error:

/usr/lib/ unresolved symbol: gethrtime (code) from {$ORACLE_HOME}:/lib32/ Badly placed ( ) 's

I'm not a DBA and I'm not quite sure where to go from here. Is this an Oracle patch issue, an HP-UX patch? Has anyone any experience with this?
Steven E. Protter
Exalted Contributor

Re: Oracle 9i and 32 bit app?

You can run 32 bit apps against either a 64 bit or a 32 bit back end Oracle database.

What you need to check, and maybe should have in advance was is the Brio app compatiable with the new version of Oracle.

Thats not automatic.


Might work.

Is it possible you've wiped out table data during the upgrade. I'd also check that you don't have invalid objects in your database.


Steven E Protter
Owner of ISN Corporation
Indira Aramandla
Honored Contributor

Re: Oracle 9i and 32 bit app?

Hi Dan,

You can work in a mixed environment. The database 9i is 64 bit. But there are the 32 libs in lib32, and HP-UX 11.11 is 64-bit.

When you upgrade the database to a higher version, the first thing will be to get advice / confirmation from the application verdor (Brio apps) to check if it is compatable to work with Oracle 9i (64-bit) as it was working with oracle 8i. Or may be there is an application patch / fix to be applied for it to work on 9i.

Generally the error â Unresolved symbolâ occurs when linking with The gethrtime(void) function is a new funtion in libc and is not present in older versions of libraries, so this issue did not appear in prior versions.

If this is a linking issue then you can solve it via installation of the latest Gold Patch provided by HP on SupportPlus CD or the following HP-UX pathces PHCO_23770, PHCO_23092, PHCO_24148 may resolve the linking errors.

Or could be that the was linked with the symbols, but never fully resolved the them. The library needs to be relinked using genclntsh (from $ORACLE_HOME/bin).

Seting the SHLIB_PATH to lib32 and LD_LIBRARY_PATH should make it to use the 32-bit libs.

Never give up, Keep Trying
Ian Thomas
Occasional Visitor

Re: Oracle 9i and 32 bit app?

hi dan,

i've just seen this thread. i'm running (brio) 32-bit reporting tool sqr into an oracle se 64-bit database under hpux11.11 64-bit.

if you are referring to sqr, email me & i can tell you how i modified the sqrmake script to get it to relink sqr when i went from oracle to oracle