Select Page

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

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.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS