Skip to Main Content

Analytics Software

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!

OBIEE 12c -OCIEnvNlsCreate or OCIEnvInit failed to initialize environment.

sabyakgpDec 25 2018 — edited Dec 29 2018

Hi Friends

I am facing a problem while running an Analysis in <host_name>:9502/analytics. I am able to see my subject area and pull the columns but when I click on the Results I get an ODBC error. The error says:

[nQSError: 17002] OCIEnvNlsCreate or OCIEnvInit failed to initialize environment. Please check your Oracle Client installation and make sure the correct version of OCI libraries are in the library path

I have installed OBIEE 12c Release 2.1.4.0 in Oracle Linux 7 and it is running in Oracle Virtual Box. The same guest has also Oracle Database 12c Release 2 running from which BI would fetch the data. I have installed OBIEE 12c client tool in my Windows 10 and I am able to create the repository and I uploaded the repository to the BI server using uploadrpd. I have also installed Oracle client 12c in my Windows 10. My questions do I need to install Oracle client in the Linux system as well? I thought Oracle OBIEE comes with Oracle client. Or do I need to set some library path (LD_LIBRARY_PATH) to OCI library? I am not sure how to do that. It would be of great help if anyone could help me.

Thanks

Comments