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.