Oracle 9i and 32 bit app?

[Dan Maytum]

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/dld.sl: unresolved symbol: gethrtime (code) from {$ORACLE_HOME}:/lib32/libclntsh.sl 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]

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.

Next, SHLIB_PATH=$SHLIB_PATH:$ORACLE_HOME/lib32

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.

SEP

[Indira Aramandla]

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 libclntsh.sl. 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 libclntsh.sl 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.


Indira

[Ian Thomas]

hi dan,

i've just seen this thread. i'm running (brio) 32-bit reporting tool sqr into an oracle 9.2.0.5 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 8.1.7.4 to oracle 9.2.0.5

ianthomas@marshallaerospace.com