ZcxOracleDA configuration assistance
[email protected] Mon, 17 Aug 2009 09:05:54 -0400
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <OF1A1BBFCA.8707C148-ON85257615.0044A347-85257615.0048245E@LocalDomain> |
--===============9059734441311516017== Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable <font size=3D2 face=3D"sans-serif">Greetings. I'm trying to set up cx=5FOra= cle and ZcxOracleDA on a Plone/Zope server to allow access from our Plone site to our Oracle database. I'm working with one of our developers who was able to successfully get this working on the test environment on his Windows workstation, but getting it set up on our Linux (SLES10, 64-bit) server is proving a little more interesting. Here's what we've done so far:</font>= <br><br><font size=3D2 face=3D"sans-serif">1. Installed Oracle Instant Clie= nt 10.2.0.4 (which matches our server) Basic and SDK packages as noted in cx=5FOracle documentation. Copied over a tnsnames.ora file from another server.</font><= br><br><font size=3D2 face=3D"sans-serif">2. Installed cx=5FOracle 5.0.2 (b= uilt from source using Plone's Python). We successfully ran a simple Python script at this point to verify connectivity with the Oracle database.</font= ><br><br><font size=3D2 face=3D"sans-serif">3. Untarred ZcxOracleDA 0.6 int= o 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.)</font><br><br><font size=3D2 face=3D"sans-serif">At thi= s point, we check the Zope client log:</font><br><br><font size=3D2 face=3D"sans-serif">------</font><br><fon= t size=3D2 face=3D"sans-serif">2009-08-13T14:17:30 ERROR Application Couldn't install ZcxOracleDA</font><br><font size=3D2 face=3D"sans-serif">T= raceback (most recent call last):</font><br><font size=3D2 face=3D"sans-ser= if"> File "/opt/Plone-3.1/zeocluster/parts/zope2/lib/python/OFS/= Application.py", line 758, in install=5Fproduct</font><br><font size=3D2 face=3D"sans-serif"= > global=5Fdict, global=5Fdict, silly)</font><br><font size=3D2 face=3D"sans-serif"> File "/opt/= Plone-3.1/zeocluster/products/ZcxOracleDA/=5F=5Finit=5F=5F.py", line 20, in ?</font><br><font size=3D2 face=3D"sans-serif"> im= port DA</font><br><font size=3D2 face=3D"sans-serif"> File "/opt= /Plone-3.1/zeocluster/products/ZcxOracleDA/DA.py", line 15, in ?</font><br><font size=3D2 face=3D"sans-serif"> fr= om db import DB</font><br><font size=3D2 face=3D"sans-serif"> File &q= uot;/opt/Plone-3.1/zeocluster/products/ZcxOracleDA/db.py", line 14, in ?</font><br><font size=3D2 face=3D"sans-serif"> im= port cx=5FOracle, datetime</font><br><font size=3D2 face=3D"sans-serif">&nb= sp; File "build/bdist.linux-x86=5F64/egg/cx=5FOracle.py", line 7, in ?</font><br><font size=3D2 face=3D"sans-serif"> File "= ;build/bdist.linux-x86=5F64/egg/cx=5FOracle.py", line 6, in =5F=5Fbootstrap=5F=5F</font><br><font size=3D2 face=3D"sans-seri= f">ImportError: libclntsh.so.10.1: cannot open shared object file: No such file or directory</font><br><font size=3D2= face=3D"sans-serif">------</font><br><br><font size=3D2 face=3D"sans-serif= ">$ORACLE=5FHOME and $LD=5FLIBRARY=5FPATH are being exported from ~/.profile as recommended in the cx=5FOracle build docu= ment. They are:</font><br><br><font size=3D2 face=3D"sans-serif">------</font><br= ><font size=3D2 face=3D"sans-serif">kmiweb01:~ # echo $ORACLE=5FHOME</font>= <br><font size=3D2 face=3D"sans-serif">/usr/lib/oracle/10.2.0.4/client64/li= b</font><br><font size=3D2 face=3D"sans-serif">kmiweb01:~ # echo $LD=5FLIBR= ARY=5FPATH</font><br><font size=3D2 face=3D"sans-serif">:/usr/lib/oracle/10= .2.0.4/client64/lib</font><br><font size=3D2 face=3D"sans-serif">kmiweb01:~= # ls -la $ORACLE=5FHOME</font><br><font size=3D2 face=3D"sans-serif">total= 98648</font><br><font size=3D2 face=3D"sans-serif">drwxr-xr-x 4 root root = 4096 Aug 13 09:24 .</font><br><font size=3D2 face=3D"sans-serif">drwxr-xr-x= 4 root root 4096 Jul 31 11:17 ..</font><br><font size=3D2 face=3D"sans-serif">lrwxrwxrw= x 1 root root 17 Jul 31 14:11 libclntsh.so -> libclntsh.so.10.1</font><br><font= size=3D2 face=3D"sans-serif">-rw-r--r-- 1 root root 21038613 Mar 12 2008 libclntsh.so.10.1</font><br><font size=3D2 face=3D"sans-serif= ">-rw-r--r-- 1 root root 3796601 Mar 12 2008 libnnz10.so</font><br><font size=3D2 face=3D"sans-serif">= lrwxrwxrwx 1 root root 15 Jul 31 14:11 libocci.so -> libocci.so.10.1</font><br><font siz= e=3D2 face=3D"sans-serif">-rw-r--r-- 1 root root 1664116 Mar 12 2008 libocci.so.10.1</font><br><font size=3D2 face=3D"sans-ser= if">-rw-r--r-- 1 root root 72674185 Mar 12 2008 libociei.so</font><br><font size=3D2 face=3D"sans-serif">-rw-= r--r-- 1 root root 138033 Mar 12 2008 libocijdbc10.so</font><br><font size=3D2 face=3D"sans-ser= if">drwxr-xr-x 3 root root 4096 Aug 13 09:24 network</font><br><font size=3D2 face=3D"sans-serif">-rw-= r--r-- 1 root root 1555682 Mar 12 2008 ojdbc14.jar</font><br><font size=3D2 face=3D"sans-serif">= drwxrwxr-x 4 root root 4096 Mar 12 2008 sdk</font><br><font size=3D2 face=3D"sans-serif">kmi= web01:~ #</font><br><font size=3D2 face=3D"sans-serif">------</font><br><br= ><font size=3D2 face=3D"sans-serif">At this point, we're fairly mystified. The file that ZcxOracleDA's install ultimately complains about is indeed in $ORACLE=5FHOME, where I would expect it to be looking. We're still able to manually start Plone's Python and import cx=5FOracle just fine. Does any= one have any suggestions?</font><br><br><font size=3D2 face=3D"sans-serif">Than= k you,<br>David Murphy<br></font><BR> --===============9059734441311516017== 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 --===============9059734441311516017==--