[Zope-DB] ZcxOracleDA configuration assistance

[Charlie Clark]

Am 17.08.2009, 15:05 Uhr, schrieb <DMurphy at kalsec.com>:

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

Given that it works when you run Python manually but not when you start  
the cluster the problem is likely to be that your Zope user doesn't have  
the right permissions to access the library.

Charlie Clark
-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try our new mxODBC.Connect Python Database Interface for free ! ::::


    eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
            Registered at Amtsgericht Duesseldorf: HRB 46611
                http://www.egenix.com/company/contact/