Koester, Chris wrote:
Scripts ran from cron give this error.
failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH
(Windows) and or NLS settings, permissions, etc. at
/app/XOstats/prod/bin/util/check_user.pl line 43
Can't call method "disconnect" on an undefined value at
/app/XOstats/prod/bin/util/check_user.pl line 69.
Web log give this error.
[Fri Jan 09 12:08:57 2009] [error] [client 172.31.48.85] Premature end of
script headers: Login.pl
[Fri Jan 09 12:21:39 2009] [error] [client 172.31.48.85] install_driver(Oracle)
failed: Can't load
'/xst/xstlocal/bin/lib/perl5/site_perl/5.10.0/i86pc-solaris-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: ld.so.1: perl: fatal: libnnz10.so: open failed: No
such file or directory at
/xst/xstlocal/bin/lib/perl5/5.10.0/i86pc-solaris-thread-multi/DynaLoader.pm
line 203.
For some reason its not recognizing the $ENV{…. } set with in the perl scripts to identify ORACLE_HOME and other variables.
$ENV{"ORACLE_HOME"}="/xst/xstlocal/bin/oracleInstantClient/instantclient_10_2";
$ENV{"TNS_ADMIN"}="/xst/xstlocal/bin/oracleInstantClient/instantclient_10_2";
$ENV{"LD_LIBRARY_PATH"}="/xst/xstlocal/bin/oracleInstantClient/instantclient_10_2:....
If I have the script from the command line with all the env variables set
correctly the script runs. It basically does not recognize the variables in
the scripts.
Thanks in advance.
Chris
-------------------
Chris Koester
I dont' have much luck setting LD_LIBRARY_PATH in a script in an oracle
environment, you may need to set it in the profile for the user that
starts the web service -or- since it appears to be an oracle service you
may need to update the iAS SID ENV file or APPSORA ENV file (which
usually get sourced by oracle startup scripts) to add this additional
location so that it is set for the apache environment *before* the perl
script is called.
