Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 10 XE, Ubuntu 10.10 - oci_connect(): OCIEnvNlsCreate() failed

815679Nov 17 2010 — edited Oct 17 2011
Good 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2011
Added on Nov 17 2010
4 comments
648 views