[Zope-DB] Installing DCOracle2 with Oracle 10g
Seth Gottlieb
sgottlieb at optaros.com
Thu Sep 29 15:22:47 EDT 2005
Excellent. I put a link to your instructions here:
http://zopewiki.org/Oracle. Pardon the double comment. It didn't seem to
take the first time.
--Seth
Jet Wilda wrote:
>Here http://www.zope.org/Members/jetfu/HowToInstallDcOracle2/howto_view
>is a how to I wrote up on how I got DCOracle2 to install with Oracle 10g
>
>Jet
>
>
>
>>Message: 6
>>Date: Thu, 29 Sep 2005 10:57:23 -0400
>>From: Seth Gottlieb <sgottlieb at optaros.com>
>>Subject: Re: [Zope-DB] Installing DCOracle2 with Oracle 10g
>>To: "Matthew T.Kromer" <matt at bane.mi.org>
>>Cc: zope-db at zope.org
>>Message-ID: <433C00D3.5060407 at optaros.com>
>>Content-Type: text/plain; charset=US-ASCII; format=flowed
>>
>>I think that did the trick. It seemed to compile. This is
>>what I did for
>>those who also run into the same trouble:
>>
>>changed all instances (3) of "dword *" to "dvoid *" in src/dco2.c
>>changed "DEFS= @DEFS@" to "DEFS= " in src/Makefile
>>skipped all the Oracle detection logic and hard coded:
>>ORADEF="-DORACLE10G"
>>ORAINCLUDES="-lclntsh"
>>
>>One thing that I did notice is that compiling this way was very quick
>>and did not have any kind of success message. At the end of
>>the compile
>>you will notice that a dco2.so was moved into the DCOracle2 directory.
>>
>>Thanks Matt for the tips.
>>
>>--Seth
>>
>>
>>Matthew T.Kromer wrote:
>>
>>
>>
>>>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.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>
>
>
--
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
More information about the Zope-DB
mailing list