Art of BI: Stopping Oracle BI 11g on Windows without Prompting for Credentials

By | In Art of BI, Big Data, Business Intelligence | January 30th, 2013

I get asked repeatedly about the start and stop process for Oracle BI 11g.  I have some amazing wisdom to share in an

English: Logo of Apache Ant. Deutsch: Logo von...
English: Logo of Apache Ant. Deutsch: Logo von Apache Ant. (Photo credit: Wikipedia)

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”.

Problem

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.

Solution

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.

Contact Us
Christian Screen
Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).

2 thoughts on “Art of BI: Stopping Oracle BI 11g on Windows without Prompting for Credentials”
  1. Hi,
    Need a small help. I removed the line marked with red and tried start and stop of the services. However, it does not stop completely after making this changes and I do not get the commnad prompt.
    Am I missing something ???

  2. yes, you are definitely missing a step. Or you’ve modified the wrong file. Try again or provide some more information and we’ll be okay to assist.