BOBI 4.1 SP2 Oracle client installation on server
In my landscape, we have installed BOBI 4.1 SP2 on windows 2008 and the oracle version is 11g. Everything is working fine except audit configuration. Actually SAP recommended to install both 32 bit oracle and 64 bit oracle client in server. But if we install both version on server then how it will works and how can we set env. variables and TNS entry. Totally confused and am not good at oracle. Any one input is highly appreciated.
Thankig you in anticipation.
If you do not have separated installations (CMS server and Application server) and would like to have both 64-bit and 32-bit installed on your server, you may face issue with your CMS.
To have both 64-bit and 32-bit installed and avoid CMS issue, please set your environment
Variables as indicated below:
# In BI 4.0, in order to connect with CMS database it is required to have 64-bit client installed on the server.
# If you have also installed 32-bit Oracle client for Crystal reports 2011 along with the 64-bit Oracle client, Check if the following Environment variables are set properly:
Environment Variable to be set:
- 1. ORACLE_HOME=<64-bit version of the Oracle client path>
- 2. ORACLE_HOME32=<32-bit version>
- 3. TNS_ADMIN=<64-bit version>
- 4. TNS_ADMIN32=<32-bit version>
- 5. BOE_USE_32BIT_ENV_FOR=ORACLE_HOME,TNS_ADMIN
Mention Oracle 64 path first in the PATH environment variable and then the Oracle 32 bit path.
Reboot server once completed above and make sure cms.exe is running after restart.