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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: mauroi at digbang dot com
New email:
PHP Version: OS:

 

 [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: Fri Dec 27 16:01:29 2024 UTC