Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit)

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

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

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
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'
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:]
**************** 

Thanks
Zane

________________________________
From: inkblotter <ink...@gm...>
To: cx-...@li...
Sent: Tue, December 14, 2010 4:36:12 AM
Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit)

I have built many version of cx_Oracle on AIX 6.1, most recently with xlC_r  10 
compiler, against Oracle 10 and 11.2.  All 64-bit.

It takes a fair amount of finesse to build it, and depends on how you build 
python as well.  I recommend the latest version of cx_Oracle source code.   

I have built cx_Oracle against python 3.2 as well as against python 2.4--2.7, 64 
bit on many different platforms.

On AIX  you cannot expect to simply type 'python setup.py build', and expect it 
to work.  So please be specific: oslevel -s,  xlC_r -qversion, python -V and the 
error you are encountering and I will try to help.

If you have problems you cannot resolve please raise those issues on this 
mailing list.

BTW , it doesn't matter that you have no 32-bit libs.  That complaint is proably 
specious.  It may mean that your python was built 32-bit and that would be a 
problem.   file `which python` and ldd `which python` might give some clues.

On 12/13/2010 04:19 PM, Zane Ally wrote: 
Hi
>
>Please advise if source is available for cx_oracle to be compiled on AIX6.1 
>running Oracle 11.2 64bit.
>Have some problems compiling this on the system above on a IBM Power7 Server.
>
>Is this the issue with Oracle11.2 not having 32bit libraries?
>I do not see any lib32 libraries in my Oracle 11.2 Enterprise Edition install on 
>AIX6.1
>
>
>Please assist
>
>Thanks
>Zane
>
> ------------------------------------------------------------------------------ 
>Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the 
>dots, take your collaborative environment to the next level, and enter the era 
>of Social Business. http://p.sf.net/sfu/lotusphere-d2d
> _______________________________________________ cx-oracle-users mailing list 
>cx-...@li... 
>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users   
>