Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

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

Hi 

I have now compiled Python2.7 on AIX with gcc and then tried to compile 
cx_oracle5.0.4.
I now get more or less the same error, see below 

[zabcllcdba01:root:/software/Python/cx_Oracle-5.0.4:] python setup.py build
running build
running build_ext
building 'cx_Oracle' extension
gcc -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
In file included from 
/app/oracle/product/11.2.0/dbhome_1/rdbms/public/oci.h:3024,
                 from cx_Oracle.c:10:
/app/oracle/product/11.2.0/dbhome_1/rdbms/public/ociap.h:10788: warning: 
function declaration isn't a prototype
/app/oracle/product/11.2.0/dbhome_1/rdbms/public/ociap.h:10794: warning: 
function declaration isn't a prototype
/usr/local/lib/python2.7/config/ld_so_aix gcc -pthread 
-bI:/usr/local/lib/python2.7/config/python.exp 
build/temp.aix-6.1-2.7-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.7-10g/cx_Oracle.so
ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet
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: .OCINumberFromText
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt
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: .OCIDateTimeGetDate
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineObject
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectFree
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: .OCILobTrim
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: .OCILobRead
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileOpen
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileClose
ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo
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: .OCIHandleAlloc
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: .OCIClientVersion
ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionUnRegister
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectUnpin
ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy
ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback
ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd
ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach
ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease
ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate
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: .OCILobClose
ld: 0711-317 ERROR: Undefined symbol: .OCILobOpen
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: .OCITransPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCITransStart
ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit
ld: 0711-317 ERROR: Undefined symbol: .OCIStringPtr
ld: 0711-317 ERROR: Undefined symbol: .OCIStringSize
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectGetAttr
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: .OCIParamGet
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute
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: .OCIObjectPin
ld: 0711-317 ERROR: Undefined symbol: .OCIDescribeAny
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
error: command '/usr/local/lib/python2.7/config/ld_so_aix' failed with exit 
status 1

Has this cx_oracle5.0.4 source code been compiled on a 64bit AIX environment
(with oracle 11.2 64bit) using gcc and not xlC before? 

It seems as if Oracle11.2 does not have 32bit libs

Thanks
Zane

________________________________
From: Tamás Gulácsi <gt...@gt...>
To: cx-...@li...
Sent: Tue, December 14, 2010 12:53:31 PM
Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

 Hi Zane,

> What about the suggested
> file $(which python); ldd $(which python)
> commands?
>

??? result ???

>
> 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.
>

So it is even clearer now: Python was build with cc_r, but you want to
use gcc - this will not work for sure.

Tamás Gulácsi

------------------------------------------------------------------------------
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