Posted by Mladen Gogala on 05/14/07 13:46

On Wed, 25 Apr 2007 11:44:36 +0200, JuliouZ wrote:

> Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There
> is something wrong with your system - please check that ORACLE_HOME is
> set and points to the right directory in /web/htdocs/test.php on line 6
> Oracle Connect Error
>
> my file test.php :
> <?php
> PutEnv("ORACLE_SID=TEST");
> PutEnv("ORACLE_HOME=/oracle/ora102");
> PutEnv("TNS_ADMIN=/oracle/ora102/network/admin");
>
> if ($c=OCILogon("system", "test", "TEST")) {
> echo "Successfully connected to Oracle.\n"; OCILogoff($c);
> } else {
> $err = OCIError();
> echo "Oracle Connect Error " . $err[text];
> }
> ?>
>
> Apache Version is 2.2.4 compile with : ./configure
> --prefix=/usr/local/apache --enable-so --enable-rewrite
>
> PHP version is 5.2.1 compile with : ./configure
> --with-apxs2=/usr/local/apache/bin/apxs --prefix=/usr/local/apache/php
> --with-config-file-path=/usr/local/apache/php --with-zlib --with-gettext
> --with-gdbm --with-oracle=/oracle/ora102 --with-oci8=/oracle/ora102
>
> Oracle is a Database 10.2.1
>
> Tanks for help

It's a known problem. You should patch-up your oracle to 10.2.0.3.
There is script called "changePerm.sh" on $ORACLE_HOME/install, but
only on 10.2.0.2 and later versions.
$ cd $ORACLE_HOME/install
$ ls
utl rootdeletenode.sh jlib createseed1.sh
unix restrict.lst install.excl changePerm.sh
templocal readme.txt envVars.properties.bak
seed.log portlist.ini envVars.properties
rootlocaladd make.log createseed.sh
$
You must, however, apply at least the first patchset. Patch sets for
Oracle are available at http://metalink.oracle.com. You will need a
valid contract cupport identifier (CSI) to log in. If you don't have one,
send me an email and I'll help you change protection on your $ORACLE_HOME
manually.



--
http://www.mladen-gogala.com

[Back to original message]