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
