zope-db-boun...@zope.org wrote on 08/17/2009 02:06:59 PM:

> From:

>
> "Charlie Clark" <char...@egenix.com>

>
> To:

>
> zope-db@zope.org

>
> Date:

>
> 08/17/2009 02:04 PM

>
> Subject:

>
> Re: [Zope-DB] ZcxOracleDA configuration assistance

>
> Sent by:

>
> zope-db-boun...@zope.org

>
> Am 17.08.2009, 15:05 Uhr, schrieb <dmur...@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.

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.

-David Murphy

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Reply via email to