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

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

Thank you for your support.

Suggestion to link lib32 instead of lib solved my compilation problem.
Now I'm starting learning cx_oracle usage.

Regards
Nicola Piazza

             Nicola                                                        
             Piazza/Italy/IBM                                              
                                                                        To 
             04/06/2006 11:54          cx-...@li...urceforge.n 
             AM                        et                                  
                                                                        cc 

                                                                   Subject 
                                       build on aix - unresolved symbols   
                                       .OCI...                             

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.