Re: failed: ERROR OCIEnvNlsCreate. Check (everything)

Perl Diety wrote:
> We're trying to run a Perl program to connect to an Oracle 10 instance, on a
> RH box. From the xterm it runs fine- connects, R/W, everything is ducky. no
> issues whatsoever.
> 
> Then we tried it from a browser (apache server) and it's been a nightmare
> for days. After hours of research and trials, we finally managed to get past
> the "Cannot load Oracle.so"errors by modifying the ld conf file in /etc.,
> rebuilding the DBI, etc.
> 
> Now we've graduated to failed: "ERROR OCIEnvNlsCreate. Check (everything)"
> which basically says (*something* is wrong).
> 
> We went on a second research expiditon, and checked permissions, versions,
> modified ENV vars for NLS, yet nothing seems to help; we just keep getting
> this same message. The fiull message suggests a problem with ORACLE_HOME,
> ORA_NLS10, NLS_LANG,  and "etc" which we interpret to mean (anything at
> all).
> 
> We populated NLS_LANG to match *locale*. We also tried several other options
> like america.american, etc.
> 
> The error occurs at the Connect() step. I threw it into an eval{} block and
> checked perlvars for messages, but they were the same as the fataltobrowser
> message below.
> 
> Finally, we use the same DBI to connect just fine from a browser to mysql.
> So we know the DBI is at least functioning for some DBDs.
> 
> Any advice on howe to isolate this to a file or conf value, etc would be
> most welcome!
> 
> Here is the info we can extract to try to get an idea of what it doesnt
> like:
> 
> available_drivers:
> DBM
> ExampleP
> Oracle
> Proxy
> Sponge
> mysql
> 
> ENV VARS
> 
> DOCUMENT_ROOT = /var2/www/html
> GATEWAY_INTERFACE = CGI/1.1
> HTTP_ACCEPT = */*
> HTTP_ACCEPT_ENCODING = gzip, deflate
> HTTP_ACCEPT_LANGUAGE = en-us
> HTTP_HOST = ournode.com
> HTTP_UA_CPU = x86
> HTTP_USER_AGENT = Mozilla/4.0
> LD_LIBRARY_PATH = /export/apps/oracle/product/10201/lib
> LD_RUN_PATH = /export/apps/oracle/product/10201/lib
> NLS_LANG = en_GB.UTF-8
> ORACLE_BASE = /export/apps/oracle
> ORACLE_HOME = /export/apps/oracle/product/10201
> ORA_NLS10 = /export/apps/oracle/product/10201/nls/data/
> REQUEST_METHOD = GET
> REQUEST_URI = /cgi-bin/oratest.cgi
> SERVER_PORT = 80
> SERVER_PROTOCOL = HTTP/1.1
> SERVER_SIGNATURE =
> 
> Apache/2.0.52 (Red Hat) Server at ournode.com Port 80
> 
> SERVER_SOFTWARE = Apache/2.0.52 (Red Hat)
> DBI connect(...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux)
> env var or PATH (Windows) and or NLS settings, permissions, etc. at
> /cgi-bin/oratest.cgi line 32
> 

Did you really set AND export ORACLE_HOME or LD_LIBRARY_PATH such that
Apache children see them? I can't remember what the syntax in the
httpd.conf file is now (SetEnv perhaps) as I no longer use Apache but
you used to have to explicitly tell Apache which env vars to allow.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com