on 03-26-2014 3:45 AM
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.
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:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
Hope this answers your question
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.
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.
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
User | Count |
---|---|
68 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.