<tt><font size=2>zope-db-bounces@zope.org wrote on 08/17/2009 02:06:59
PM:<br><br>> From:</font></tt><br><tt><font size=2>> <br>> "Charlie Clark" <charlie@egenix.com></font></tt><br><tt><font size=2>> <br>> To:</font></tt><br><tt><font size=2>> <br>> zope-db@zope.org</font></tt><br><tt><font size=2>> <br>> Date:</font></tt><br><tt><font size=2>> <br>> 08/17/2009 02:04 PM</font></tt><br><tt><font size=2>> <br>> Subject:</font></tt><br><tt><font size=2>> <br>> Re: [Zope-DB] ZcxOracleDA configuration assistance</font></tt><br><tt><font size=2>> <br>> Sent by:</font></tt><br><tt><font size=2>> <br>> zope-db-bounces@zope.org</font></tt><br><tt><font size=2>> <br>> Am 17.08.2009, 15:05 Uhr, schrieb <DMurphy@kalsec.com>:<br>> <br>> > ImportError: libclntsh.so.10.1: cannot open shared object file:
No such <br>> > file or directory<br>> > ------<br>> ><br>> > $ORACLE_HOME and $LD_LIBRARY_PATH are being exported from ~/.profile
as <br>> > recommended in the cx_Oracle build document. They are:<br>> ><br>> > ------<br>> > kmiweb01:~ # echo $ORACLE_HOME<br>> > /usr/lib/oracle/10.2.0.4/client64/lib<br>> > kmiweb01:~ # echo $LD_LIBRARY_PATH<br>> > :/usr/lib/oracle/10.2.0.4/client64/lib<br>> > kmiweb01:~ # ls -la $ORACLE_HOME<br>> > total 98648<br>> > drwxr-xr-x 4 root root 4096 Aug 13 09:24 .<br>> > drwxr-xr-x 4 root root 4096 Jul 31 11:17 ..<br>> > lrwxrwxrwx 1 root root 17 Jul 31 14:11 libclntsh.so
-> <br>> > libclntsh.so.10.1<br>> > -rw-r--r-- 1 root root 21038613 Mar 12 2008 libclntsh.so.10.1<br>> > -rw-r--r-- 1 root root 3796601 Mar 12 2008 libnnz10.so<br>> > lrwxrwxrwx 1 root root 15 Jul 31 14:11 libocci.so
-> <br>> > libocci.so.10.1<br>> > -rw-r--r-- 1 root root 1664116 Mar 12 2008 libocci.so.10.1<br>> > -rw-r--r-- 1 root root 72674185 Mar 12 2008 libociei.so<br>> > -rw-r--r-- 1 root root 138033 Mar 12 2008 libocijdbc10.so<br>> > drwxr-xr-x 3 root root 4096 Aug 13 09:24 network<br>> > -rw-r--r-- 1 root root 1555682 Mar 12 2008 ojdbc14.jar<br>> > drwxrwxr-x 4 root root 4096 Mar 12 2008 sdk<br>> > kmiweb01:~ #<br>> > ------<br>> ><br>> > At this point, we're fairly mystified. The file that ZcxOracleDA's
<br>> > install ultimately complains about is indeed in $ORACLE_HOME,
where I <br>> > would expect it to be looking. We're still able to manually start
<br>> > Plone's Python and import cx_Oracle just fine. Does anyone have
any <br>> > suggestions?<br>> <br>> Given that it works when you run Python manually but not when you
start <br>> the cluster the problem is likely to be that your Zope user doesn't
have <br>> the right permissions to access the library.<br></font></tt><br><tt><font size=2>Thanks for the response. Plone's documentation says
that for the type of install we did, Zope should run as the user "plone"
(I verified this with ps). Unfortunately, even if I chown everything in
$ORACLE_HOME to user plone and restart the cluster again, the error remains
the same.</font></tt><br><br><tt><font size=2>-David Murphy</font></tt><br><BR>