By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,747 Members | 2,039 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,747 IT Pros & Developers. It's quick & easy.

Error with ocilogon() : OCIEnvNlsCreate() failed

P: n/a
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
Apr 25 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Try changing the permissions on the oracle home directory

Apr 28 '07 #2

P: n/a
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
May 14 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.