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!

oracle gateway error from obiee answer

932524Aug 2 2012 — edited Aug 2 2012
Hi All,

When I run the report from Obiee 11g answer , I get the following error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17003] Oracle gateway error: 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. (HY000)

I am using oracle 11.2.0 client for 64 bit . I could import the tables and view data from rpd.The problem comes when I run the report from answer.
I did copy tnsnames.ora to {Oracle_BI1}\network\admin directory & {oracle_common}\network\admin directory and Set up TNS_ADMIN to C:\OracleBI\Oracle_BI1\network\admin

Am I missing anything ?

Thanks,

Virat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details