Mailing List Archive: Installing DCOracle2 with Oracle 10g

Installing DCOracle2 with Oracle 10g

Sep 28, 2005, 11:38 AM

Post #1 of 9 (3385 views)

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@optaros.com
v: 617.227.1855 ext. 107
f: 617.227.1755
m: 617.852.2956

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Installing DCOracle2 with Oracle 10g [ In reply to ]

matt at bane

Sep 28, 2005, 6:53 PM

Post #2 of 9 (3263 views)

Permalink

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@optaros.com
> v: 617.227.1855 ext. 107
> f: 617.227.1755
> m: 617.852.2956
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Installing DCOracle2 with Oracle 10g [ In reply to ]

sgottlieb at optaros

Sep 28, 2005, 7:34 PM

Post #3 of 9 (3276 views)

Permalink

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@optaros.com
>> v: 617.227.1855 ext. 107
>> f: 617.227.1755
>> m: 617.852.2956
>>
>> _______________________________________________
>> Zope-DB mailing list
>> Zope-DB@zope.org
>> http://mail.zope.org/mailman/listinfo/zope-db
>
>
>

--
Seth Gottlieb
Optaros, Inc.
60 Canal Street
Boston, MA 02114
e: sgottlieb@optaros.com
v: 617.227.1855 ext. 107
f: 617.227.1755
m: 617.852.2956

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Installing DCOracle2 with Oracle 10g [ In reply to ]

matt at bane

Sep 29, 2005, 6:32 AM

Post #4 of 9 (3272 views)

Permalink

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@optaros.com
>>> v: 617.227.1855 ext. 107
>>> f: 617.227.1755
>>> m: 617.852.2956
>>>
>>> _______________________________________________
>>> Zope-DB mailing list
>>> Zope-DB@zope.org
>>> http://mail.zope.org/mailman/listinfo/zope-db
>>
>>
>>
>
> --
> Seth Gottlieb
> Optaros, Inc.
> 60 Canal Street
> Boston, MA 02114
> e: sgottlieb@optaros.com
> v: 617.227.1855 ext. 107
> f: 617.227.1755
> m: 617.852.2956

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Installing DCOracle2 with Oracle 10g [ In reply to ]

sgottlieb at optaros

Sep 29, 2005, 7:57 AM

Post #5 of 9 (3261 views)

Permalink

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.
>>>>
>>>>
>>>> Thanks,
>>>>
>>>> Seth
>>>>
>>>> --
>>>> Seth Gottlieb
>>>> Optaros, Inc.
>>>> 60 Canal Street
>>>> Boston, MA 02114
>>>> e: sgottlieb@optaros.com
>>>> v: 617.227.1855 ext. 107
>>>> f: 617.227.1755
>>>> m: 617.852.2956
>>>>
>>>> _______________________________________________
>>>> Zope-DB mailing list
>>>> Zope-DB@zope.org
>>>> http://mail.zope.org/mailman/listinfo/zope-db
>>>
>>>
>>>
>>>
>>
>> --
>> Seth Gottlieb
>> Optaros, Inc.
>> 60 Canal Street
>> Boston, MA 02114
>> e: sgottlieb@optaros.com
>> v: 617.227.1855 ext. 107
>> f: 617.227.1755
>> m: 617.852.2956
>
>
>

--
Seth Gottlieb
Optaros, Inc.
60 Canal Street
Boston, MA 02114
e: sgottlieb@optaros.com
v: 617.227.1855 ext. 107
f: 617.227.1755
m: 617.852.2956

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Installing DCOracle2 with Oracle 10g [ In reply to ]

jet.wilda at kobie

Sep 29, 2005, 8:10 AM

Post #6 of 9 (3266 views)

Permalink

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@optaros.com>
> Subject: Re: [Zope-DB] Installing DCOracle2 with Oracle 10g
> To: "Matthew T.Kromer" <matt@bane.mi.org>
> Cc: zope-db@zope.org
> Message-ID: <433C00D3.5060407@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.
> >>>>
> >>>>
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Installing DCOracle2 with Oracle 10g [ In reply to ]

sgottlieb at optaros

Sep 29, 2005, 12:22 PM

Post #7 of 9 (3270 views)

Permalink

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@optaros.com>
>>Subject: Re: [Zope-DB] Installing DCOracle2 with Oracle 10g
>>To: "Matthew T.Kromer" <matt@bane.mi.org>
>>Cc: zope-db@zope.org
>>Message-ID: <433C00D3.5060407@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@optaros.com
v: 617.227.1855 ext. 107
f: 617.227.1755
m: 617.852.2956

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Installing DCOracle2 with Oracle 10g [ In reply to ]

dario at ita

Oct 24, 2005, 12:15 AM

Post #8 of 9 (3247 views)

Permalink

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
>
>

hi,

I just had reason to go back to use DCOracle2 on Linux and Oracle 10g

Your Howto indicates that PDO is needed in order to compile DCO2. I do
not recognise this requirement - granted I have been absent from the
DCO2 world for some time, but is PDO a new requirement?

Thanks,

/dario

--
-- -------------------------------------------------------------------
Dario Lopez-Ka"sten, IT Systems & Services Chalmers University of Tech.
Lyrics applied to programming & application design:
"emancipate yourself from mental slavery" - redemption song, b. marley
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Installing DCOracle2 with Oracle 10g [ In reply to ]

sgottlieb at optaros

Oct 24, 2005, 6:14 AM

Post #9 of 9 (3253 views)

Permalink

I didn't do anything with PDO either.

I just:
* Put files from the full Oracle install some header files into
the directory rdbms/public and network (neither of which are created by
the version of the Instant Client that I installed). I found the
instructions most helpful
(http://www.gossamer-threads.com/lists/zope/db/177133).
* changed all instances (3) of "dword *" to "dvoid *" in src/dco2.c
* changed "DEFS= @DEFS@" to "DEFS= " in src/Makefile
* commented all the Oracle detection logic in src/testora and hard
coded:
o ORADEF="-DORACLE10g -DUSEOBJECT -DNATIVENUMERIC"
o ORAINCLUDES="-lclntsh"

--Seth

Dario Lopez-Kästen wrote:
> 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
>>
>>
>
> hi,
>
> I just had reason to go back to use DCOracle2 on Linux and Oracle 10g
>
> Your Howto indicates that PDO is needed in order to compile DCO2. I do
> not recognise this requirement - granted I have been absent from the
> DCO2 world for some time, but is PDO a new requirement?
>
> Thanks,
>
> /dario
>
>

--
Seth Gottlieb
Optaros, Inc.
60 Canal Street
Boston, MA 02114
e: sgottlieb@optaros.com
v: 617.227.1855 ext. 107
f: 617.227.1755
m: 617.852.2956
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db