<font size=2 face="sans-serif">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:</font><br><br><font size=2 face="sans-serif">1. Installed Oracle Instant Client 10.2.0.4
(which matches our server) Basic and SDK packages as noted in cx_Oracle
documentation. Copied over a tnsnames.ora file from another server.</font><br><br><font size=2 face="sans-serif">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.</font><br><br><font size=2 face="sans-serif">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.)</font><br><br><font size=2 face="sans-serif">At this point, we check the Zope client
log:</font><br><br><font size=2 face="sans-serif">------</font><br><font size=2 face="sans-serif">2009-08-13T14:17:30 ERROR Application
Couldn't install ZcxOracleDA</font><br><font size=2 face="sans-serif">Traceback (most recent call last):</font><br><font size=2 face="sans-serif"> File "/opt/Plone-3.1/zeocluster/parts/zope2/lib/python/OFS/Application.py",
line 758, in install_product</font><br><font size=2 face="sans-serif"> global_dict, global_dict,
silly)</font><br><font size=2 face="sans-serif"> File "/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/__init__.py",
line 20, in ?</font><br><font size=2 face="sans-serif"> import DA</font><br><font size=2 face="sans-serif"> File "/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/DA.py",
line 15, in ?</font><br><font size=2 face="sans-serif"> from db import DB</font><br><font size=2 face="sans-serif"> File "/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/db.py",
line 14, in ?</font><br><font size=2 face="sans-serif"> import cx_Oracle, datetime</font><br><font size=2 face="sans-serif"> File "build/bdist.linux-x86_64/egg/cx_Oracle.py",
line 7, in ?</font><br><font size=2 face="sans-serif"> File "build/bdist.linux-x86_64/egg/cx_Oracle.py",
line 6, in __bootstrap__</font><br><font size=2 face="sans-serif">ImportError: libclntsh.so.10.1: cannot
open shared object file: No such file or directory</font><br><font size=2 face="sans-serif">------</font><br><br><font size=2 face="sans-serif">$ORACLE_HOME and $LD_LIBRARY_PATH are
being exported from ~/.profile as recommended in the cx_Oracle build document.
They are:</font><br><br><font size=2 face="sans-serif">------</font><br><font size=2 face="sans-serif">kmiweb01:~ # echo $ORACLE_HOME</font><br><font size=2 face="sans-serif">/usr/lib/oracle/10.2.0.4/client64/lib</font><br><font size=2 face="sans-serif">kmiweb01:~ # echo $LD_LIBRARY_PATH</font><br><font size=2 face="sans-serif">:/usr/lib/oracle/10.2.0.4/client64/lib</font><br><font size=2 face="sans-serif">kmiweb01:~ # ls -la $ORACLE_HOME</font><br><font size=2 face="sans-serif">total 98648</font><br><font size=2 face="sans-serif">drwxr-xr-x 4 root root
4096 Aug 13 09:24 .</font><br><font size=2 face="sans-serif">drwxr-xr-x 4 root root
4096 Jul 31 11:17 ..</font><br><font size=2 face="sans-serif">lrwxrwxrwx 1 root root
17 Jul 31 14:11 libclntsh.so -> libclntsh.so.10.1</font><br><font size=2 face="sans-serif">-rw-r--r-- 1 root root 21038613 Mar
12 2008 libclntsh.so.10.1</font><br><font size=2 face="sans-serif">-rw-r--r-- 1 root root 3796601
Mar 12 2008 libnnz10.so</font><br><font size=2 face="sans-serif">lrwxrwxrwx 1 root root
15 Jul 31 14:11 libocci.so -> libocci.so.10.1</font><br><font size=2 face="sans-serif">-rw-r--r-- 1 root root 1664116
Mar 12 2008 libocci.so.10.1</font><br><font size=2 face="sans-serif">-rw-r--r-- 1 root root 72674185 Mar
12 2008 libociei.so</font><br><font size=2 face="sans-serif">-rw-r--r-- 1 root root 138033
Mar 12 2008 libocijdbc10.so</font><br><font size=2 face="sans-serif">drwxr-xr-x 3 root root
4096 Aug 13 09:24 network</font><br><font size=2 face="sans-serif">-rw-r--r-- 1 root root 1555682
Mar 12 2008 ojdbc14.jar</font><br><font size=2 face="sans-serif">drwxrwxr-x 4 root root
4096 Mar 12 2008 sdk</font><br><font size=2 face="sans-serif">kmiweb01:~ #</font><br><font size=2 face="sans-serif">------</font><br><br><font size=2 face="sans-serif">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?</font><br><br><font size=2 face="sans-serif">Thank you,<br>David Murphy<br></font><BR>