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)

Monday Sep 16, 2013

RDA 8.1 has been released

(in via Maurice)

Remote Diagnostic Agent (RDA) 8.1 was released Tuesday, 10 September 2013.

Download this most recent version of RDA via  My Oracle Support and KM Doc "Remote Diagnostic Agent (RDA) - Getting Started" (314422.1).

A number of significant features have been added to the preinstall tool (health check validation engine, HCVE) of RDA relating to Oracle Hyperion Enterprise Performance Management (EPM) Server 11.1.2.x:

  1. Accesses an Oracle database repository using the SID
  2. Detects important Oracle database parameters (OPEN_CURSORS, SESSION_CACHED_CURSORS)
  3. Collects various library environment variable values (LD_LIBRARY_PATH, LIBPATH, SHLIB_PATH, PATH)
  4. Detects whether Oracle database variable NLS_LENGTH_SEMANTICS has a value of "CHAR" in EPM and earlier
  5. Detects whether Oracle database parameter 'sessions' has appropriate value depending on EPM version.
  6. Determines whether database owner has appropriate rights and roles for Oracle database repository with respect to EPM version.
  7. Link established between EPM applications and .NET framework on Microsoft Windows.
  8. Redundant prompts for tablespace names have been removed.

The value of several of the database parameters may not by default be readable by the Oracle database repository owner, so temporarily that owner's rights may be increased:

sqlplus / as sysdba
grant dba to <username>;

Run the hcve tool and confirm the database parameter values are as recommended.

To withdraw the role added above, run the following in sqlplus as sysdba:

revoke dba from <username>;

It might prove useful to run the RDA hcve tool on a post-installed/post-configured EPM environment, but interpret the 'clean' environment analysis rules differently. 

Thursday Apr 18, 2013

Automation Error in FDM – what can you do?

(in via Mel)

Have you ever seen an Automation Error in FDM not knowing why this happened?
Do you need to log a Service Request to get this resolved?

No, there should be no need to log a Service Request.

With the help of  KM Doc ID 1441863.1 -TROUBLESHOOTING Financial Data Quality Management Error "Automation Error" you will be able to see the main identified causes for this error and with the provided solution you may be able to fix this by yourself.

Should this not help, why not post in the Hyperion FDM Community? We are happy to assist with any issue in here and will make sure that new causes and solutions get added to KM Doc 1441863.1 as they come in.


This blog talks about the latest news and upcoming events regarding Oracle EPM abd BI.
Tanya Heise


« July 2016