Art of BI: Launching the OBI 11g Admin Tool is Sensitive – Properties Required!
Christian Screen | | January 6, 2011
The Oracle BI 11g the Administration Tool is still available, of course but beware of your method in launching said application. In OBI 10g, one could quickly locate the admintool.exe file in the folder directory or make a shortcut from the programs menu and place it onto the desktop for quick reference. But, in OBI 11g this is not quite as easy.
The OBI 11g version of the Administration Tool requires a few checks and environment variable settings before it can launch correctly. When the AdminTool launches correctly you should notice that a command prompt window also launches and will remain open on the desktop.
Closing either of the windows (adminTool or command prompt) will close the application. If you don’t see both of these windows when the adminTool is launched, you are doing something wrong. Take a look at the properties of the program from the program menu for Oracle Business Intelligence. You’ll see that the Target syntax is quite loaded. Compare it to its 10g predecessor (see image comparisons below) and you can see what I am talking about.
Here is what the 11g Target syntax contains:
C:WINDOWSsystem32cmd.exe "/cC:OracleMiddlewareOBI11ginstancesinstance2bifoundationOracleBIApplicationcoreapplicationsetupbi-init.cmd coreapplication_obis1 2 && C:OracleMiddlewareOBI11gOracle_BI1bifoundationserverbinAdminTool.exe"
I bring this up mainly because, I have been using the shortcut of installing just the client tools (see my workaround blog post) using the software only install (Thanks a lot Oracle for not providing a client only install : ) ). This installs the binaries of OBI 11g including the adminTool.exe file but lacks configuration for one of the files that the simple/enterprise install would install, bi-init.cmd. Of course, this is the one that is required for full “official” launch of the adminTool. So, am I still able to use the AdminTool with the software only install (no post-configuration) method? Yes, I am. But that has limitations. The main limitation I have seen so far is an inability to connect with Essbase or HFM but other RDBMS data sources, etc. seem to be no problem. I am still working through that, but for now, I know if I conduct a client install without a post-configuration using the “software only” installation, I have limitations. ‘Nuf said.
In closing, if in OBI 11g you are using a desktop shortcut to launch the AdminTool or if you are trying to launch it direction from the /server/bin/adminTool.exe location, stop it right now, and save yourself the certain headache of this new process. Clearly one could batch script out the launch if so inclined. I just thought I would give y’all a heads up.
EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.
It’s 2015 and you can now establish totally respectable MS SQL DBA credibility just by mentioning you have been in the game since SQL Server version 9. You may even get the same gasps of shock from some colleagues that used to be reserved for the version 6 veterans.