Oracle 10 XE, Ubuntu 10.10 - oci_connect(): OCIEnvNlsCreate() failed
815679Nov 17 2010 — edited Oct 17 2011Good day,
I have installed Oracle 10 XE, from Oracle repository througt apt, then i installed oci8 driver as described in "The Underground PHP and Oracle Manual White Paper", section "Upgrading OCI8 as a Shared Library on Linux"
OCI8 was configured with: ./configure –-with-oci8=shared,$ORACLE_HOME because, Oracle 10 XE is on local machine.
So, when i try connect to database $conn = oci_connect('hr', 'welcome', 'localhost/XE'); i get "Warning: oci_connect(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and LD_LIBRARY_PATH are set and point to the right directories"
But ORACLE_HOME and LD_LIBRARY_PATH are set .. they are exported in /bash.bashrc, in /etc/init.d/apache2 and even in .bashrc in root and my profile
That script . /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh gives mi some error output
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
In phpinfo output i have defined ORACLE_HOME and LD_LIBRARY_PATH in APACHE ENVIRONMENT section, but not in ENVIRONMENT section..
Any ides? Please.