Re: ZcxOracleDA configuration assistance

[email protected] Mon, 17 Aug 2009 14:26:45 -0400
Newsgroups gmane.comp.web.zope.database
Message-ID <OFC10E9E17.3783B539-ON85257615.0064AD20-85257615.00658474@LocalDomain>
--===============2650239996464754109==
Content-Type: text/html; charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<tt><font size=3D2>[email protected] wrote on 08/17/2009 02:06:59
PM:<br><br>&gt; From:</font></tt><br><tt><font size=3D2>&gt; <br>&gt; &quot=
;Charlie Clark&quot; &lt;[email protected]&gt;</font></tt><br><tt><font si=
ze=3D2>&gt; <br>&gt; To:</font></tt><br><tt><font size=3D2>&gt; <br>&gt; zo=
[email protected]</font></tt><br><tt><font size=3D2>&gt; <br>&gt; Date:</font>=
</tt><br><tt><font size=3D2>&gt; <br>&gt; 08/17/2009 02:04 PM</font></tt><b=
r><tt><font size=3D2>&gt; <br>&gt; Subject:</font></tt><br><tt><font size=
=3D2>&gt; <br>&gt; Re: [Zope-DB] ZcxOracleDA configuration assistance</font=
></tt><br><tt><font size=3D2>&gt; <br>&gt; Sent by:</font></tt><br><tt><fon=
t size=3D2>&gt; <br>&gt; [email protected]</font></tt><br><tt><font =
size=3D2>&gt; <br>&gt; Am 17.08.2009, 15:05 Uhr, schrieb &lt;DMurphy@kalsec=
.com&gt;:<br>&gt; <br>&gt; &gt; ImportError: libclntsh.so.10.1: cannot open=
 shared object file:
No such &nbsp;<br>&gt; &gt; file or directory<br>&gt; &gt; ------<br>&gt; &=
gt;<br>&gt; &gt; $ORACLE=5FHOME and $LD=5FLIBRARY=5FPATH are being exported=
 from ~/.profile
as &nbsp;<br>&gt; &gt; recommended in the cx=5FOracle build document. They =
are:<br>&gt; &gt;<br>&gt; &gt; ------<br>&gt; &gt; kmiweb01:~ # echo $ORACL=
E=5FHOME<br>&gt; &gt; /usr/lib/oracle/10.2.0.4/client64/lib<br>&gt; &gt; km=
iweb01:~ # echo $LD=5FLIBRARY=5FPATH<br>&gt; &gt; :/usr/lib/oracle/10.2.0.4=
/client64/lib<br>&gt; &gt; kmiweb01:~ # ls -la $ORACLE=5FHOME<br>&gt; &gt; =
total 98648<br>&gt; &gt; drwxr-xr-x 4 root root &nbsp; &nbsp; 4096 Aug 13 0=
9:24 .<br>&gt; &gt; drwxr-xr-x 4 root root &nbsp; &nbsp; 4096 Jul 31 11:17 =
..<br>&gt; &gt; lrwxrwxrwx 1 root root &nbsp; &nbsp; &nbsp; 17 Jul 31 14:11=
 libclntsh.so
-&gt; &nbsp;<br>&gt; &gt; libclntsh.so.10.1<br>&gt; &gt; -rw-r--r-- 1 root =
root 21038613 Mar 12 &nbsp;2008 libclntsh.so.10.1<br>&gt; &gt; -rw-r--r-- 1=
 root root &nbsp;3796601 Mar 12 &nbsp;2008 libnnz10.so<br>&gt; &gt; lrwxrwx=
rwx 1 root root &nbsp; &nbsp; &nbsp; 15 Jul 31 14:11 libocci.so
-&gt; &nbsp;<br>&gt; &gt; libocci.so.10.1<br>&gt; &gt; -rw-r--r-- 1 root ro=
ot &nbsp;1664116 Mar 12 &nbsp;2008 libocci.so.10.1<br>&gt; &gt; -rw-r--r-- =
1 root root 72674185 Mar 12 &nbsp;2008 libociei.so<br>&gt; &gt; -rw-r--r-- =
1 root root &nbsp; 138033 Mar 12 &nbsp;2008 libocijdbc10.so<br>&gt; &gt; dr=
wxr-xr-x 3 root root &nbsp; &nbsp; 4096 Aug 13 09:24 network<br>&gt; &gt; -=
rw-r--r-- 1 root root &nbsp;1555682 Mar 12 &nbsp;2008 ojdbc14.jar<br>&gt; &=
gt; drwxrwxr-x 4 root root &nbsp; &nbsp; 4096 Mar 12 &nbsp;2008 sdk<br>&gt;=
 &gt; kmiweb01:~ #<br>&gt; &gt; ------<br>&gt; &gt;<br>&gt; &gt; At this po=
int, we're fairly mystified. The file that ZcxOracleDA's
&nbsp;<br>&gt; &gt; install ultimately complains about is indeed in $ORACLE=
=5FHOME,
where I &nbsp;<br>&gt; &gt; would expect it to be looking. We're still able=
 to manually start
&nbsp;<br>&gt; &gt; Plone's Python and import cx=5FOracle just fine. Does a=
nyone have
any &nbsp;<br>&gt; &gt; suggestions?<br>&gt; <br>&gt; Given that it works w=
hen you run Python manually but not when you
start &nbsp;<br>&gt; the cluster the problem is likely to be that your Zope=
 user doesn't
have &nbsp;<br>&gt; the right permissions to access the library.<br></font>=
</tt><br><tt><font size=3D2>Thanks for the response. Plone's documentation =
says
that for the type of install we did, Zope should run as the user &quot;plon=
e&quot;
(I verified this with ps). Unfortunately, even if I chown everything in
$ORACLE=5FHOME to user plone and restart the cluster again, the error remai=
ns
the same.</font></tt><br><br><tt><font size=3D2>-David Murphy</font></tt><b=
r><BR>

--===============2650239996464754109==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Zope-DB mailing list
[email protected]
http://mail.zope.org/mailman/listinfo/zope-db

--===============2650239996464754109==--