Re: sqlnet.ora doesn't seem to be read since oci8 1.3.4

From: Date: Tue, 17 Feb 2009 20:28:26 +0000
Subject: Re: sqlnet.ora doesn't seem to be read since oci8 1.3.4
References: 1 2 3  Groups: php.db 
Request: Send a blank email to php-db+get-45967@lists.php.net to get a copy of this message
Jérôme Loyet wrote:
My init script where the ENV are set: export ORACLE_HOME=/usr/local/oracle/VERSIONS/Linux/CL.9.2.0 PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/network/admin:$ORACLE_HOME/lib:/usr/local/bin
(The admin and lib directories aren't needed in the PATH because they don't contain executables.)
export ORACLE_SID=MEN1PRD export HOSTNAME=hostname export NLS_LANG=FRENCH_FRANCE.WE8ISO8859P15 export LC_ALL=fr_FR export LANG=fr_FR
Does phpinfo() show these all set in the Environment section? (see the Underground Manual again). Is sqlnet.ora readable by the Apache process? What directory is it in? Try moving it to /etc/sqlnet.ora (since this is a default search location).
Php is loaded by apache as a module OCI8 is compile into PHP and is not a shared module As I explain it before, nothing as changed but the OCI8 version. The ENV var are set the same way.
The OCI initialization function used by OCI8 was standardized to OCIEnvNlsCreate() in 1.3.4. But sqlnet.ora should definitely still be usable. Chris -- Email: christopher.jones@oracle.com Tel: +1 650 506 8630 Twitter: http://twitter.com/ghrd Free PHP Book: http://tinyurl.com/UGPOM

« previous php.db (#45967) next »