Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit) (Zane Ally)
Brought to you by:
atuining
From: Zane A. <zan...@ya...> - 2010-12-14 08:56:56
|
Hi Tamas Yes, forgot to mention that I installed gcc and then linked the the gcc binary to cc_r as below: ln -s /opt/freeware/bin/gcc /usr/bin/cc_r [zaclppxdba01:root:/home/root:] file $(which python) /usr/bin/python: executable (RISC System/6000) or object module [zaclppxdba01:root:/home/root:] ldd $(which python) /usr/bin/python needs: /usr/lib/threads/libc.a(shr.o) /usr/lib/libpthreads.a(shr_comm.o) /usr/lib/libpthreads.a(shr_xpg5.o) /opt/freeware/lib/libpython2.6.a(libpython2.6.so) /unix /usr/lib/libcrypt.a(shr.o) /usr/lib/libdl.a(shr.o) [zaclppxdba01:root:/home/root:] I installed python rpm and did not compile it. Thanks Zane ________________________________ From: Tamás Gulácsi <gt...@gt...> To: cx-...@li... Sent: Tue, December 14, 2010 10:30:06 AM Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit) (Zane Ally) Date: Tue, 14 Dec 2010 00:00:53 -0800 (PST) >From: Zane Ally <zan...@ya...> >Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle > 11.2(64bit) >To: cx-...@li... >Message-ID: <319...@we...> >Content-Type: text/plain; charset="iso-8859-1" > >Hi > >Thanks for the feedback, much appreciated. >Yes, thought I was being a bit ambitious. > >-No AIX xlC Compiler installed, using gcc. >-Python 2.6 was not compiled, I installed rpm binary >-cx_oracle source?is cx_Oracle-5.0.4.tar.gz > >My environement: > >[zaclppxdba01:root:/home/root:] rpm -aq | grep gcc >gcc-4.2.0-3 > >[zaclppxdba01:root:/home/root:] rpm -aq | egrep "gcc|python" >gcc-4.2.0-3 >python-2.6.2-1 >python-devel-2.6.2-1 > >[zaclppxdba01:root:/home/root:] oslevel -s >6100-05-01-1016 > >[zaclppxdba01:root:/home/root:] python -V >Python 2.6.2 > > This says nothing about the "wideness" of the installed Python (whether it is 32 or 64 bit). What about the suggested file $(which python); ldd $(which python) commands? And the error >? >**************** >[zaclppxdba01:root:/software/Python/cx_Oracle-5.0.4:] python setup.py build >running build >running build_ext >building 'cx_Oracle' extension >cc_r -qlanglvl=extc89 -DNDEBUG -O >-I/app/oracle/product/11.2.0/dbhome_1/rdbms/demo >-I/app/oracle/product/11.2.0/dbhome_1/rdbms/public >-I/opt/freeware/include/python2.6 -c cx_Oracle.c -o >build/temp.aix-6.1-2.6-10g/cx_Oracle.o -DBUILD_VERSION=5.0.4 > This is the command setup.py wants to use to compile cx_Oracle - clearly it uses cc_r, which is an AIX xlc variant. cc_r: unrecognized option '-qlanglvl=extc89' >/opt/freeware/lib/python2.6/config/ld_so_aix cc_r -qlanglvl=extc89 >-bI:/opt/freeware/lib/python2.6/config/python.exp >build/temp.aix-6.1-2.6-10g/cx_Oracle.o -L/app/oracle/product/11.2.0/dbhome_1/lib >-L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o >build/lib.aix-6.1-2.6-10g/cx_Oracle.so >cc_r: unrecognized option '-qlanglvl=extc89' > Seems your version of cc_r is not the same as your Python was built with. ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet >ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet >ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc >ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree >ld: 0711-317 ERROR: Undefined symbol: .OCIStmtRelease >ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalGetDaySecond >ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalSetDaySecond >ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree >ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc >ld: 0711-317 ERROR: Undefined symbol: .OCINumberToReal >ld: 0711-317 ERROR: Undefined symbol: .OCINumberToInt >ld: 0711-317 ERROR: Undefined symbol: .OCINumberToText >ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt >ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromText >ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal >ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet >ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName >ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos >ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet >ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos >ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetDate >ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime >ld: 0711-317 ERROR: Undefined symbol: .OCIStringPtr >ld: 0711-317 ERROR: Undefined symbol: .OCIStringSize >ld: 0711-317 ERROR: Undefined symbol: .OCIIterCreate >ld: 0711-317 ERROR: Undefined symbol: .OCIIterNext >ld: 0711-317 ERROR: Undefined symbol: .OCIIterDelete >ld: 0711-317 ERROR: Undefined symbol: .OCIDefineObject >ld: 0711-317 ERROR: Undefined symbol: .OCIObjectPin >ld: 0711-317 ERROR: Undefined symbol: .OCIDescribeAny >ld: 0711-317 ERROR: Undefined symbol: .OCIObjectFree >ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim >ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite >ld: 0711-317 ERROR: Undefined symbol: .OCILobIsTemporary >ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary >ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary >ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeConstruct >ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeCheck >ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute >ld: 0711-317 ERROR: Undefined symbol: .OCILobFileExists >ld: 0711-317 ERROR: Undefined symbol: .OCILobFileSetName >ld: 0711-317 ERROR: Undefined symbol: .OCILobFileGetName >ld: 0711-317 ERROR: Undefined symbol: .OCILobIsOpen >ld: 0711-317 ERROR: Undefined symbol: .OCILobGetChunkSize >ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength >ld: 0711-317 ERROR: Undefined symbol: .OCILobFileOpen >ld: 0711-317 ERROR: Undefined symbol: .OCILobRead >ld: 0711-317 ERROR: Undefined symbol: .OCILobFileClose >ld: 0711-317 ERROR: Undefined symbol: .OCILobClose >ld: 0711-317 ERROR: Undefined symbol: .OCILobOpen >ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback >ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease >ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare >ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo >ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2 >ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch >ld: 0711-317 ERROR: Undefined symbol: .OCINlsCharSetIdToName >ld: 0711-317 ERROR: Undefined symbol: .OCINlsNameMap >ld: 0711-317 ERROR: Undefined symbol: .OCIPasswordChange >ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionRegister >ld: 0711-317 ERROR: Undefined symbol: .OCIEnvNlsCreate >ld: 0711-317 ERROR: Undefined symbol: .OCINlsNumericInfoGet >ld: 0711-317 ERROR: Undefined symbol: .OCICollSize >ld: 0711-317 ERROR: Undefined symbol: .OCICollGetElem >ld: 0711-317 ERROR: Undefined symbol: .OCIDBStartup >ld: 0711-317 ERROR: Undefined symbol: .OCIDBShutdown >ld: 0711-317 ERROR: Undefined symbol: .OCIPing >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: .OCISessionEnd >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: .OCIClientVersion >ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionUnRegister >ld: 0711-317 ERROR: Undefined symbol: .OCIObjectGetAttr >ld: 0711-317 ERROR: Undefined symbol: .OCIObjectUnpin >ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate >ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy >ld: 0711-317 ERROR: Undefined symbol: .OCISessionGet >ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach >ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin >ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach >ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. >collect2: ld returned 8 exit status >[zaclppxdba01:root:/software/Python/cx_Oracle-5.0.4:] >****************? > Maybe the easiest would be to use your favourite available compiler on that platform, and compile your Python AND cx_Oracle with the same. Tamás Gulácsi |