Thursday Jun 11, 2015

Remote Diagnostic Agent - RDA 8.08 released

(in via Ian)
We are happy to announce the release of

Remote Diagnostic Agent (RDA) 8.08

RDA 8.08 contains a number of changes in the Hyperion112_xxx profiles.

Among the RDA changes for Enterprise Performance Management (EPM) are:
  • Collects data on  Unix for the Hyperion1112_HFM profile
  • Collects OS and some user settings for all the Hyperion Profiles


The changes implemented reduce the number of questions asked in the Hyperion Profiles.

Using RDA allows Oracle Support to troubleshoot software issues even faster.


Release announcement (including full list of additions):
 Oracle Support Announces RDA 8 - Production Release! (Doc ID 392719.1)

Getting started KM doc:
Remote Diagnostic Agent (RDA) - Getting Started (Doc ID 314422.1)

Profile Manuals:
Remote Diagnostic Agent (RDA) - Profile Manual Pages (Doc ID 391983.1

(info:Ian; text and layout: Torben; authorized: Lia) 

Friday Sep 12, 2014

RDA 8.05 now released

(in via Maurice)

Oracle has released Remote Diagnostic Agent version 8.05 and Diagnostic Assistant version 2.5 (9th September 2014).

The Remote Diagnostic Agent (with bundled Diagnostic Assistant) is available for download from:

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

NEW FEATURES OF REMOTE DIAGNOSTIC AGENT 8.05
(related to Hyperion Applications)

  • From a Hyperion perspective, functionality has been added to the following modules to detect whether the executables are 32-bit enabled or 64-bit enabled:

EPM Module (encountered in the Enterprise Performance Management profile)
EPMA Module (encountered in the Enterprise Performance Management Architect profile)
ESS Module (encountered in the Essbase server profile)
HFM Module (encountered in the Hyperion Financial Management profile)
HFR Module (encountered in the Hyperion Financial Reporting profile)
HIR Module (encountered in the Hyperion Interactive Reporting profile)
HPL Module (encountered in the Hyperion Planning profile)
HSF Module (encountered in the Hyperion Strategic Finance profile)

This process can be useful to detect if a 32-bit executable install was undertaken when there should have been a 64-bit install ... or vice-versa ... where a 64-bit installation was wrongly performed on a 32-bit OS environment

Note:

  • Some applications are only available in 32-bit regardless of the environment. For example: SQR/Production Reporting or Interactive Reporting are always 32-bit on Linux even when the OS is 64-bit (and SQR can be 64-bit on other environments).
  • When an application is 32-bit the non-JDBC database libraries connecting with it need to be 32-bit as well.

For a complete list of available Profiles see:

Remote Diagnostic Agent (RDA) - Profile Manual Pages
Doc ID 391983.1

  • Precision versioning has been added to the ESS Module
    (encountered in the Essbase server profile).

  • EPM Module undertakes extended log file collections.

DETAILS ABOUT DIAGNOSTIC ASSISTANT 2.5:

When using the Diagnostic Assistant a password for the "admin" user account is required on the web interface

e.g. http://<servername>:8888/index.html

Do not try to pass a new password parameter via a hyphen or minus sign on the web server!

e.g. the following would be an invalid line:
       wda.cmd startweb -pass=mypassword

Instead the following should be used:

"da.<ext> startweb pass=<password>" (no hyphen).


Examples:

"da.cmd startweb pass=mypassword" or
"da.sh startweb"

The above examples will work. If a password is not specified, one will be created and displayed when Diagnostic Assistant starts.

Where the network domain is inaccessible, you will need to provide your own password.

If the automatic mechanism fails, provide a custom password after "pass=".

For more information on Diagnostic Assistant, read the our previous blogpost:

How Diagnostic Assistant can make your life easier



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:

install/start

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) .

execute

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:

.../Oracle/Middleware/EPMSystem11R1/rda/da/output/rda/<profilename>
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:


upload

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.

stop

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)




Tuesday Jun 17, 2014

RDA 8.04 has been Released

The RDA developers have done it again! They have released a new version of the product (8.04) on schedule (Tuesday 10 June 2014).

The new bundled (RDA, DA, OCM) downloads are available in the KM article:
 "Remote Diagnostic Agent (RDA) - Getting Started" (Doc ID 314422.1)".
To learn more about Diagnostic Assistant, you may refer to
"Diagnostic Assistant: General Information" (Doc ID 201804.1)

If the RDA install on your system came with the default files (and you have not manually installed RDA), you can run an opatch updater instead:
"Resolve Problems Faster! Use Remote Diagnostic Agent ( RDA ) - Fusion Middleware and WebLogic Server" (Doc ID 1498376.1)
in the
"Quick Guide" tab [ OPatch bundle 18904462].

The  Bill of Materials for this version indicates that there were no new Hyperion modules released with version 8.04, but existing modules were improved. All RDA Hyperion profiles (which begin with the string, "Hyperion1112_" with the exception of Crystal Ball) now detect and suggest a default value for MIDDLEWARE_HOME. Additional improvements have been made to the Hyperion1112_HIR, Hyperion1112_HFM, and Hyperion1112_HSS profiles.

Several Diagnostic Assistant improvements (i.e., to collect and process certain parameters, and especially to simplify JDBC URL selection) missed the release deadline, so it would be best to run the following profiles from the RDA command line instead of via DA: 

  • Hyperion1112_EPMA
  • Hyperion1112_ESS
  • Hyperion1112_FCM
  • Hyperion1112_HFM and
  • Hyperion1112_HIR


Sample command lines could be:

when using perl:
perl rda.pl -vnSCRPp Hyperion1112_EPMA

On Unix/Linux Systems:
rda.sh -vnSCRPp Hyperion1112_ESS

On Windows:
rda.cmd -vnSCRPp Hyperion1112_FCM

-v = verbose (show output on screen)
-n = new collection (forget about the last one)
-S = Setup
-C = Collect (actually run this whole thing)
-R = Report (format the output in HTML)
-P = Package (zip the collection)
-p = run a Profile (as opposed to a module like OS, or DB)


To revert to a 'clean slate' before each run of Diagnostic Assistant use the -n option.

Alternatively, use the manual ways:

  1. Delete the DA_OUTPUT directory's config file, daenv.cmd|.sh, before each run.
    OR
  2. Set a different DA_OUTPUT path before each run, ie.
    set DA_OUTPUT=C:\tmp\da_output1
    da.cmd menu

(layout and post: Torben, authorized: Lia)

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 reg.properties.

  • 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 >da.sh menu)
    3. >da.cmd startweb (or >da.sh startweb)
    4. Point browser to "http://localhost:8888" (user 'admin'; password 'welcome1')
    5. >da.cmd stopweb (or >da.sh 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 11.1.2.1 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.

Note:
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>;
commit;


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 11.1.2.3 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 rda.pl -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 11.1.2.1 (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 :)

.T

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:https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=567729.1

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


About


This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.
Authors:
Lia, Torben, Paul, Julie





Search

Archives
« September 2015
SunMonTueWedThuFriSat
  
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today