Am Fr, 9.01.2009, 21:40, schrieb Bruce Johnson: > > On Jan 9, 2009, at 1:19 PM, Kong, Alan wrote: > >> Chris, >> >> The LD_LIBRARY_PATH, LD_RUN_PATH, and SHLIB_PATH are normally set to >> $ORACLE_HOME/lib or $ORACLE_HOME/lib32 for 32 bit database depend on >> where your lib files located. But from your first email, it set to >> the >> same value as $ORACLE_HOME. Change the settings and see if it's >> working. > > His settings are normal for Oracle Instant Client, which has > everything dumped into a single directory. > > Chris, is this running in a web server? Apache lets you get > environment variables from the environment of the user starting the > httpd process, usually root. I think I ran into something similar when > I was setting up our new server a while back. > > I had to put a directive into the httpd.conf file: > > PassEnv LD_LIBRARY_PATH > > with the appropriate settings. > > -- > Bruce Johnson > University of Arizona > College of Pharmacy > Information Technology Group > > Institutions do not have opinions, merely customs > > >
This reply should be spot-on. I remember someone had the same issue in this list a while ago and the correct environment just wasnt set inside apache. If the script runs from the command line and doesnt somewhere else its almost always to do with the environment setup. The same should apply to the script run by cron. Either set the environment like Bruce suggested or run your script inside a wrapper shell script thats used to set the needed env vars. Hendrik
