Skip to Main Content

Analytics Software


For appeals, questions and feedback, please email

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

2753631Jul 17 2014 — edited Jul 23 2014


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.


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