RSS

Configurations needed for OBIEE 11g RPD on Windows 64 bit machine

24 Aug

After installing OBIEE11g on windows 64 bit installation, the ODBC System DSN is set with a wrong driver file path on Microsoft Windows x64 with the following details.

Driver=..<MW_HOME>\Oracle_BI1\bifoundation\server\bin\NQSODBC.dll

Actually the installer should set the DSN driver to nqsodbc64.dll, rather the installer sets it to nqsodbc.dll, which does not exist on the disk.

So for this go to registry editor and change the driver to nqsodbc64.dll instead of nqsodbc.dll.

  1. Go to start-> Run -> type regedit
  2. Go to HKEY_LOCAL_MACHINE

->SOFTWARES

->ODBC

->ODBC.INI

-> coreapplication_XXXXXX

In left side window you will see all attributes for this application. In that double click on Driver attribute.It will popup an Edit string window. In that for Value data change the dll file version to NQSODBC64.dll from NQSODBC.dll and Click Ok to save this change.

3.  Go to HKEY_LOCAL_MACHINE

->SOFTWARES

->ODBC

->ODBCINST.INI

-> Oracle BI Server11g_XXXXXX

i) In left side window you will see all attributes for this application. In that double click on Driver attribute.It will popup an Edit string window. In that for Value data change the dll file version to NQSODBC64.dll from NQSODBC.dll and Click Ok to save this change.

ii) Again In left side window double click on Setup attribute.It will popup an Edit string window. In that for Value data change the dll file version to nqssetup64.dll from nqssetup.dll and Click Ok to save this change.

The DSN driver setting has no functional impact and hence can be ignored.

Thanks,

Shiva

Advertisements
 
17 Comments

Posted by on August 24, 2010 in OBI EE, OBIEE 11g

 

17 responses to “Configurations needed for OBIEE 11g RPD on Windows 64 bit machine

  1. Dimitris

    September 30, 2010 at 3:02 pm

    Hi,
    really nice tip.But in my case it does not work.
    I have installed oracle bi 11g in windows server 2008 R2 64.
    Everything work ok except from the admin tool.Any help??

    tnks in advance!!!

     
    • Shiva Molabanti

      October 8, 2010 at 3:10 pm

      On 64-bit Operating systems we could not open OBIEE11g client tools.It is a bug in OBIEE11g.
      Oracle will fix this in next release.

      Thanks,
      Shiva

       
  2. Kijang

    October 8, 2010 at 10:11 am

    Hi Shiva,

    I already have the same value for step 3, and so I just change the value in step 2. However, I noticed that everytime I start BI Services, the registry looks like write back to old value (nqsodbc.dll).
    Do you, by chance, know any other solution, i.e. change config file (.ini) rather than registry?

    Thanks for your informative post and thanks for your response.

     
    • Shiva Molabanti

      October 8, 2010 at 3:13 pm

      Even we change in any config files again the ODBC communication is depends on the dll files used by Operating systems. At the same time you should be the part of Administrators group on windows to change the registry entry .

      Thanks,
      Shiva

       
  3. kaupind

    January 26, 2011 at 4:44 pm

    Hello Shiva,
    Understanding you are SME in this field, I am trying to install OBIEE 11g
    on 8GB & i7 processor (64bit) do you think i need to modify before installation as system requirment is 32 bit but in you past notification you have mention oracle will fix in next realase
    Please confirm.

    thanks

     
  4. Musa

    February 2, 2011 at 12:03 pm

    Hi,

    Did you have to do any deviations from the standard Install for OBIEE 11? Like install the JDK seperately, etc?

     
  5. Sohail Nawaz

    July 10, 2011 at 12:05 pm

    Hi Shiva,

    I have installted OBIEE 11g in Windows 2008 R2 64-bit server, its working fine, even Admin Tool is also working fine, I am facing problem with Excel sheet. I want to add Excel sheet as a data source. its working from Admin Client Tool 32 bit. But when i am loding repository in BI Server (Window 2008 R2 64-bit) then its not working please advice me.
    Regards
    Sohail

     
    • Mohammed Sameeruddin

      October 10, 2011 at 12:10 pm

      How to import excel files in OBIEE?

      Solution
      Please follow this link : http://www.oraclenerd.com/2011/01/obiee-import-excel-file-as-source.html

       
    • Ed

      November 14, 2011 at 12:09 pm

      This is because You’ve not set up the Excel File in the 64bit version of the ODBC driver (Located in C:\Windows\SysWOW64\odbcad32). It works on the Admin Client because its 32 Bit looking at the 32 bit driver.
      When you load on to the server, It can’t see the driver because it’s looking at the 64bit ODBC. Simple solution re-build the driver with the EXACT same same names and setting in the 32bit version and it should work on both Admin tool and the Server.
      Regards

      Ed

       
  6. Sohail Nawaz

    July 10, 2011 at 12:07 pm

    I follow the above steps, even its not working. Please give me any solution
    Regards
    Sohail

     
  7. aneel

    September 20, 2011 at 7:04 pm

    Hi support,

    I had installed OBIEE11g in window’s 7 32bits,but im unable to start services and Administrator Tool of RCU.if im try to start BI services it is disabling in nano seconds.Im not able to open RCU.presentation services are working gud.could pls tell me suggestions.

    Thank’s in Advance
    Anil

     
  8. Jethin

    April 5, 2013 at 9:10 pm

    Hi,
    I just installed OBIEE 11.1.1.7.0 in my Windows 8 64 bit and once the installation was complete I could log in and see the Sample Sales. The next time when I restarted the Services the BI Server is not coming up and my Administration Tool cannot be opened.

    In my previous version of OBIEE the Administration Tool was accessable.

    I followed all the steps mentioned above but still no change

    Thanks In Advance.

    Jethin

     
  9. Prathamesh

    November 9, 2014 at 4:00 pm

    I dont have either of the files…nqsodbc64.dll or nqssetup64.dll

     
  10. santhi

    December 15, 2014 at 7:12 am

    Hi shiva,
    I have installed OBIEE 11 g in my windows 8 64 bit, Im able to login to EM,console but unable to connect to Admin Tool, Please suggest any workarounds.

    Thanks in advance.
    santhi

     
  11. Sohaib

    August 11, 2016 at 2:01 pm

    Hello,

    Sir I need OBIEE CLIENT tool (Admin tool + Catalog Manager) 64bit of 11.1.1.7.0 version.

    Please help I cannot find them on Oracle Website

     
    • Shiva Molabanti

      October 12, 2016 at 12:24 am

      Oracle is not supporting the .7 versions. You can get a copy from oracle with an SR in support.

       

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: