If you are connecting an Oracle Database using an Apache2 webserver that runs on an Ubuntu machine, you might randomly have this error.
Warning: ocilogon() http://function.ocilogon: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries.
It can be solved setting properly the environment variable LD_LIBRARY_PATH in the configuration file /etc/apache2/apache2.conf
Add below the ServerRoot path:
ServerRoot "/etc/apache2"
the following line:
SetEnv LD_LIBRARY_PATH="/opt/oracle/instantclient_10_2"
Don’t forget to let us know if the solution is working also for you ;)
Other Posts
« HOW-TO: Create a Report that Executes a Query
Troubleshooting: Responsibility not Visible by User After unendate »
Comments
This entry was posted on Friday, February 20th, 2009 at 6:00 am and is filed under Oracle on Unix Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Feed RSS 
My Youtube
My Linkedin
did it work?
since some days i get randomly the same error message on my debian server ;(
well… it worked… at least for me… :P
well…
i had this problem about 1 years ago.
I changed the server (because of other reasons) and also upgraded apache & php etc. and since then i didn’t have this problem any more.
some days ago it started again … very strange here. i will see in some day if this is fixed now again.
i’ll let you know.
sure! let us know!
Thank you
Still error : :d
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 /home/wildan/jobstuff/OpenThinkLabs/webapps/sandbox/oracle.php on line 2
I am getting this kind of error on my site.
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system – please check that ORACLE_HOME is set and points to the right directory in
Can u suggest the possible solution for the same?
Seems to be working:)Thanks