OracleBIBlog Search

Thursday, June 4, 2009

Installing OBIEE on a 64 bit Windows OS

After a recent installation of OBIEE, I ran into some problems. It wasn't until I was knee deep into the install that I realized my work was cut out for me. A quick easy task suddenly turned in to an internet hunt for information. The following is recap of my challenge and solutions...

When installing OBIEE on a 64 bit Windows machine, the following issues may arise:
After what seems to be a successful install, OBIEE (http://localhost/analytics) does not start.

1. Make sure you installed the Java JDK for Windows(32bit)
2. Windows has to be told to accept 32 bit applications: running the following commands (from command prompt) should solve this :

a) Open a command prompt and navigate to the \Inetpub\AdminScripts directory.
b) Run the following: cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 1

Then I had to run the ASP.NET registration tool.
a) In c:\windows\Microsoft.NET\Framework\v2.0.50727 folder, open a cmd window
b) Run aspnet_regiis -i
c) In c:\windows\Microsoft.NET\Framework64\v2.0.50727 folder, open a cmd window
d) Run aspnet_regiis -i.

3. Within IIS manager, make sure the AnalyticsWeb folder has not been “stopped”

When trying to connect using an ODBC connection, connection does not appear in the admin tool when importing tables.

1. The Windows 64 bit system actually has two different ODBC utilities. The default utility just happens to be the wrong one for OBIEE.
2. Open “C:/WINDOWS/SysWOW64/odbcad32.exe” and add your connections from here.

I hope this helps... Good Luck


Yusuf said...

when i run file odbcad32.exe i couldnt find installed Oracle11g driver on the list? could you help me how to fix this problem !?

Nick Johnson said...

If you're trying to connect to an Oracle DB, you will probably use a TNS names entry. (tnsnames.ora)

When importing tables into the Admin tool, set the connection type as OCI. You'll need to update the TNSnames.ora file with an entry for your database.

There are also ODBC drives available for an Oracle connection, but this would be a separate download from the OBIEE install.

To do this, try installing the 11g database. The ODBC drivers will be found under the "Custom" installation choices.

Yusuf said...

What I did is :
1- I download Oracle Client 11g 32 Bit, so that I can see OracleClient Driver on Odbc32.

2- after adding connection using odb32, I Import Tables using Administrator BI by selecting connection Type : OCI 10g/11g.

It's working with me 100% OBIEE in 64bit Windows OS.

sirish said...

I am trying to install OBIEE on windows 7 and i realise that IIS 7 is missing admin scripts. then how do I make to install 32 bit JDK