ID: 50511 Updated by: s...@php.net Reported By: kma at sam dot sdu dot dk -Status: Open +Status: Bogus Bug Type: OCI8 related Operating System: RHEL 4 PHP Version: 5.3.1 -Assigned To: +Assigned To: sixd New Comment:
------------- Please ask pursue a solution using a Support forum such as http://forums.oracle.com/forums/forum.jspa?forumID=178 http://www.php.net/mailing-lists.php Also see: http://wiki.oracle.com/page/PHP+Oracle+FAQ http://us.php.net/manual/en/oci8.installation.php Previous Comments: ------------------------------------------------------------------------ [2009-12-18 06:59:52] kma at sam dot sdu dot dk 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 this bug report at http://bugs.php.net/?id=50511&edit=1
