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@gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt@Zentrale > cc: zope@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@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@gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt@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@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@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.