Greetings. I'm trying to set up cx_Oracle and ZcxOracleDA on a Plone/Zope server to allow access from our Plone site to our Oracle database. I'm working with one of our developers who was able to successfully get this working on the test environment on his Windows workstation, but getting it set up on our Linux (SLES10, 64-bit) server is proving a little more interesting. Here's what we've done so far:

1. Installed Oracle Instant Client (which matches our server) Basic and SDK packages as noted in cx_Oracle documentation. Copied over a tnsnames.ora file from another server.

2. Installed cx_Oracle 5.0.2 (built from source using Plone's Python). We successfully ran a simple Python script at this point to verify connectivity with the Oracle database.

3. Untarred ZcxOracleDA 0.6 into the Zope server's products directory and restarted the Zope cluster. (Note: There are a few other things I'm leaving out at this point unless they become relevant... we had a couple of other issues that we managed to work through ourselves.)

At this point, we check the Zope client log:

2009-08-13T14:17:30 ERROR Application Couldn't install ZcxOracleDA
Traceback (most recent call last):
  File "/opt/Plone-3.1/zeocluster/parts/zope2/lib/python/OFS/", line 758, in install_product
    global_dict, global_dict, silly)
  File "/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/", line 20, in ?
    import DA
  File "/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/", line 15, in ?
    from db import DB
  File "/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/", line 14, in ?
    import cx_Oracle, datetime
  File "build/bdist.linux-x86_64/egg/", line 7, in ?
  File "build/bdist.linux-x86_64/egg/", line 6, in __bootstrap__
ImportError: cannot open shared object file: No such file or directory

$ORACLE_HOME and $LD_LIBRARY_PATH are being exported from ~/.profile as recommended in the cx_Oracle build document. They are:

kmiweb01:~ # echo $ORACLE_HOME
kmiweb01:~ # echo $LD_LIBRARY_PATH
kmiweb01:~ # ls -la $ORACLE_HOME
total 98648
drwxr-xr-x 4 root root     4096 Aug 13 09:24 .
drwxr-xr-x 4 root root     4096 Jul 31 11:17 ..
lrwxrwxrwx 1 root root       17 Jul 31 14:11 ->
-rw-r--r-- 1 root root 21038613 Mar 12  2008
-rw-r--r-- 1 root root  3796601 Mar 12  2008
lrwxrwxrwx 1 root root       15 Jul 31 14:11 ->
-rw-r--r-- 1 root root  1664116 Mar 12  2008
-rw-r--r-- 1 root root 72674185 Mar 12  2008
-rw-r--r-- 1 root root   138033 Mar 12  2008
drwxr-xr-x 3 root root     4096 Aug 13 09:24 network
-rw-r--r-- 1 root root  1555682 Mar 12  2008 ojdbc14.jar
drwxrwxr-x 4 root root     4096 Mar 12  2008 sdk
kmiweb01:~ #

At this point, we're fairly mystified. The file that ZcxOracleDA's install ultimately complains about is indeed in $ORACLE_HOME, where I would expect it to be looking. We're still able to manually start Plone's Python and import cx_Oracle just fine. Does anyone have any suggestions?

Thank you,
David Murphy

Zope-DB mailing list

Reply via email to