7 Replies Latest reply: Jul 21, 2014 5:29 AM by DelliBI RSS

    Oracle ORA-12557: TNS:protocol adapter not loadable-OBIEE 10g

    user1668671

      Hi,

       

      We are using OBIEE 10g. We have both 32 bit and 64 bit oracle clients in the macine.
      When we set ORACLE_HOME to 32 bit client we are getting the error "Oracle ORA-12557: TNS:protocol adapter not loadable" when we are trying to import tables from database.


      When we set ORACLE_HOME to 64 bit client we are getting the error "[nQSError: 17003] Oracle gateway error: OCIEnvNlsCreate or OCIEnvInit failed to initialize environment". We are able to import the tables from databse. But while updating row count/ view data or in analytics reports we are getting that error.

       

      First let me know which is the correct oracle client either 32 bit or 64 bit.

       

      Any solution.

       

      Thanks.