ahmed nabel a écrit :
Hi

A problem with connecting to remote oracle db via php. The error message is:

Warning: oci_connect() [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 
/Library/WebServer/Documents/test.php on line 14
Oracle connection failed.

The phpinfo shows:

Apache Environment

...
...
PATH    /usr/bin:/bin:/usr/sbin:/sbin
...

oci8

OCI8 Support    enabled
Version 1.2.4
Revision        $Revision: 1.269.2.16.2.38 $
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.default_prefetch   10      10
oci8.max_persistent     -1      -1
oci8.old_oci_close_semantics    0       0
oci8.persistent_timeout -1      -1
oci8.ping_interval      60      60
oci8.privileged_connect Off     Off
oci8.statement_cache_size       20      20

...
Environment

Variable        Value
PATH    /usr/bin:/bin:/usr/sbin:/sbin

...
...

Any ideas?

PS: php 5.2.5 Apache 2.2.8 Mac OS X 10.5.2
_________________________________________________________________

http://clk.atdmt.com/UKM/go/msnnkmgl0010000009ukm/direct/01/


Hello

I tried Oracle Database 10g Release 2 (10.2.0.1) on a Debian Etch recently. I had to add this file :

[EMAIL PROTECTED]:/etc/ld.so.conf.d# cat oracle.conf
/usr/lib/oracle/10.2.0.3/client/lib

Hope that helps

Patrick


Reply via email to