php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #36175 Error connecting to Oracle
Submitted: 2006-01-26 22:41 UTC Modified: 2006-01-30 10:18 UTC
From: mauroi at digbang dot com Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 5.1.2 OS: CentOS release 4.2
Private report: No CVE-ID: None
View Developer Edit
 [2006-01-26 22:41 UTC] mauroi at digbang dot com 
Description:
------------
I get this error when I try to connect to a local oracle instance with oci8:

"OCIEnvNlsCreate()
failed.
There is something wrong with your system - please check that
ORACLE_HOME
is set and points to the right directory"

Under exactly the same configuration, but using PHP 5.1.1 it works as expected.
Of course, ORACLE_HOME is correctly defined, and all the environment variables (it works with 5.1.1). The permissions of the tnsnames.ora file are correct (Oracle's 10gR2 bad decision in my opinion).

I can send further information, just tell me what.

Thanks in advance.

Reproduce code:
---------------
Any attempt to connect.

Expected result:
----------------
An oci8 resource

Actual result:
--------------
"OCIEnvNlsCreate()
failed.
There is something wrong with your system - please check that
ORACLE_HOME
is set and points to the right directory"

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-01-27 08:36 UTC] sniper@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php5.1-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.1-win32-latest.zip
 [2006-01-27 13:29 UTC] mauroi at digbang dot com 
Is there a change in the code that connects to Oracle?? Other way, I don't think it would work. If the bug has been corrected, then I will try the next release. Until then, I'll have to keep 5.1.1. Sorry, but this is a production server. I don't think it would be correct to install a development version.

Thank you very much.
 [2006-01-27 15:34 UTC] sniper@php.net 
Maybe there is. Or maybe there isn't. Just test the snapshot.
 [2006-01-30 10:18 UTC] tony2001@php.net 
Failing OCIEnvNlsCreate() clearly means that either ORACLE_HOME or some other env variable is invalid or is not set *BEFORE* httpd process is started.
And we can't get any additional info in this case, no.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Dec 26 23:01:28 2024 UTC