Chris-
Your TNS_ADMIN usually points to $ORACLE_HOME/network/admin
where you find these files
TNSNAMES.ORA
listener.ora
also..I generally set ORACLE_SID environment var to point to the SID I am using
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This transmission is of a confidential nature and Sender does not
endorse distribution to any party other than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
> Subject: DBD problem with knowing where Oracle is at.
> Date: Fri, 9 Jan 2009 13:44:41 -0600
> From: ckoes...@xo.com
> To: dbi-users@perl.org
>
> 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
_________________________________________________________________
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_012009
