OCIEnvNlsCreate() failed

After another day of unsuccessful experiments I still couldn't make my remote connection work.

But I found out, after I switched from the MDB2 functions to PHP's standard OCI functions, that I've got the same problem with the "PATH Error" as you describe it here but I only didn't see it before because MDB2's error message was not that clear.

One very interesting thing is that I can connect to the remote server with my client's "10 XE Client (installer version)" from the SQL command line without any problems.

Did you have any success today ? :-)

*** Michl

Hi Jean-Philippe,

I finally solved the problem on my machine !

I did some side-by-side comparisons between the phpInfo() output of my well working server's XAMPP environment(v. 1.5.1)
and the output of the remote client's environment (v. 1.6.0a).

The result is that the "php_oci8.dll" bundled with the earlier XAMPP version on my server has a higher version number ("1.28***")
(although it's definetly older as the file timestamp shows) than the (newer) one included with later XAMPP distribution ("1.26**") on my client.

My first attempt to fix it was to replace the client's 1.26 with the server's 1.28 but this didn't work because it disabled
PHP's OCI8 support after a Apache restart.

The next try was the successful one but I had to switch back to PHP 5.1.1 (that's not really a big thing for me).

1. Uninstall the client's current XAMPP environment (1.6.0a) completly using the uninstaller.

2. Install XAMPP (1.5.1).

3. Check that the "Instand Client Basic" is installed in a folder and the path to that folder is included at the beginning of
your global "Path" environment variable.
(e.g.: D:\oracleclient;%SystemRoot%\system32;...)

I also removed all other environment variables I created during my previous tests and experiments like "ORACLE_HOME", ...
because they're not neccesary.

4. Uncomment the "php_oci8.dll" inside the "php.ini".

5. Restart the Apache.

6. Check phpInfo() for OCI8 support enabled.

7. Check that you use the correct DSN or Database syntax in your PHP script.

Standard PHP OCI functions:
oci_connect("user", "password", "//130.50.15.224/xe")

MDB2 DSN:
oci8://user:password@/130.50.15.224/xe

8. Your remote database connection should work now.



*** Michl

Goodmorning,

You shouldn't need ORACLE_HOME with instant client.

Instead of:
<?php
print(date("1 F d, Y"));
$db = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX) (PORT = 1521)))(CONNECT_DATA =(SID = YYY)))";
$db = oci_connect("user","password",$db);
?>

Try:
<?php
print(date("1 F d, Y"));
$c=OCILogon("user", "password", "XXX.XXX.XXX.XXX:1521/YYY");
?>

Hope this helps

As the previous poster pointed out you don't need ORACLE_HOME set when you are using Instant Client. Also LD_LIBRARY_PATH is a UNIX variable.

Unset both of these. Also try unsetting NLS_LANG and let it default for the moment.

Are you sure there is no other Oracle software on the machine or values in the registry?

-- cj

I've met absolutely the same problem.

And it was solved here: http://www.thescripts.com/forum/thread637481.html

The thing is - you simply must change permissions for some oracle files by script: $ORACLE_HOME/install/changePerm.sh

After I made so - no problems.

Sergey

Hi everybody,
Sorry for asking how i can make this changing in permission under windows??
where i could run this script??
thanks for your help,

Hey everybody. I also wunder how to change the permissions under windows. I hope yu kan help me

Message was edited by:
user549051

I've not heard that Windows has the same permission issue?
If you have a similar error, start a new thread.

-- cj

I don't think this problem has anything to do with file permissions, but is actually exactly as the error message suggests : that environment variables are not set as far as PHP/Apache is concerned. I've had this same problem but have finally found a solution.

First, check if the env-variables ORACLE_HOME and NLS_LANG are actually being picked up by PHP. I had set and exported them before starting Apache (using sudo) but using phpinfo() the "PHP Variables" section (near the end) didn't show either of these variables as being set, just as the error message suggested.

The solution was to include both ORACLE_HOME and NLS_LANG variables in the "envvars" file which is located in the same directory as apachectl (the script you use to start the apache daemon).
Add the two entries exactly as you would as if they were in a .profile
eg:
export ORACLE_HOME=/Volumes/u01/app/oracle/product/10.1.0/db_4
export NLS_LANG=.AL32UTF8

Save the file, and restart apache.
Using phpinfo() you should now see both variables listed in the "PHP Variables" section.
PHP should now be able to connect to Oracle

I was beating my head against the wall trying to figure this out. Adding the exports to envvars detailed by user488828 was the ticket.

Thanks. You're the man (or woman)!

Don
Ypsilanti, MI

Where they need to be set is OS and version specific. There's a section on "Setting Oracle Environment Variables for Apache" in http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf which has some general guidelines.

That or, edit /etc/group and simply add www-data (apache user) to oinstall group.