1 2 Previous Next 17 Replies Latest reply: Aug 2, 2012 1:49 PM by 932524 RSS

    oracle gateway error from obiee answer

    932524
      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
        1 2 Previous Next