[Zope] Re: Zope + Oracle + Cron

[Tres Seaver]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

David VanKirk wrote:
> We have zope installation that uses an Oracle backend to store data
> on.  We also have the system setup to do a backup of the database and
> Zope Installation everyday.  Everything runs smoothly until it comes
> time to start Zope back up.
> 
> For some reason whenever the script tries to start Zope back up, it
> comes up but with a broken ZOracleDA product.  It complains about not
> being able to find the library file called libclntsh.so.9.0.
> 
> If I try to start Zope myself from command line right after the script
> is done running (actually stop it then start it again) it works and
> connects to Oracle fine.
> 
> I've tried using "nice" to up the priority level but it doesn't seem
> to work.  I also thought that maybe I wasn't giving oracle enough time
> to start up so I've tried adding sleep commands to the script, again,
> with no luck.
> 
> If anyone has any experience in this field or has any suggestions,
> please let me know.  This is a quite annoying situation, as this
> server is quite important to the company and downtime is a bad thing.

Most likely 'libclntsh.so' is on an LD_LIBRARY_PATH for your user, which
the cron user does not have.

Why are you stopping Zope, BTW?  The standard backup script for the ZODB
filestorage is 'repozo.py', which does not need to have exclusive access
in order to create a backup.


Tres.
- --
===================================================================
Tres Seaver          +1 202-558-7113          tseaver at palladion.com
Palladion Software   "Excellence by Design"    http://palladion.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEidhW+gerLs4ltQ4RAhTsAKCLIlvVdjPhOJ2axPmMl9T2Ao54aACgwi2z
5baWO7v3IILAmDo/bmp55gQ=
=YDdz
-----END PGP SIGNATURE-----