OCIEnvNlsCreate() failed. When i try to connect my oracle database in php

Question

phpinfo

_ENV["ORACLE_HOME"] C:\oracle\instantclient_11_2\
_ENV["OS"]  Windows_NT
_ENV["Path"]    C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\oracle\instantclient_11_2;\;

oci8

OCI8 Support    enabled
Version     1.2.5
Revision    $Revision: 1.269.2.16.2.43 $
Active Persistent Connections   0
Active Connections  0
Temporary Lob support   enabled
Collections support     enabled

php code

<?php
     $conn = OCILogon('mppd1','mppd1', "121.256.476.86:1521/mydatabase");

$query = 'select * from users';

$stid = OCIParse($conn, $query);
//OCIExecute($stid, OCI_DEFAULT);
while ($succ = OCIFetchInto($stid, $row)) {
foreach ($row as $item) {
echo $item." ";
}
echo "<br>\n";
}

OCILogoff($conn);
?>

i am getting this error

Severity: Warning

Message: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries

Edu Labs Colombia · Accepted Answer · 2015-01-08 16:15:27Z

6

I solved it copying all the content of C:\instantclient_11_2 (please check what´s yours) inside system and system32 folders in Windows , then I delete the path of C:\instantclient_11_2 in the PATH enviroment variable.

I am using XAMPP and Windows 8 and it´s the first time I see this issue. I always configured properly oci 8 with xampp and windows in a few minutes. I hope this would help you.

answered Jan 8, 2015 at 16:15

Edu Labs Colombia

611 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Pankaj Wanjari Over a year ago

I solved with above solution on windows 7 with wampserver.

manix Over a year ago

This saved me 4 days of suffering!

Shanka SMS Over a year ago

You save my day........ thank you so much. after copying C:\instantclient_19_22 into system folder solved my error.

Glauber Monteiro · Accepted Answer · 2018-08-02 20:24:05Z

1

You need to copy all content of the instant client to apache/bin

im using xampp and working for me.

copy all files of the instant client enter image description here to apache/bin

answered Aug 2, 2018 at 20:24

Glauber Monteiro

211 bronze badge

1 Comment

ffuentes Over a year ago

Also everyone, check that you have the right version of the library and that both client and odbc match version and architecture.

Muhammad Habib · Accepted Answer · 2019-12-07 05:43:17Z

1

I was facing the same error on uwamp 3 in connecting to oracle 11gR2.

I deleted the oracle instantclient from path variable and copied all files from instantclient to uwamp\bin\apache\bin

and it worked.

My setup:

System: Windows 7
Instantclient: instantclient-basiclite-win32-11.1.0.7.0
Web Server: Uwamp3

answered Dec 7, 2019 at 5:43

Muhammad Habib

4002 silver badges16 bronze badges

Comments

stormdrain · Accepted Answer · 2012-03-16 14:06:14Z

0

https://forums.oracle.com/forums/message.jspa?messageID=1742926#1745145

There are several potential solutions on that page ranging from re-installing xampp to checking permissions to using native php oci_connect(). Have you tried any of these things?

answered Mar 16, 2012 at 14:06

stormdrain

7,8954 gold badges40 silver badges76 bronze badges

Comments

Hyyudu · Accepted Answer · 2013-03-18 14:23:45Z

0

Probably you should download InstantClient and replace contents of /instantclient folder of Oracle client with the .dll-s of InstantClient.

answered Mar 18, 2013 at 14:23

Hyyudu

1

Collectives™ on Stack Overflow

OCIEnvNlsCreate() failed. When i try to connect my oracle database in php

5 Answers 5

3 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related