[Zope] Installing DCOracle2 in AIX 5.1
Debojit Hazarika
debojit.hazarika at db.com
Fri Nov 19 02:13:30 EST 2004
Hello Taewook,
Following your suggestion i tried compiling DCOracle2 for Oracle 8i and it was successfull.
But unfortunately i was not able to do the same for Oracle9i (*which is my actual requirement*)
I failed with the following errors:
*******************************************************************************************************************
/myapp/python/lib/python2.1/ld_so_aix gcc -bI:/myapp/python/lib/python2.1/python.exp build/temp.aix-4.3-2.1/dco2.o -L/applications/oracle/products/9.2.0.5/lib -lclntsh -o build/lib.aix-4.3-2.1/dco2.so
ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
ld: 0711-317 ERROR: Undefined symbol: .OCIEnvCreate
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: .OCISessionEnd
ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree
ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit
ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet
ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet
ld: 0711-317 ERROR: Undefined symbol: .OCIDescribeAny
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName
ld: 0711-317 ERROR: Undefined symbol: .OCIBindDynamic
ld: 0711-317 ERROR: Undefined symbol: .OCIBindArrayOfStruct
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineDynamic
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch
ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc
ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree
ld: 0711-317 ERROR: Undefined symbol: .OCILobIsTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength
ld: 0711-317 ERROR: Undefined symbol: .OCILobRead
ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite
ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
*******************************************************************************************************************
Any idea why it is failing for Oracle9i, how will i be able to fix this "Undefined symbol" error.
Many thanks,
regards
Deb
Taewook Kang
<twkang at gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt at Zentrale
> cc: zope at zope.org
Subject: Re: [Zope] Installing DCOracle2 in AIX 5.1
19/11/04 11:55
Please respond to
Taewook Kang
I only use Oracle 8, and DCOracle2, so I can't help you.
But previously I had compiled DCOracle with Oracle 8 and Python 2.3,
and it worked.
If you compiled DCOracle in your box without problem,
I think it should work.
Regards.
On Fri, 19 Nov 2004 11:00:33 +0530, Debojit Hazarika
<debojit.hazarika at db.com> wrote:
>
>
> Hello Taewook,
>
> I have another question on the same topic, can you please fetch me and answer.
>
> Can i use DCOracle ( *not DCOracle2* ) with Oracle 9i.
>
> I got the following error while trying to use DCOracle with Oracle 9i
>
> *********************************************************************************************************
> >>> import DCOracle
> Traceback (most recent call last):
> File "<stdin>", line 1, in ?
> File "/myapp/python/lib/python2.1/site-packages/DCOracle/__init__.py", line 66, in ?
> from ocidb import Connect, error
> File "/myapp/python/lib/python2.1/site-packages/DCOracle/ocidb.py", line 50, in ?
> import oci_, ociCurs, ociProc
> ImportError: from module /myapp/python/lib/python2.1/site-packages/oci_.so Exec format error
> can't load library: /myapp/python/lib/python2.1/site-packages/oci_.so
> /myapp/oracle/products/9.2.0.5/lib/libclntsh.a shr.o
> /myapp/oracle/products/9.2.0.5/lib/libclntsh.a shr.o
> can't load library: /myapp/oracle/products/9.2.0.5/lib/libclntsh.a
> /myapp/oracle/products/9.2.0.5/lib/libclntsh.a
> *********************************************************************************************************
>
> Is there a way out (maybe some patch) to make DCOracle work with Oracle 9i?
>
>
>
> Many thanks in advance.
>
> Regards
> Deb
>
> Taewook Kang
> <twkang at gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt at Zentrale
> > cc:
> Subject: Re: [Zope] Installing DCOracle2 in AIX 5.1
> 19/11/04 06:37
> Please respond to
> Taewook Kang
>
> You must manually edit setup.py to make it work in AIX.
> Modify CFLAGS, LFLAGS as
> CFLAGS = ["-DNDEBUG", "-DORACLE9i", "-DUSEOBJECT", "-D_REENTRENT"]
> LFLAGS = []
> and remove following lines - AIX doesn't have 'ldd' command. but you
> must be sure
> python compiled with thread support. -
>
> <code>
> st,outp=commands.getstatusoutput('ldd %s' % sys.executable)
> if string.find(outp,'libpth.so')!=-1:
> raise exceptions.RuntimeError,'Python interpreter is linked
> against -lpth. But Python must be linked against -lpthread'
>
> st,outp=commands.getstatusoutput('ldd %s' % sys.executable)
> if string.find(outp,'libpthread')==-1:
> raise exceptions.RuntimeError,'Python must be linked against -lpthread'
> </code>
>
> Now, you can do 'python setup.py install'
> Good luck.
>
> On Thu, 18 Nov 2004 17:36:20 +0530, Debojit Hazarika
> <debojit.hazarika at db.com> wrote:
> > Hello,
> >
> > I am trying to install DCOracle2 (DCOracle2-1.2.tar) in an AIX 5.1 box.
> >
> > I have tried various options but it does not seem to work.
> >
> > When i try to *make* i get the below error
> >
> > *********************************************************************************************************
> > >make
> > (cd src; ./testora python)
> > -n Checking ORACLE_HOME...
> > passed.
> > -n Checking for Oracle version...
> > failed.
> > /u01/app/oracle/product/9.2.0/lib/libclntsh.so not readable; unable to
> > determine your oracle version.
> > make: 1254-004 The error code from the last command is 2.
> >
> > Stop.
> > *********************************************************************************************************
> >
> > Later i tried to follow the instructions in the below link to install it.
> >
> > http://mail.zope.org/pipermail/zope/2002-June/116009.html
> >
> > But this time i got a different error message as mentioned below
> >
> > **********************************************************************************************************
> > >python setup.py install
> > Traceback (most recent call last):
> > File "setup.py", line 36, in ?
> > raise exceptions.RuntimeError,'Python must be linked against -lpthread'
> > RuntimeError: Python must be linked against -lpthread
> > **********************************************************************************************************
> >
> > Can someone please provide me some suggestion to make this right and get
> > DCOracle2 installed for Oracle 9i.
> >
> > Many thanks in advance,
> >
> > Regards
> > Deb
> >
> > --
> >
> > Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
> >
> > This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
> >
> > _______________________________________________
> > Zope maillist - Zope at zope.org
> > http://mail.zope.org/mailman/listinfo/zope
> > ** No cross posts or HTML encoding! **
> > (Related lists -
> > http://mail.zope.org/mailman/listinfo/zope-announce
> > http://mail.zope.org/mailman/listinfo/zope-dev )
> >
>
> --
>
> Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
>
> This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
>
>
--
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
More information about the Zope
mailing list