Re: OCIEnvNlsCreate() failed

["php@xxxxxxxxxxx" <php@xxxxxxxxxxx>]

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 :

root@lindows:/etc/ld.so.conf.d# cat oracle.conf
/usr/lib/oracle/10.2.0.3/client/lib

Hope that helps

Patrick