Re: [Zope] Installing DCOracle2 in AIX 5.1

19 Nov 2004

      The libclntsh.a file does exist in $ORACLE_HOME/lib.

The problem here is when i try to build the "dco2.so" pointing $ORACLE_HOME to an oracle 8 installation with the below command it builds the "dco2.so" file successfully.

/myapp/python/lib/python2.1/ld_so_aix gcc -bI:/myapp/python/lib/python2.1/python.exp build/temp.aix-5.1-2.1/dco2.o -L$ORACLE_HOME/lib -lclntsh -o build/lib.aix-5.1-2.1/dco2.so

But when i try to build th"e dco2.so" pointing $ORACLE_HOME to an oracle 9 installation i end up getting the following errors:

/myapp/python/lib/python2.1/ld_so_aix gcc -bI:/myapp/python/lib/python2.1/python.exp build/temp.aix-5.1-2.1/dco2.o -L$ORACLE_HOME/lib -lclntsh -o build/lib.aix-5.1-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-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status

Any idea why i am getting this error?

However i don't have the "libclntsh.so" file in $ORACLE_HOME/lib,     is that the reason???
If so how to get this "libclntsh.so" file?

Can anyone please suggest some hints on this.

Many thanks,

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 13:40                                                                                                               
                      Please respond to                                                                                                            
                      Taewook Kang                                                                                                                 

How about checking existence of libclntsh.a in $ORACLE_HOME/lib?
or if You have 64bit oracle, and 32 bit python compiled by gcc,
it might be matters.

Anyway, those not-found symbols are in libclntsh.a,
and you need that file for linking. :)

Good luck

On Fri, 19 Nov 2004 12:43:30 +0530, Debojit Hazarika
<debojit.hazarika@db.com> wrote:
...
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.
--

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.

Debojit Hazarika

tags

participants (1)