This still does not help. ORACLE_SID and LD_RUN_PATHwas already there. I added SHLIB_PATH and still no luck.
------------------- Chris Koester -----Original Message----- From: Kong, Alan [mailto:ko...@coned.com] Sent: Friday, January 09, 2009 1:56 PM To: Koester, Chris; dbi-users@perl.org Subject: RE: DBD problem with knowing where Oracle is at. Chris, You have to set ORACLE_SID, SHLIB_PATH, and LD_RUN_PATH also in your perl script. Alan -----Original Message----- From: Koester, Chris [mailto:ckoes...@xo.com] Sent: Friday, January 09, 2009 2:45 PM To: dbi-users@perl.org Subject: DBD problem with knowing where Oracle is at. 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_1 0_2"; $ENV{"LD_LIBRARY_PATH"}="/xst/xstlocal/bin/oracleInstantClient/instantcl ient_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
