[Zope-DB] Oracle problems! Can anyone help!

[Matthew T. Kromer]

Tim Bailey wrote:

>
>
>I therefore assumed that I would need to build the dco2(.so) from scratch
>and promptly delved into trying to use make.  This did not go to plan and
>consequently it didn't work and returned the following:
>
>[zadmin@mcllinux ZOracleDA]$ make
>(cd src; \
>./testora /usr/local/zope/2-4-3/bin )
>/bin/sh: ./testora: No such file or directory
>make: *** [.config] Error 126
>
>I would really appreciate some help on this as Zope is definitely the way
>forward but we need to get it fully functional on our Linux PC as the site
>is getting bigger and my PC can't handle it!!
>
>Regards,
>
>a very frustrated
>
>Tim Bailey
>

Hi Tim,

As a few people have already pointed out, the most expedient thing to do 
is make sure $ORACLE_HOME/lib is included in LD_LIBRARY_PATH.

The DCOracle2 installer is *very* simple and *very* stupid.   The 
installer just tries to copy a file from the binaries/ directory to the 
DCOracle2/ directory, renaming it along the way.  The Makefile is fairly 
simplistic also; you probably needed to edit the Makefile and change the 
PYTHON defined value to $ZOPE_HOME/bin/python so it picked up the right 
python to do the compile.

If you build your own .so file (ie run the compile yourself) the binary 
is marked with the location of the Oracle shared libraries -- in which 
case, you dont need to set LD_LIBRARY_PATH.