Re: [cx-oracle-users] build on aix - unresolved symbols .OCI...

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Your ORACLE_HOME is pointing to 64-bit Oracle libraries, but you are 
building 32-bit so cx_Oracle cannot load the 64-bit Oracle libraries. 
You'll want to use $ORACLE_HOME/lib32 to build 32-bit. This will require 
that you edit the setup.py script to replace all the lib references to 
lib32. Also I believe you will want to build with xlc_r instead of xlc. 
I wouldn't muck with the Makefiles except as a last resort, but rather 
the setup.py script, which only vaguely works out of the box on AIX. I 
don't know what pyDB2 has to do with this, but then I have never built 
with python earlier than 2.4.
Nicola Piazza wrote:
> Hi all,
> I'm trying to compile cx_Oracle-4.1 on Aix, with oracle 9.2. I've modified
> ......./....../lib/python2.3/config/Makefile to use xlc as compiler.
> I've exported my ORACLE_HOME variable, then I've run a python setup.py
> bdist, in order to create a binary version (I haven't compilers
> everywhere).
>
> Compilation seems ok, while I've got a problem during link phase:
>
> # python setup.py bdist
> running bdist
> running bdist_dumb
> running build
> running build_ext
> building 'cx_Oracle' extension
> creating build
> creating build/temp.aix-5.2-2.3
> xlc -DNDEBUG -O -qmaxmem=-1 -qcpluscmt -DAIX_GENUINE_CPLUSCPLUS
> -D_LARGE_FILES -I/ora01/ora9.2/rdbms/demo -I/ora01/ora9.
> 2/rdbms/public -I/ora01/ora9.2/network/public
> -I/opt/freeware/include/python2.3 -c cx_Oracle.c -o build/temp.aix-5.2-2.3
> /cx_Oracle.o -DBUILD_TIME="April 06, 2006 11:49:23"
> creating build/lib.aix-5.2-2.3
> /opt/freeware/lib/python2.3/config/ld_so_aix xlc
> -bI:/opt/freeware/lib/python2.3/config/python.exp build/temp.aix-5.2-2.
> 3/cx_Oracle.o -L/ora01/ora9.2/lib -lclntsh -o build/lib.aix-5.2-2.3
> /cx_Oracle.so -s
> ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2
> ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo
> ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos
> ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary
> ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim
> ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite
> ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary
> ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc
> ld: 0711-317 ERROR: Undefined symbol: .OCILobRead
> ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength
> ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetDate
> ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime
> ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeConstruct
> ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeCheck
> ld: 0711-317 ERROR: Undefined symbol: .OCIDateCheck
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberToInt
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberToText
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberToReal
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromText
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt
> ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName
> ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos
> ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc
> ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach
> ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackRegister
> ld: 0711-317 ERROR: Undefined symbol: .OCIBreak
> ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback
> ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare
> ld: 0711-317 ERROR: Undefined symbol: .OCITransStart
> ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd
> ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease
> ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate
> ld: 0711-317 ERROR: Undefined symbol: .OCIEnvCreate
> ld: 0711-317 ERROR: Undefined symbol: .OCINlsNumericInfoGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtRelease
> ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
> information.
> installing to build/bdist.aix-5.2/dumb
> running install
> running install_lib
> creating build/bdist.aix-5.2
> creating build/bdist.aix-5.2/dumb
> creating build/bdist.aix-5.2/dumb/opt
> creating build/bdist.aix-5.2/dumb/opt/freeware
> creating build/bdist.aix-5.2/dumb/opt/freeware/lib
> creating build/bdist.aix-5.2/dumb/opt/freeware/lib/python2.3
> creating build/bdist.aix-5.2/dumb/opt/freeware/lib/python2.3/site-packages
> tar -cf /tmp/python/source/cx_Oracle-4.1/dist/cx_Oracle-4.1.aix-5.2.tar .
> gzip -f9 /tmp/python/source/cx_Oracle-4.1/dist/cx_Oracle-4.1.aix-5.2.tar
> removing 'build/bdist.aix-5.2/dumb' (and everything under it)
>
> Any suggestion ?
> I've used nm in $ORACLE_HOME/lib to verify who exports these symbols and
> found them in libjmisc.so and in hsdb_ora.so.
>
> Compiler and linker seems ok, since I've correctly compiled PyDB2 module.
> Thank you for your support.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>