Re: Static linking problems with Oracle

meijerink87_at_zonnet.nl wrote:
> Hi,
> I've got a problem when linking our program against Oracle 8.1.7.
>
> With previous versions of Oracle we used to compile with static
> libraries. I tried a lot of things, of which I will show some attempts.
> The first lines mention the used libs, followed by the errors I got.
> Can anyone tell me what libs to use?
>
> Bye,
> Jack.
>
> I compile on a machine running IBM AIX 5.1 and Oracle 8.1.7!
> I run the executable on a different machine running IBM AIX 5.1 and
> Oracle 7.3.4!
>
> no oraclelibs
> -------------
> ld: 0711-317 ERROR: Undefined symbol: .oerhms
> ld: 0711-317 ERROR: Undefined symbol: .ologof
> ld: 0711-317 ERROR: Undefined symbol: .orlon
> ld: 0711-317 ERROR: Undefined symbol: .ocon
> ld: 0711-317 ERROR: Undefined symbol: .ocof
> ld: 0711-317 ERROR: Undefined symbol: .ocom
> ld: 0711-317 ERROR: Undefined symbol: .orol
> ld: 0711-317 ERROR: Undefined symbol: .odefin
> ld: 0711-317 ERROR: Undefined symbol: .obndrn
> ld: 0711-317 ERROR: Undefined symbol: .oexec
> ld: 0711-317 ERROR: Undefined symbol: .oclose
> ld: 0711-317 ERROR: Undefined symbol: .ofetch
> ld: 0711-317 ERROR: Undefined symbol: .oopen
> ld: 0711-317 ERROR: Undefined symbol: .osql3
>
> libclntst8.a /usr/lib/libpthread.a
> ----------------------------------
> ld: 0711-317 ERROR: Undefined symbol: .pw_wait
> ld: 0711-317 ERROR: Undefined symbol: .pw_post
> ld: 0711-317 ERROR: Undefined symbol: .pw_config
> ld: 0711-317 ERROR: Undefined symbol: .aix_ora_pw_version3_required
> ld: 0711-317 ERROR: Undefined symbol: ksmsgl_
> ld: 0711-317 ERROR: Undefined symbol: kcbkclx_
>
> (Using a shared library libclntsh)
> libclntsh.a libxml8.a libcore8.a libnls8.a libcore8.a libnls8.a
> libcore8.a
> --------------------------------------------------------------------------
> No undefined symbols, however on a Oracle 7.3.4 machine, when running
> the application I get the following error:
>
> exec(): 0509-036 Cannot load program ./test because of the following
> errors:
> 0509-022 Cannot load library /usr/lib/libclntsh.a[shr.o].
> 0509-026 System error: A file or directory in the path name
> does not exist.
>
>
> After copying the shared library from the machine with Oracle 8.1.7 to
> the one with 7.3.4 to /usr/lib:
>
> exec(): 0509-036 Cannot load program ./test because of the following
> errors:
> 0509-027 Member shr.o is not found or file is not an archive.
> 0509-027 Member shr.o is not found or file is not an archive.
> 0509-022 Cannot load library /usr/lib/libclntsh.a[shr.o].
> 0509-026 System error: A file or directory in the path name
> does not exist.

1. Do you have LIBPATH pointing to $ORACLE_HOME/lib on the target machine?
2. Do you see libclntsh.a in $ORACLE_HOME/lib on the target machine?

You may find this usefull.
http://www-128.ibm.com/developerworks/eserver/pdfs/aix_ll.pdf

Regards
/Rauf Received on Fri May 27 2005 - 10:02:29 CDT