Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
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/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?
3 REPLIES
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.

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

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
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 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
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 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