Friday Sep 18, 2015

Remote Diagnostic Agent - RDA 8.09 released

The latest quarterly release has been made available for:

Remote Diagnostic Agent (RDA) 8.09

The RDA Bundle 8.09 can be downloaded from My Oracle Support (MOS) Knowledge Article:

Remote Diagnostic Agent (RDA) - Getting Started
Doc ID 314422.1

Refer to the "Download RDA" section on the main RDA page, and then select the RDA zip file for relevant platform by clicking on the related link. Each zip file contains all the files required.

Why Use RDA?

"Oracle strongly encourages the use of Remote Diagnostic Agent (RDA) diagnostics collections because it provides a comprehensive picture of the customer's environment. Providing RDA diagnostic output, especially when submitting a Service Request online, can minimize the requirement for follow up questions that may delay problem resolution."

More Information ...

The RDA 8.09 New Features and Improvements are outlined in:

Doc ID 392719.1: Oracle Support Announces RDA 8 - Production Release!

A comprehensive Frequently Asked Questions (FAQ) has been documented in:

Doc ID 330363.1: Remote Diagnostic Agent - FAQ

Listing of the available Collection Profiles are outlned in article:

Doc ID 391983.1: Remote Diagnostic Agent - Profile Manual Pages

Training is available by viewlet presentations describing step-by-step instructions for installing and executing RDA:

Doc ID 330344.1: Remote Diagnostic Agent - Training

Links to the RDA documentation are listed in:

Doc ID 414966.1: Remote Diagnostic Agent - RDA Documentation Index

For related information on the recent release of Diagnostic Assistant (DA) 2.9.0 visit:

Diagnostic Assistant: Information Center
Doc ID 201804.2

The DA tool provides a common, light-weight interface to multiple diagnostic collection tools, which includes RDA, and is bundled with RDA 8.09.

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 "" 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 regarding Oracle EPM abd BI.
Tanya Heise


« July 2016