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.
Subscribe to Our Blog
Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.
Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.
EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.