#50511 [NEW]: Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed
From: kma at sam dot sdu dot dk
Operating system: RHEL 4
PHP version: 5.3.1
PHP Bug Type: OCI8 related
Bug description: Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed
Description:
------------
Hi!
I'm having seriuos issues with this error, i tried almost anything now but
i still have this error:
Warning: oci_connect() http://function.oci-connect:
OCIEnvNlsCreate()
failed. There is something wrong with your system - please check that
LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries
in /web/SITE/www/lic/db/db.php on line 19
Connection to Oracle Server lost!
This could be due to a known problem with the Apache webserver. Please
restart Apache and you should be ok.
This error occured after upgrading from PHP 5.0.4 to 5.3.1 (also tried
5.2.11 with same error)
I have configured my PHP with:
./configure --with-apxs2=/opt/httpd/bin/apxs --with-mysql
--prefix=/opt/php --enable-mbstring=all
--with-oci8=instantclient,/usr/lib/oracle/10.2.0.3/client --with-zlib
My LD_LIBRARY_PATH is set via export LD_LIBRARY_PATH to:
LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib
I also tried different thing like configure it with shared instead of
instantclient. etc.
Also i tried to download InstantClient 11.2 and install it throug RPMs, i
can see that PHP configures with the client and my PHPINFO looks like this
(the wierd is that it also says version 10.2 when i use 11.2 client )
OCI8 Support enabled
Version 1.3.5
Revision $Revision: 289423 $
Active Persistent Connections 0
Active Connections 0
Oracle Instant Client Version 10.2
Temporary Lob support enabled
Collections support enabled
Directive Local Value Master Value
oci8.connection_class no value no value
oci8.default_prefetch 100 100
oci8.events Off Off
oci8.max_persistent -1 -1
oci8.old_oci_close_semantics Off Off
oci8.persistent_timeout -1 -1
oci8.ping_interval 60 60
oci8.privileged_connect Off Off
oci8.statement_cache_size 20 20
I've bin struggling with this for 2 days now, and i'm so tired so i can't
remember everything i tried, but ask me..
Thanks soo much in advance!!
Reproduce code:
---------------
./configure --with-apxs2=/opt/httpd/bin/apxs --with-mysql
--prefix=/opt/php --enable-mbstring=all
--with-oci8=instantclient,/usr/lib/oracle/10.2.0.3/client --with-zlib
Expected result:
----------------
Connection success!
Actual result:
--------------
Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed
--
Edit bug report at http://bugs.php.net/?id=50511&edit=1
--
Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=50511&r=trysnapshot52
Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=50511&r=trysnapshot53
Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=50511&r=trysnapshot60
Fixed in SVN: http://bugs.php.net/fix.php?id=50511&r=fixed
Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=50511&r=needdocs
Fixed in release: http://bugs.php.net/fix.php?id=50511&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=50511&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=50511&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=50511&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=50511&r=support
Expected behavior: http://bugs.php.net/fix.php?id=50511&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=50511&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=50511&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=50511&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=50511&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=50511&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=50511&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=50511&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=50511&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=50511&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=50511&r=mysqlcfg
Thread (3 messages)
- kma at sam dot sdu dot dk