Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle
Brought to you by:
atuining
From: Zane A. <zan...@ya...> - 2011-02-22 15:30:38
|
Hi Please advise if cx_Oracle has ever been built with the following: Python 2.7(or 2.6) Oracle11.2 (64bit) AIX6.1(64bit) gcc-4.2 IBM Power7 Server (Power7 Mode) I've really been battling to get this build and installed. This is my error: ************** python setup.py build running build running build_ext building 'cx_Oracle' extension /opt/freeware/lib/python2.6/config/ld_so_aix xlC_r -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 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. [server01:root:/software/Python/cx_Oracle-5.0.4:] ******************** Please assist. Thanks Zane ________________________________ From: inkblotter <ink...@gm...> To: Zane Ally <zan...@ya...> Cc: cx-...@li... Sent: Sat, December 25, 2010 7:58:47 PM Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle Here's a christmas present for you. See the build line that setup.py provides. setup.py invokes the C compiler, not the C++ compiler. So copy and invoke that build line but replace cc_r with xlC_r by hand and presto! you will have built cx_Oracle.o Then you can run 'python setup.py install' and it will install cx_Oracle.so in python. Try it. I just did this on AIX 6.1. On 12/23/2010 01:25 AM, Zane Ally wrote: cc_r -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -I/app/oracle/product/11.2.0/dbhome_1/rdbms/demo -I/app/oracle/product/11.2.0/dbhome_1/rdbms/public -I/usr/local/include/python2.7 -c cx_Oracle.c -o build/temp.aix-6.1-2.7-10g/cx_Oracle.o -DBUILD_VERSION=5.0.4 |