Art of BI: Stopping Oracle BI 11g on Windows without Prompting for Credentials
Christian Screen | | January 30, 2013
I get asked repeatedly about the start and stop process for Oracle BI 11g. I have some amazing wisdom to share in an
upcoming post but for now the question that I get asked the most is actually from those who are using a Windows Operating System. Since the full Oracle BI 11g installation on Windows provides a Program menu option for Oracle BI with a Start and Stop executable option, most people use this to begin learning Oracle BI 11g. This is not a bad thing, of course. However, there is one caveat that has persisted through the minor releases of Oracle BI 11g which is that the Stop script from the Oracle BI 11g Program menu actually prompts the user for a Weblogic Administrator’s credentials each and every time, no matter what status the boot.properties file is in or how many times the system has been stopped and started in the past. This blog shows you how to remove this annoyance by showing you where and how to modify the code that is causing the “feature”.
So the problem is shown in the screenshot below. This screenshot was taken after being prompted for the credentials where I’ve gone ahead and entered the credentials and simply took the screenshot a little later than I wanted.
However, as you can see when using the option I stated previously, it prompts you to “Please enter the username of a Weblogic admin user”. This happens every time you use the stop function coming from the Oracle BI 11g program menu.
If you must or plan on continued use of Oracle BI 11g on a Windows OS and just feel using this start and stop method is the easiest for you then to prevent getting prompted for the credentials at shutdown follow the steps below.
First, navigate to the actual command executable file that the Stop Oracle BI program files option is actually calling when you select it. You don’t need this first step, I’ve already done the work for you and you can start at the second step so read on. Here’s a quick screenshot of what that file looks like though.
You will notice that it is simply a batch file. You’ll also notice that this file calls another XML based file. This secondary call leverages Apache ANT. Most non-Java Developers have never heard of ANT but let me tell you it is a great tool for compiling and building a project. Oracle’s Dev Squad is somewhat astute so they know what they’re doing.
Second, locate the XML file that is being called, StartStopServices.xml, as we will need to modify it slightly.
Open the StartStopServices.xml file and you will notice that the XML syntax has some type of attributes and conditional formatting laced into it. This is ANT syntax.
For our problem (more the solution, rather) we need to locate the following syntax as shown in the screenshot below.
As any layman can see, there is a conditional operation property being applied to the “should.get.credentials” condition which checks when to prompt a user for the credentials. The conditional check is using the isset variable element for “should.create.credentials” and “is.stop.all”. I’ll give you one guess on which one we need to comment out in order to prevent being prompted when using the Stop Oracle BI services program menu option.
So edit this file (make a backup first genius) by either deleting this line or using XML comment syntax to comment out the line so it is no longer read at runtime. Save the file. Now, as long as your boot.properties file(s) have been set and are properly encrypted (i.e.: you’ve started and stopped your WebLogic Server and Oracle BI 11g system several times previously) you will no longer get prompted for the WebLogic Server admin credentials when selecting the Stop Oracle BI services option from the program menu.
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.