OBIEE 11g - you need Admin Tool only ? Then go for it….

Andreas Nobbmann

writing about Oracle Business Intelligence (not OBIEE only), Oracle Essbase, IBM DB2, IBM Data Warehouse Edition and hopefully more

OBIEE 11g - you need Admin Tool only ? Then go for it….

Rate This
  • Comments 17

After quite a while of being a solution architect in a DWH project with obviously not much time to write blog posts I am back again and hopefully you like what I am writing.

Just two questions: are you also “upset” about having to install all the OBIEE 11g software again on your local machine just to get the admin tool running ? Or are you running OBIEE 11g on Linux and there simply is no Admin Tool available for this great operating system ?

If your answer to one of these two questions is YES you just could continue to read, there is a solution for it. As so often there is some work to do, but it’ll be worth it, don’t you think ?

What you would need is a Windows PC or a virtual machine as the Admin Tool only runs in Windows yet and unfortunately the binaries from a 32 Bit Admin Tool properly running somewhere. Good news is that with this instructions here it should be also possible to let it run in WINE. This I haven’t tried yet, but I assume Borkur will do it, won’t you ?

Ok, let’s get started..

What I did first is that I downloaded some software to detect the dependencies of the AdminTool.exe. I used Dependency Walker, which you can find easily in the web. It’s quite powerful BTW.

For those of you – like me – still having some problems to find the new locations of the OBIEE 11g files: this little powerful AdminTool.exe is stored in

Your_Oracle_MiddlewareHome\Oracle_BI1\bifoundation\server\bin

Next to do is to start Dependency Walker and open the admintool.exe to see which DLL’s are needed by this executable file. The picture coming up after a while would look similar like this:

image

And now to the part where manual work comes into play: what I did next was to check whether I have all DLL’s the admintool needs. Very good, because I found out most of them are located in the same directory as the admin tool itself. But there are also some from the Windows directory and additionally some from the Microsoft Foundation Classes.
Another tip is to just test copying everything from the directories mentioned in the next step to your local windows machine and just give it a try. Perhaps you’re lucky, my fingers are crossed for you !

As a consequence please make sure that you have MFC installed on your machine by checking your system.

image

When you are sure that all DLL’s are available on your machine you next have to create a directory on your C: drive, because the AdminTool needs the default directory to start up. So, create a directory c:\Oracle\home\bifoundation\server\bin\ and copy all files from the environment of your running AdminTool to this directory. Additionally copy the directories document and locale.(I just copied the l_en under locale folder, more is not needed, it’s just there to trick AdminTool).

Last but not least there is one thing left to do. Because you have not installed the software on your Windows machine Microsoft Windows doesn’t know the DLL’s you need. Hence you have to register them by using the tool regsvr32.

No no, you don’t have to do that manually, that would be hell of a stupid work, you can use the existing commands dir, pipe the result and use a good editor in column mode to reach what you need.

In a Command window being in the AdminTool directory do:

dir *.dll /B > OBIEE11g_DLLs.cmd

image

Option /B only displays the bare name of the files and nothing else. Normal Dir would give you size of files and directory name etc.pp. We don’t need that.

Next open for example Notepad++ or your favored editor, go to first row, first column and start Column mode (BTW: in Notepad++ you start it with Alt+C) . Add the text regsvr32 /s and save the file. Don’t forget the space after the /s or you’ll have to do it again !

image

image

The option /s forces the regsvr32 tool to register the DLL’s in silent mode. Of course you can also leave this away, but be aware that you’ll have to close a lot of windows then. But I’m sure your GDI (Graphical Design Interface) of Windows will be able to handle it.

Switch back to your DOS box and start the command you just saved. 

To finally lead AdminTool into dark create a last directory by using the following command

mkdir C:\Oracle\home\bifoundation\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository\

Right after this command also this error message will be history. You can copy all your repositories to this directory then for quick access, as this will be the directory AdminTool looks first, if you want to.


If all runs sucessfully next you can do is start your admintool.exe right from your DOS box or from Windows directly.

You’ll get an error message, because we haven’t set our environment path the way AdminTool wants us to.


image

So, add the ORACLE_INSTANCE variable to your environment

image


I know one has to do some work, but as of now everything I tested in AdminTool was running, so in my opinion this 20 minutes are worth it.

image


image

Now you can define your ODBC Data sources from your windows PC, having the server components on a smooth Linux 32/64 Bit operating system.

One last hint: do not be astonished, when starting AdminTool it will create some additional folders in your directory. It seems to need them….

image

Just one last hint: a colleague of mine tested this with 64 Bit version of Windows 7, unfortunately it was not running. But I think give it a try, perhaps you're the lucky one or you'll find out where the problem lies. If so, please let me know, this would be highly appreciated.

Have fun and so long,
Andreas

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Post
  • Good to see you back blogging, and what a great post to return with! :-) I always like to see hacks like this.

    Just to add my €0.02, how about using cygwin for the regsvr32 bit:

    ls *.dll|xargs regsvr32 /s

    Didn't know about the alt-C shortcut in Notepad++ - I always do alt-drag to get a columnar cursor to type text with.

    cheers, Robin.

  • Hi Robin,

    thanks a lot for your comment. Good to read that I am not forgotten.

    Good question about cygwin though. Honestly I didn't try, but let me check next week when I am back at my customer. They wanted to use Cygwin anyhow.

    You know: a program without shortcuts is not a program, it's simply a mess ! Just my opinion.

    I'll follow up on the cygwin thing here then.

    So long,

    Andreas

  • It took me a couple of tries to get going with cygwin. The installer is way over the top IMO. However once it's installed it's a real pleasure being able to fall back on *nix-power when it's called for.

  • Hey Robin,

    I am glad you made it with Cygwin. And I totally agree: Unix/Linux Power is a very important "asset" when power's needed.

    Hear you and so long,

    Andreas

  • I follow the steps, but i cannot connect to server because the ODBC Driver is not installed. I have "Oracle BI Server" ODBC from BIEE 10 installed, that is not compatible.

    I cannot found a installer for ODBC driver BI Server 11.

  • Hi Alfonso,

    there is some "stuff" you need to do for this. Just drop me a mail with your mail-adress over the blog mail-form and I'll help you on this.

    So long,

    Andreas

  • hi.....is it possible to install obiee without installing oracle. is it possible please tell me thae answer;

  • I have followed your method. Now I am looking for ODBC driver BI Server 11 installation. Please help me

    Thanks

    bhadra@asianetindia.com

  • Hi all

    @Santos,

    my next blog will be about that. I am working on that and it'll be published latest on wednesday this week I think.

    If I can arrange I will provide you with a preview tomorrow morning, OK ?

    @Kaja:

    I don't know what you mean exactly. You mean is it possible to install OBIEE without having the Oracle database ? Or the Oracle Weblogic Server ?

    Answer to first question is yes: you can import metadata from quite a bunch of different data sources (IBM DB2, MS SQL Server, Teradata, Essbase, SAP BW, of course Oracle and many more).

    Answer to question two is no: as far I know you cannot use OBIEE without WLS as Application server as of now. But if wanted you can use other web servers like Apache 2.0+, IIS 6.0+ or Oracle HTTP Server 11gR1.

    So long,

    Andreas

  • Hello Andreas

    Thanks for a great hack have you been able to get this working on 64bit Windows 7.

    I would love to know the solution

  • Hi Richard,

    first of all a happy new year to you and your beloved ones !  Sorry for answering this late, but I had some days off for the seasons end.

    To your question:

    as far as I know the client is not working on 64 Bit operating systems. The only solution I can think of is to install a Java version and the MFC classes in 32 Bit and try it. We unfortunately had no time to dig more into this topic.

    But as I just heard before christmas Oracle will provide a Client only install within the next patch set, so watch out for OTN. I am quite sure it will come out soon.

    So long,

    Andreas

  • After the Admin Client Only installation blog a lot of people asked me how to install the ODBC drivers

  • Hi ,

    It is really brilliant stuff, I tried it and working like butter :).

    Thanks a lot.

    -Niraj

  • Ping Antwort von  OBIEE 11g on CentOS 5.5 – the install from the VirtualBox to stand-alone Admin Tool – Hyperion, Linux, Oracle and Video Games

  • Hi Niraj,

    I am glad it worked for you !

    So long,

    Andreas

Page 1 of 2 (17 items) 12
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Post