Thursday Mar 13, 2014

RDA Version 8.03 Released

(via Maurice)

Remote Diagnostic Agent (RDA) is typically upgraded every calendar quarter, so it was no surprise that on 10 March 2014 the new version 8.03 was released.

Changes incorporated this time include:

  • Facilities were added to access SQL Server and DB2 databases (in addition to the Oracle database) in the Hyperion1112_HIR profile (hopefully the start of similar expansions in other modules). This feature is limited to the Hyperion Shared Services registry database as accessed via

  • Profiles were added to include: Hyperion1112_FDM, Hyperion1112_HDM, Hyperion1112_HPC, Hyperion1112_HPS, and Hyperion1112_HSF.

  • Features were added in RDA 8.03 to the following profiles: Hyperion1112_EAS, Hyperion1112_EPM, Hyperion1112_HFM, Hyperion1112_HIR, Hyperion1112_HPC, Hyperion1112_HSS HCVE EPM Server and EPM Client Tools Improvements.

An early release of 'Hyperion' and 'BI' menus in Diagnostic Assistant is bundled with RDA 8.03. Explore these new features by

  • Navigating into an RDA 8.03 unzipped home on Microsoft Windows (or Unix/Linux)

    1. \rda\da\ (or /rda/da/)
    2. >da.cmd menu (or > menu)
    3. >da.cmd startweb (or > startweb)
    4. Point browser to "http://localhost:8888" (user 'admin'; password 'welcome1')
    5. >da.cmd stopweb (or > stopweb)

Download the newest version via the Knowledge article:

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

For details on how to use RDA specifically for the EPM and BI products refer to:

"Business Analytics Instrumentation Index [Video]"
Doc ID 1514548.1

Wednesday Jan 08, 2014

Remote Diagnostic Agent 8.02 is now available

(in via Maurice)

The Remote Diagnostic Agent 8.02 was released on 15 December 2013.

This version has five new Hyperion modules within the RDA profiles:

  • Collects Oracle Hyperion Financial Data Management Information (BI.FDM module)
  • Collects Oracle Hyperion Disclosure Management Information (BI.HDM module)
  • Collects Oracle Hyperion Profitability & Cost Management Information (BI.HPC module)
  • Collects Oracle Hyperion Performance Scorecard Information (BI.HPS module)
  • Collects Oracle Hyperion Strategic Finance Information (BI.HSF module)

Note that Remote Diagnostic Agent requires the run of Hyperion profiles (not individual modules).  A Hyperion profile name begins 'Hyperion1112_' and concludes with the key module abbreviation in capitals.

It is recommended that the ORACLE_HOME of the Oracle database client be defined (set ORACLE_HOME=C:\Oracle\Middleware\jdk160_21) for the EPM Server hcve Tool (rda.cmd -T hcve) and Hyperion profiles which collect information from the Hyperion Oracle database registry.

Download the newest version via the Knowledge article:

 "Remote Diagnostic Agent (RDA) - Getting Started"
[Doc ID 314422.1].

For details on how to use RDA specifically for the EPM and BI products refer to:

"Business Analytics Instrumentation Index [Video]"
[Doc ID 1514548.1]

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 Jul 25, 2013

Remote Diagnostic Agent (RDA) 8 now available

 (in via Maurice)

Remote Diagnostic Agent (RDA) version 8 was released this week (23 July 2013) after extensive testing.

This most recent version should now be used in preference to earlier RDA versions.  The downloads are available in the following knowledge article on My Oracle Support:

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

Around 216 bugs and enhancements were handled in the process of updating RDA from version 4.31 to version 8.00.

A regular user of RDA will not see many changes as very few modifications have been made to the interface - however of interest:

  • The default output will go into a sub-directory named, "output", that is created on the fly.
  • The chief addition has been the case sensitive (miniscule) parameter, "-s <directory>".  It creates a collector file with the same name appended with ".cfg" as well as a directory with the same name in which the output accumulates.
  • The <directory>.cfg file is located in the directory that RDA was executed from.
  • To improve security, passwords are no longer stored in plain text in the *.cfg file.

The profiles which begin "Hyperion1112_" request the unambiguous path for 'Middleware home' environment variable as opposed to one of the Oracle Homes. RDA modules (all caps names) should not be called directly for Hyperion collections. Profiles (mixed case names starting 'Hyperion1112_') should be called instead.

Hyperion and OBIEE specific improvements are summarized as follows:

  • HCVE: Corrected memory detection, provided version option, improved port detection, improved prior install detection, improved NPTL version detection, proper processor speed is recorded.

  • Hyperion1112_HPSV: Log collection for Hyperion Provider Services has been expanded (especially on Linux).

  • Hyperion1112_EAS: Log collections for Essbase Administration Services have been expanded (especially on Linux).

  • Hyperion1112_HPL: Hyperion Planning start and stop scripts and more logs are now collected.

  • Hyperion1112_HIR: Hyperion Interactive Reporting logs on Linux are now collected and ambiguities in prompts have been removed.

  • Hyperion1112_ESS: Essbase security dumps, logs, and start scripts are now collected.

  • Hyperion1112_EPM: Improved logs and registry dump are now collected and collections no longer crash on Linux.

  • OBIEE: a new Oracle Exalytics module has been released in RDA 8 and an hcve module has been updated.

NOTE: Unfortunately repository database logins are not functioning in the Hyperion profiles of RDA (Oracle, SQL Server, DB2)

Thursday Dec 13, 2012

Remote Diagnostic Agent (RDA) version 4.30

posted by Maurice Bauhahn

Remote Diagnostic Agent (RDA) version 4.30 was released on December 11th

A free download can be accessed via Knowledge Management article  314422.1 and installed in any Enterprise Performance Management 11.1.2.x environment. EPM-specific instructions are available in Knowledge Management article 1304885.1.

This RDA version incorporates two new modules (EAS=Essbase Administration Services; HWA=Hyperion Web Analysis) and improvements in modules and profiles relating to twelve other Hyperion applications (EPM, EPMA, ESS, FCM, HFM, HFR, HIR, HPL, HPSV, HSS, PR, and HSV).

To follow best practice, run related RDA profiles [for example: "perl -vnSCRPp Hyperion1112_EAS"] and attach the output zip file [by default in \rda\output\] to your service requests. The comprehensive set of details provided in such output files should help technicians to avoid delays in handling service requests (by avoiding ping-pong communications resulting from repeated requests for additional values).

Thursday Jun 14, 2012

RDA version 4.28 released

Oracle proudly presents:

RDA 4.28

 This version of RDA comes with

  • a new HCVE rule set (pre installation checks) Doc ID 1435695.1
  • now alsocollects Calc Manager Information

Enjoy a faster resolution and clear communication about what Software is installed, the logs retrieved and have Tech Support react faster to the issue at hand by getting a detailed overview of the system they are dealing with.

More information about RDA in general can be found here.

Friday May 25, 2012

Oracle Diagnostic Framework and EPM - a practical approach

Today I  was pointed towards a KM article:

Using Oracle Diagnostic Framework to Troubleshoot Oracle Hyperion EPM 11.1.2.x (Doc ID 1408604.1)

It contains a fine explanation of what the Oracle Diagnostic Framework (ODF) actually is:

"Oracle Diagnostic Framework (DFW) has been built into a wide variety of Oracle products classified as 'Middleware'. DFW depends upon prior configuration of a dfw_config.xml configuration file whereby an application upon receipt of a trigger, exports a pre-defined set of logs/traces/dumps to an Automatic Diagnostics Repository (each with a complex hierarchy of subdirectories). A minimal configuration of dfw_config.xml files has by default been implemented in EPM 11.1.2.x."

All the details about the setup, how it is done and what commands to use to get it running are great.
If you want to use ODF with EPM and set it up you are absolutely right there.

But I would be even happier, if this would include the information (or link to it) from these two articles:

How To Use Incident Packages and ISS Viewer (Doc ID 1402104.1)
Use Enterprise Manager Fusion Middleware Control to Troubleshoot Oracle Hyperion Enterprise Performance Management 11.1.2 Family of Products (Doc ID 1456485.1)

Once you have read and understood these, you will not only know how to get EPM and ODF working together, you will also know what to do with the resulting information and how it may assist you in troubleshooting your EPM issues.

Remember that running ODF and RDA will assist Oracle Technical Support in great detail and will result in faster resolution of Service Requests.

Are you still unsure about RDA?  Check out the recording of the RDA webcast from December
or review these:

Remote Diagnotics Agent (RDA) Step-by-Step Instructions for EPM Essbase Systems (Doc ID 1411573.1)
Using Remote Diagnostic Agent (RDA) to Troubleshoot Oracle Hyperion EPM (Doc ID 1304885.1)

My hope is that you bookmark these articles to get back to them in case you need them.
And may this be so rare that you need the bookmarks to look up the commands to run them :)


Wednesday Mar 14, 2012

RDA 4.27 released

Good news for troubleshooters:
the latest version 4.27 of Remote Diagnostig Agent (RDA) has been released.

You can find more information about RDA releases in the KM note:
RDA 4 Release Notes (Doc ID 414970.1)

RDA collects System and/or Product information, configuration and displays this nicely as a HTML page.The packaged information can be attached to Service Requests and will assist Support in identifying issues. This will speed up the resolution of software issues.

The recordings of two recent Webcasts about RDA can be found here:
RDA with EPM and
RDA against SOA

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

Friday Nov 11, 2011

Advisor Webcast: Remote Diagnostic Agent (RDA) Use with EPM/BI Applications

Maurice Bauhan and Ian Bristow will run an Advisor Webcast on the use of RDA with the EPM / BI Applications.

Learn how to install, run, and analyze outputs of Remote Diagnostic Agent.
RDA is a free tool for Oracle customers that could save you time as you work with your subset of most Oracle software.

This one-hour session presented by senior proactive support engineers is recommended for technical users and support contacts.

The session will include information on:

  • Download and install of Remote Diagnostic Agent
  • Run RDA, narrowing data retrieval to the context of Oracle products you need to investigate
  • Analyze the RDA program outputs
  • Via My Oracle Support Help the engineers at Oracle and assist communities with what you learn

There will be 2 sessions:

12/15/2011 - 09:00 GMT (10:00 CET) - internal link register here ( note 1376286.1 )
12/15/2011 - 16:00 GMT (17:00 CET) - internal link register here ( note 1376323.1 )

an overview of all upcoming Advisor Webcasts can be found internal link in note 740966.1

Find more information about Advisor Webcasts:

All future Advisor Webcasts | All recorded Advisor Webcasts | Support specific recorded Webcasts


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



« April 2014