[Zope] ZOracleDA woes

Jens Vagelpohl tommymi@concentric.net
Fri, 3 Sep 1999 07:40:01 -0400


hi anthony (and everyone else),

i have almost all oracle environment variables correct and visible to root
as it starts zope, such as ORACLE_HOME, ORACLE_SID, the oracle bin directory
is in the path, and the oracle lib directory is part of LD_LIBRARY_PATH.
maybe there's more needed..?

sqlplus, using the same logged-in account and the very same connection
string works just fine.

jens


> -----Original Message-----
> From: anthony@nextTelecom.com [mailto:anthony@nextTelecom.com]On Behalf
> Of Anthony Baxter
> Sent: Friday, September 03, 1999 00:09
> To: Jens Vagelpohl
> Cc: Zope@Zope. Org
> Subject: Re: [Zope] ZOracleDA woes
>
>
> Have you made sure all the environment variables needed by Oracle are
> set before you run Zope?
>
> Anthony
> >>> "Jens Vagelpohl" wrote
> > hi everyone,
> >
> > after getting a little help in compiling the darned thing and
> testing the
> > shared libraries with the DCOracle python test script
> everything seemed to
> > be OK. Oracle database connections show up as an option to add in the
> > management screen and according to the control panel products page it's
> > available and working as well.
> >
> > when adding a connection (using the legendary scott/tiger
> account which is
> > proven to work using the sqlplus tool) zope dies and restarts.
> if i append
> > the ORACLE_SID to the connection string after an @ nothing happens (the
> > browser keeps waiting for any reply).
> >
> > as a last attempt i added ORACLE_SID to the global /etc/profile
> thinking the
> > connection would not know which instance to connect to, but using the
> > username/password connection string zope still restarts.
> >
> > has anyone seen this behavior or maybe have an idea why it's happening?
> >
> > i'm using zope 2.0.0 final.
> >
> > jens