BOBI 4.1 SP2 Oracle client installation on server

[former_member552170]

Hi,

   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.

Obinna.

[Former Member · Accepted solution]

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. 1. ORACLE_HOME=<64-bit version of the Oracle client path>
2. 2. ORACLE_HOME32=<32-bit version>
3. 3. TNS_ADMIN=<64-bit version>
4. 4. TNS_ADMIN32=<32-bit version>
5. 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.

[Former Member · Accepted solution]

Hello Obinna,

As we all know, SAP BI 4.1 is 64 bit product and therefore requires the Oracle 64 bit "Administrator" client. For reporting we would require Oracle 32 bit Run time Client with "Run Time Lib".

When you install the 32 bit Client with "Run Time Lib"  there is no need to set the environment vairables for 32 bit.

Only keep the Env variables for 64 bit"
- Oracle_Home
- Path

Hope this helps.

Regards,
Mahesh

[former_member552170 · Accepted solution]

Hi Prasad,

   Thank you so much for your inputs. Here we are facing issue with audit configuration. Actually we need to configure ODBC connection for audit database. As SAP is recommending to use 32 bit ODBC driver for audit configuration. Am totally confused. Am not able to find ODBC driver seperately for 32 bit and 64 bit. Your input is highly appreciated.

Please find below the error message for audit report.

Thanking you in anticipation.

Obinna

[Former Member · Accepted solution]

Hi Obinna,

On a 64 bit Operating System it is possible to create both a 32 bit and a 64 bit data source

Make sure that you have installed both the Bits (64 and 32) of Oracle in the BO server.

Audit Needs to be Configured in 64 bit ODBC Drivers.  you need to have 32-bit Oracle client for Crystal reports 2011. where processing server requires 32 Bit Drivers.

Below are the directories to create ODBC.

As you are using Oracle, There is no need to create ODBC, directly you can connect to the Oracle using the TNS entries in the system.

• To create 32 bit ODBC data sources, use the ODBCAD32.exe in C:\Windows\SysWOW64\odbcad32.exe
• To create 64 bit ODBC data sources, use the ODBCAD32.exe in C:\Windows\System32\odbcad32.exe

Hope this answers your question

[Former Member · Accepted solution]

This issue is definitely drivers issue.

Can you share the details of the universe connection?

Are you using ODBC or TNS entry?

32 bit drivers needs to be installed in the client machine to access the reports in Web Intelligence Rich client tool.

64 bit drivers needs to be installed in the server machine to access the reports in BI Launchpad.

[former_member552170 · Accepted solution]

Hi Prasad,

   Am using ODBC connection. We already installed 32 bit oracle client on client machine and we tried using webi rich client tool and the audit report is working with no errors. But if i try to run using launchpad then its throwing the above mentioned error. Please suggest.

Thanking you in anticipation.

Obinna.

[Former Member · Accepted solution]

Install 64 Bit drivers in BO server.

create 64 bit ODBC data sources as used in the Universe., use the ODBCAD32.exe in C:\Windows\System32\odbcad32.exe

this will solve your issue in launchpad.

[former_member552170 · Accepted solution]

Hi prasad ,

  After i installed 64 bit ODBC driver in windows server resolved the issue. Thanks for your valuable support.

Obinna

[Former Member · Accepted solution]

Hi Prasad,

In the case of linux SAP BO server how we will create odbc connection in linux ?

or else tns entry is sufficient to connect to the Bo repository .

Please suggest me .

Regards

Narasimhulu M

[DellSC · Accepted solution]

If the reports/universes are using a Native Oracle connection, then the TNS entry should work.  You only need to create ODBC connections if the reports and/or universes use that type of connection instead.  From my experience, the Native Oracle connection is more stable and reliable than trying to use ODBC.

-Dell