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.
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/Application.py", line 758, in install_product
global_dict, global_dict, silly)
File "/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/__init__.py", line 20, in ?
import DA
File "/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/DA.py", line 15, in ?
from db import DB
File "/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/db.py", line 14, in ?
import cx_Oracle, datetime
File "build/bdist.linux-x86_64/egg/cx_Oracle.py", line 7, in ?
File "build/bdist.linux-x86_64/egg/cx_Oracle.py", line 6, in __bootstrap__
ImportError: libclntsh.so.10.1: 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
/usr/lib/oracle/10.2.0.4/client64/lib
kmiweb01:~ # echo $LD_LIBRARY_PATH
:/usr/lib/oracle/10.2.0.4/client64/lib
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 libclntsh.so -> libclntsh.so.10.1
-rw-r--r-- 1 root root 21038613 Mar 12 2008 libclntsh.so.10.1
-rw-r--r-- 1 root root 3796601 Mar 12 2008 libnnz10.so
lrwxrwxrwx 1 root root 15 Jul 31 14:11 libocci.so -> libocci.so.10.1
-rw-r--r-- 1 root root 1664116 Mar 12 2008 libocci.so.10.1
-rw-r--r-- 1 root root 72674185 Mar 12 2008 libociei.so
-rw-r--r-- 1 root root 138033 Mar 12 2008 libocijdbc10.so
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 Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
