Tuesday Sep 09, 2014

How Diagnostic Assistant can make your life easier

(in via Torben)

With all the tools we provide to make things easier to troubleshoot your product issues, its not difficult to miss the odd one that may be just what you need.
One of the things that has always made me personally unhappy was that there was no user interface to Remote Diagnostic Agent (RDA), except for the command line.
From my point of view, a tool that exists to assist people with troubleshooting should be easy and intuitive to use. It should make things easier, not more complex. And command lines, powerful as they are, may scare users away.

I then learned about Diagnostic Assistant and
that it is pretty much an out of the box GUI to RDA.

So Diagnostic Assistant (DA) should make things a lot easier when you are asked to provide an RDA Profile on your next SR.

And here is how it is used:


All you need to do is:

  • download the latest DA/RDA bundle from the  "RDA - Getting started" Doc ID 314422.1
  • deflate in a directory of your choice
    (we usually prefer this to be below the EPM home: "...\Oracle\Middleware\EPMSystem11R1" or on *NIX systems: ".../Oracle/Middleware/EPMSystem11R1" )
  • switch to the .../Oracle/Middleware/EPMSystem11R1/rda/da subdirectory and
  • start the webUI with

da.<ext> startweb pass=<password>
(<ext> would be either .cmd on windows, .sh on *NIX; <password> is a password of your choice)

This is pretty much the only bit of code that you would need to remember and it is also in the help.
On *NIX just run "da.sh" and on windows run "da.cmd menu" to get the syntax in case you forget.

What you'd see now should be similar to this:

(click to open full size in new tab)

Your next step is to navigate the web interface at the given address (here: http://<servername>:8888/index.html) .


Your login is "admin" with the <password> that you just specified.
For a typical Hyperion Profile you would select the steps:

1) select your Product Line

2) select in more detail

3) select your actual product

4) select the profile associated with your product

5) and run it (note that DA already detects the PATH to EPM home and Oracle Home if needed)

 Once you have clicked the "run" button DA will then create a RDA Profile output under:

including the zipped and the deflated version which are conveniently displayed in your browser window already.

example for an OS collection

Other collections like the one for the OS are just as easy to run:


In the DA menu under MOS Tools you then find "MOS upload" where you can specify your MOS username and password and specify the SR that you want to upload this collection to.


Once you are finished with DA, you can go back to the command line that you used to start up DA and now simply stop it with:

da.<ext> stopweb

So - next time that you are asked to provide a RDA Profile for a Service Request, simply kick off DA and with a few clicks you have the desired collection done and uploaded.

Here's more information we've posted on the blog about RDA

(post and layout: Torben; authorized: Lia)

Friday Jun 13, 2014

Use Enterprise Manager Cloud Control to monitor OBIEE Dashboards

(in via Senthil

If your OBIEE is set up in the following way:

  1. The OBIEE repository is an Oracle Database and is set up as a data warehouse
  2. Usage tracking is enabled in OBIEE.
    ( For information on how to enable usage tracking in OBIEE, refer to the following link: Setting Up Usage Tracking in Oracle BI 11g )
  3. The OBIEE instance is discovered in EM Cloud Control.
    ( For information on how to discover an OBIEE instance in Cloud Control, refer to the following link: Discovering Oracle Business Intelligence Instance and Oracle Essbase Targets )
  4. The OBIEE repository is discovered in EM Cloud Control.
    ( For information on how to discover an Oracle database, refer to the following link: Discovering, Promoting, and Adding Database Targets )

then we've got news for you:

KM Article:  OBIEE 11g: How To Diagnose Slowly Performing Dashboards using Enterprise Manager Cloud Control (Doc ID 1668236.1)

takes you step by step through monitoring the SQL query performance behind your OBIEE dashboard.

This Diagnostic approach ...

  • .. will help you piece together information on BI dashboard performance, e.g. processing time from the different layers of the BI system including the repository.
  • .. should enable you to get to the bottom of slow dashboards by using the wealth of information available in EM Cloud Control on OBIEE and Oracle DB.
  • .. will NOT fix any performance issues on its own, but will help identify bottlenecks while processing dashboard requests.

(layout and post: Torben, authorized: Lia)

Tuesday Apr 08, 2014

Advisor Webcast: Troubleshooting Essbase Analytics Link

Advisor Webcast

 Troubleshooting Essbase Analytics Link

16th April 2014

This one-hour session is recommended for technical and functional users who use and administer Essbase Analytics Link.

The Advisor Webcast will cover installation preparation and planning, troubleshooting techniques, log file locations, how to read and interpret the logs as well as talk about the internal communication between EAL components.

In addition the Ports and Protocols used as well as the prerequisites to establish the connections will be addressed, with a quick look at tools to assist with troubleshooting.


  • EAL Architecture
  • EAL Communication Paths
  • Use Cases
  • Troubleshooting Installation and Configuration

Register Now - visit:

Troubleshooting Essbase Analytics Link
Doc ID 1633062.1


To view scheduled & archived recordings of previous Business Analytics Advisor Webcasts visit:

Oracle Business Analytics Advisor Webcast [Doc ID 1456233.1]


Attendees using recent Chrome or Firefox browser versions maybe required to activate the WebEx plug-in before joining a WebEx meeting.

For up to-date information ensure to review the WebEx Support page:

Thursday Sep 26, 2013

Troubleshooting the Web Center Portal / OBIEE integration

(in via Julie)

Julie sent me her latest addition to the Knowledgebase: 

Troubleshooting the Integration of Oracle WebCenter Portal and Oracle Business Intelligence (Doc ID 1579858.1)

In her mail she explained:

"Having issues with embedding your OBIEE Reports in WebCenter Portal?
This troubleshooting document contains quick checks for you to test and solutions to issues that may arise.
There are details of log files to look at to help you identify the issue.
The integration uses SOAP connections and the impersonate abilities of OBIEE to ensure reports and data are secured correctly.
If this is not set up correctly, the integration will fail, steps of how to check this are also included in the note.

We hope to make the integration of the two a little easier for everyone.

Thursday Jul 04, 2013

OBIEE Advisor Webcasts coming this month

Coming to you in July ...

During this July the Proactive Support Team will be presenting the following Advisor Webcasts for Oracle Business Intelligence Enterprise Edition (OBIEE).

  • OBIEE 11g Using and Troubleshooting on Mobile Devices

July 23rd (15:00 GMT/UTC) - Recommended for technical and functional users who want to use OBIEE's capabilities but not be tied to a wired network. That is anyone needing reports on a smartphone or tablet. That could be a CEO, or a someone working out in the field. This presentation describes the functionality available on mobile and how to set it up and which mobile devices are supported.

  • OBIEE 11g New Features
July 30th (13:00 GMT/UTC) - Recommended for technical and functional users who want to know what are the latest features with OBIEE and

To register for these simply visit Oracle Business Analytics Advisor Webcast Schedule and Archive Recordings and follow the registration links.

Missed an Advisor Webcast?   You can also review any of the past Advise Webcasts via the Archived pages at:

Oracle Business Analytics Advisor Webcast Schedule and Archive Recordings

Document 1456233.1

Wednesday Jun 20, 2012

Troubleshooting OBIEE Common Configuration Errors

Common Configuration Errors in OBIEE have now a new opponent:

KM Note 1359798.1 contains a Whitepaper (PDF) to deal with some of the common errors.

So if your questions are about:

  • System User authentication
  • Reasons Why a User May Not Be Able To Login
  • and other authentification problems

then this might be just the note for you.

Wednesday Jan 25, 2012

Tips and Tricks with Enterprise Manager - troubleshooting EPM/BI

guest article by Maurice Bauhahn:

As a hopeless DIYer (do it yourself-er) I seldom start with an adequate set of the right tools to hand to complete a job (such as when I recently replaced the plug on a soymilk making machine bought in Cambodia...a project which ultimately involved multiple screwdrivers, a volt-meter, a pair of pliers, and a knife...and no documentation .

When you start DIY troubleshooting problems in the Oracle Hyperion EPM or OBIEE environments, however, you need not fear a lack of tools or a lack of documentation.

Your software elves at Oracle have bundled two large toolboxes full of useful tools with EPM 11.1.2.x and OBIEE 11g installs: Remote Diagnostic Assistant (RDA) and Enterprise Manager (EM).

Earlier in this blog you will find details on RDA in the RDA Advisor Webcast.

Our EPM developers have written some Tips&Tricks hints in a document on how you may deploy EM. (Alternatively if that file is replaced with one of a different name do a web search for: >> "Enterprise Manager" EPM Tips << )

OBIEE's installer automatically deploys the EM tool. I'm eager to prepare a Webcast Advisor on EM...but need to patiently await the next EPM release with its added functionality.

Meanwhile enjoy exploring your local http://<WebLogicAdminServer>:7001/em and http://<WebLogicAdminServer>:7001/dms

Use '/em' to slice and dice your logs and '/dms' (Dynamic Monitoring Service) to track memory and load on your Java servlets.

Feel more confident in your next EPM and OBIEE DIY troubleshooting task...the tools you need are near at hand!

Cheers, Maurice

This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.




« March 2015