[Zope] Connection Problem with Oracle

[Ayhan Ergul]

> I created a connection to an Oracle database. Frequently,
> the connection breaks and I got a database error in the page that
> displays the query result. When I logon as a manager I find that the
> connection is closed (by itself, nothing changed in Oracle or Zope),
> when I try to open it I get an error "Invalid connection string". Even
> if I create another connection it can't work.. After a while it
> works. Even after restarting the Zope server the problem persists.

I'm not sure why the same connection string would work only some of the
time. Maybe some other error from sqlnet is misreported. In any case, look
for sqlnet.log at the directory where zope was started. You can get more
info on the errors you're experiencing. Furthermore try running zope with
nohup and monitor the nohup.out file that gets generated. You can see how
frequently your zope goes down (if running as deamon under linux).

Frequent problems with Oracle setup stem from read permissions on files
used by sqlnet (e.g. message files). Make sure such files are readable by
whatever user your zope is running as. 

Ayhan Ergul <ergul@acm.org>