[Zope] Zope and Databases

[tgraham@speakeasy.net]

Do You have Oracle Client tools installed on the box that Zope is running on?  I'm pretty sure that the Zope DA will need to know what and where the database you are trying to connect to is located.  This information is usually supplied to Oracle Client tools via a file called tnsnames.ora.  

I'd recommend searching Oracle site for client tools for linux.



On 25 Feb 2002, Richard Hewison wrote:

> Our Zope 2.4.3 install is running on a SuSE
> Linux 7.3 server and we want to connect to an
> Oracle database which is sitting on a
> different server; a Sun Solaris based machine
> running OS 5.8 with Oracle Enterprise Edition
> 8.1.7.0 installed.
>
> We have downloaded the DCOracle2 product (for
> Red Hat Linux
> 7.1, Python 2.1) but we aren't using Red Hat
>   and we seem unable to get the product to
>   install properly. It complains about the
>   ORACLE_HOME. Also, skimming through the
>   documentation is extremely confusing. As far
>   as we can tell, the docs seem to assume that
>   the Oracle Database is installed (or to be
>   installed) on the same server as the one
>   that runs Zope. In our scenario, this isn't
>   the case.
>
> Basically, how can we discover the correct
> ORACLE_HOME info from the Sun box and what
> else do we need to do with DCOracle2 to get it
> connecting to our Oracle database? (We know
> very little about Oracle if you can't tell
> already!).
>
>
>
> Richard H.
>
> _____________________________________________-
> __
> Zope maillist - Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope **
> No cross posts or HTML encoding! ** (Related
> lists - http://lists.zope.org/mailman/listinf-
> o/zope-announce http://lists.zope.org/mailman-
> /listinfo/zope-dev )