oracle gateway error from obiee answer
932524Aug 2 2012 — edited Aug 2 2012Hi 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