[Zope-DB] Installing DCOracle2 with Oracle 10g

[Matthew T.Kromer]

Heh, I should have read the problem a bit closer:

>>> i686-pc-linux-gnu-gcc -pthread -shared ./dco2.o  
>>> -L/usr/lib/oracle/10.1.0.4/client/lib/ -lclntsh -lcommon -lcore4  
>>> -lnlsrtl3 -Wl,-rpath,/usr/lib/oracle/10.1.0.4/client/lib -o  
>>> ./dco2.so
>>> /usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.5-20050130/../../../../i686- 
>>> pc- linux-gnu/bin/ld: cannot find -lcommon
>>> collect2: ld returned 1 exit status
>>> make[1]: *** [dco2.so] Error 1

It looks to me like the makefile thinks you're running Oracle 8.0; not  
Oracle 10.  Take a peek in the testora script in the src directory;  
you'll probably want to tweak it to skip the detections for oracle  
version and ends up making that call to sed at the bottom; for anything  
higher than Oracle 8.0 you should only need to link  -lclntsh in.  Also  
set the -DORACLE8i and -DORACLE9 defines manually, I expect.  That will  
cause the code to compile slightly differently.

On Sep 28, 2005, at 10:34 PM, Seth Gottlieb wrote:

> Thanks for responding. I commented out line 92:
> #include <stdio.h>
>
> and moved
> #include <Python.h>
> (which was around line 126) to the first of the includes. I still get  
> the same error message. Anything else to try?
>
> Thanks,
>
> Seth
>
> Matthew T. Kromer wrote:
>
>> Not sure, but I think DCOracle2 includes both Python.h and stdio.h --  
>> try removing stdio.h and making the python.h include the first  
>> include.
>>
>>
>> On Sep 28, 2005, at 2:38 PM, Seth Gottlieb wrote:
>>
>>> I have been trying to compile DCOracle2 and found the instructions  
>>> from "evstumpf at ucdavis."
>>>
>>> When I do that, I get the error message:
>>>
>>> i686-pc-linux-gnu-gcc -pthread -fPIC -DNDEBUG  
>>> -I/usr/include/python2.3 -I/usr/include/python2.3 @DEFS@  
>>> -I/usr/lib/oracle/10.1.0.4/client/rdbms/demo  
>>> -I/usr/lib/oracle/10.1.0.4/client/network/public  
>>> -I/usr/lib/oracle/10.1.0.4/client/plsql/public  
>>> -I/usr/lib/oracle/10.1.0.4/client/rdbms/public -DUSEOWNXID -c  
>>> ././dco2.c -o ./dco2.o
>>> i686-pc-linux-gnu-gcc: cannot specify -o with -c or -S and multiple  
>>> compilationsmake[1]: *** [dco2.o] Error 1
>>>
>>> Then I followed the idea to change DEFS to nothing in the post by  
>>> Matt at Bane:
>>>
>>> DEFS=@DEFS@
>>> to
>>> DEFS=
>>>
>>> When I do this, I get:
>>>
>>> i686-pc-linux-gnu-gcc -pthread -fPIC -DNDEBUG  
>>> -I/usr/include/python2.3 -I/usr/include/python2.3  
>>> -I/usr/lib/oracle/10.1.0.4/client/rdbms/demo  
>>> -I/usr/lib/oracle/10.1.0.4/client/network/public  
>>> -I/usr/lib/oracle/10.1.0.4/client/plsql/public  
>>> -I/usr/lib/oracle/10.1.0.4/client/rdbms/public -DUSEOWNXID -c  
>>> ././dco2.c -o ./dco2.o
>>> In file included from /usr/include/python2.3/Python.h:8,
>>> from dco2.c:125:
>>> /usr/include/python2.3/pyconfig.h:856:1: warning: "_POSIX_C_SOURCE"  
>>> redefined
>>> In file included from /usr/include/stdio.h:28,
>>> from dco2.c:92:
>>> /usr/include/features.h:190:1: warning: this is the location of the  
>>> previous definition
>>> i686-pc-linux-gnu-gcc -pthread -shared ./dco2.o  
>>> -L/usr/lib/oracle/10.1.0.4/client/lib/ -lclntsh -lcommon -lcore4  
>>> -lnlsrtl3 -Wl,-rpath,/usr/lib/oracle/10.1.0.4/client/lib -o  
>>> ./dco2.so
>>> /usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.5-20050130/../../../../i686- 
>>> pc- linux-gnu/bin/ld: cannot find -lcommon
>>> collect2: ld returned 1 exit status
>>> make[1]: *** [dco2.so] Error 1
>>>
>>> My environment is:
>>> Python: 2.3.4
>>> Zope: 2.3.4
>>> OS: Gentoo
>>> Oracle: Instant Client 10.1.0.4 with extra .h files from the full  
>>> install. put into rdbms/public:
>>> nzerror.h
>>> nzt.h
>>> occi.h
>>> occiAQ.h
>>> occiCommon.h
>>> occiControl.h
>>> occiData.h
>>> occiObjects.h
>>> oci.h
>>> oci1.h
>>> oci8dp.h
>>> ociap.h
>>> ociapr.h
>>> ocidef.h
>>> ocidem.h
>>> ocidfn.h
>>> ociextp.h
>>> ocikpr.h
>>> ocixmldb.h
>>> odci.h
>>> oratypes.h
>>> ori.h
>>> orid.h
>>> orl.h
>>> oro.h
>>> ort.h
>>> xa.h
>>>
>>>
>>>
>>> Some observations....
>>> The error messages says that I should have .h files under rdbms/demo  
>>> but mines does not have any and I was unable to find them anywhere.
>>>
>>>
>>> Thanks,
>>>
>>> Seth
>>>
>>> -- 
>>> Seth Gottlieb
>>> Optaros, Inc.
>>> 60 Canal Street
>>> Boston, MA 02114
>>> e: sgottlieb at optaros.com
>>> v: 617.227.1855 ext. 107
>>> f: 617.227.1755
>>> m: 617.852.2956
>>>
>>> _______________________________________________
>>> Zope-DB mailing list
>>> Zope-DB at zope.org
>>> http://mail.zope.org/mailman/listinfo/zope-db
>>
>>
>>
>
> -- 
> Seth Gottlieb
> Optaros, Inc.
> 60 Canal Street
> Boston, MA 02114
> e: sgottlieb at optaros.com
> v: 617.227.1855 ext. 107
> f: 617.227.1755
> m: 617.852.2956