Utilities for Troubleshooting Oracle Hyperion Enterprise Performance Management 11.1.2.0 or 11.1.2.1 or 11.1.2.2 or 11.1.2.3

SOLUTION Ziplogs A troubleshooting tool introduced in Oracle EPM 11.1.2.1 is \Oracle\Middleware\user_projects\epmsystem1\bin\ziplogs.bat|.sh file. The output of this is generated in \Oracle\Middleware\user_projects\epmsystem1\diagnostics\ziplogs\EPM_logs__11.1.2.1.0.zip Starting with EPM 11.1.2.2 the logs under \Oracle\Middleware\user_projects\domains\EPMSystem\servers\\logs are also collected. Video Oracle Configuration Manager (OCM) OCM is an advanced tool which collects and evaluates settings from configuration files (but not Hyperion Registry) and stores them in a central database administered by Oracle. It was first introduced into EPM in version 11.1.2.0 Remote Diagnostic Agent (RDA) RDA collects and zips up a large amount of information concerning the software and hardware environments of Oracle products. If Perl 5.005 or later is installed on the computer and accessible from the command line (test: perl -version), then run: \Oracle\Middleware\ohs\rda\perl rda.pl from the command line to access the RDA tool. Alternately, precompiled RDA executables are available for several platforms (rda.cmd, rda.sh, rda.bat). View an RDA webcast from the https://oracleaw.webex.com reference site listed below. This tool is frequently updated. RDA has profiles for 23 or more Hyperion applications and two preinstall tools for use with EPM. Video Diagnostic Assistant Diagnostic Assistant is a Java-based front end that can interface with Remote Diagnostic Agent (and a number of other tools) to provide a series of menus either on the command line or via a browser. Users do not have to recall the various RDA commands or profile names...so DA greatly simplifies the running of RDA. epmsys_registry Configuration settings have been moved from configuration files to a database repository associated with Shared Services. These may be extracted to an HTML formatted file by running \Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat|.sh without parameters from the command line. The output is generated to file \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\registry.html The username/login/jdbc URL for the Hyperion/HSS registry are kept in \Oracle\Middleware\user_projects\epmsystem1\config\foundation\11.1.2.0\reg.properties file. 'epmsys_registry.bat|.sh report deployment' will generate a file named deployment_report.html in the same \reports\ directory starting with EPM version 11.1.2.2. Validate A validation tool is available in \Oracle\Middleware\user_projects\epmsystem1\bin\validate.bat. In EPM 11.1.2.1 and later the output files are of the form \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\instance_report_20YYMMDD_######.html (where YY is the year, MM is the month, DD is the day, and ###### is a unique integer). It also runs the ziplog tool and gives the output of that tool. Another name for this tool is: EPM System Diagnostic. Non-ziplog Individual log files may be found in subdirectories under (those 'starred' are not collected by ziplogs prior to EPM 11.1.2.2): \Oracle\Middleware\user_projects\domains\EPMSystem\servers\\logs * \Oracle\Middleware\logs * \Oracle\Middleware\wlserver_10.3 * \Oracle\Middleware\user_projects\epmsystem1\tmp * \Oracle\Middleware\ohs\cfgtoollogs\opatch * \Oracle\Middleware\EPMSystem11R1\diagnostics\logs \Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\ \Program Files\Oracle\Inventory\logs C:\Users\\Oracle\oradiag_\diag\ C:\Users\\.oracle\logs\ Client Debug Some debug tools (*) can be activated if under http://:19000/workspace/index.jsp > Navigate > Administration > Workspace Server Settings > Client Debug Enabled: is set to Yes (then click 'OK' button, close all browser windows, and restart browser). * http://hostname:19000/workspace/debug/configInfo.jsp * http://hostname:19000/workspace/debug/userInfo.jsp * http://hostname:19000/workspace/debug/userGroupQuery.jsp Other tools are available at these URLs (largely derived from validate.bat output). A non-Error response indicates that the web service of each particular application is active.: http://hostname:19000/workspace/status http://hostname:19000/workspace/BPMContext http://hostname:8600/mappingtool/faces/info.jspx http://hostname:10080/easconsole/console.html http://hostname:16000/WebAnalysis http://hostname:6373/oracle-epm-fm-webservices/ApplicationService http://hostname:8300/HyperionPlanning/ http://hostname:13080/aps/APS http://hostname:8200/hr/status.jsp http://hostname:19091/awb/conf/AwbConfig.xml http://hostname:8500/calcmgr/index.htm Enterprise Manager Fusion Middleware This is the standard Oracle graphic user interface debugging and configuration tool. Although advanced versions require extra cost licensing, there is a bundled version of Enterprise Manager Fusion Middleware control available by default with EPM.  It is hoped that ECID (Execution Context ID) functionality will be widely incorporated with the 'Hyperion' product stack after EPM version 11.1.2.2. registry-cleanup From EPM 11.1.2.2 a new tool has been made available to clean the Hyperion Registry: \Oracle\Middleware\user_projects\epmsystem1\bin\registry-cleanup.bat|.sh. A backported Hyperion Shared Services patch (13807599) exposes this tool for EPM 11.1.2.1. resetConfigTask From EPM 11.1.2.2 another new tool has been made available to reset configurations: \Oracle\Middleware\user_projects\epmsystem1\bin\resetConfigTask.bat|.sh. epmsys_hostname checker From EPM 11.1.2.2 another new tool has been made available from the install directory: epmsys_hostname.bat|.sh which confirms the hostname in the network environment. deployment report From EPM 11.1.2.2 a new tool was made available to track each step of EPM deployment. It uses epmsys_registry tool, varying according to the parameters ("report deployment"). A backported Hyperion Shared Services patch (13530721) extends to EPM 11.1.2.1 a subset of the functions of this tool. Oracle Diagnostic Framework Two scripting languages are used to create and bundle dumps (WLST and ADRCI). There are also configuration files which are used to automatically trigger diagnostic dumps. Log Analysis From EPM 11.1.2.3 this command line tool to slice and dice EPM logs was made available. It can access logs in situ as well as logs in a series of file directory hierarchies. A backported Hyperion Shared Services patch (17425397) extends a standalone use of this tool in EPM 11.1.2.1 and 11.1.2.2. Java VisualVM Java JDKs on Microsoft Windows included with Enterprise Performance Management contain the jvisualvm.exe executable. More details on how to use this tool are available in KM article [950621.1]. It tracks via a graphic user interface: CPU, Memory, Classes, and Threads. JConsole Java JDKs on Microsoft Windows included with Enterprise Performance Management contain the jconsole.exe executable. Its major headings are: Overview, memory, threads, classes, VM Summary, MBeans. JRockit Mission Control/Flight Recorder The Oracle JRockit JDK inherited from BEA contains on Microsoft Windows the executable jrmc.exe. Although it is more complicated to set up, it also is more finely granulated allowing the analyst to pinpoint individual servlets. For each servlet one would investigate and configured in the Microsoft Windows registry  two JVMOptions must be created and JVMOptionCount must be incremented by 2 decimal. One JVMOption would be assigned the value: -XX:+FlightRecorder and the second would be assigned an arbitrary non-duplicate port similar to the following: -Xmanagement:port=8888,ssl=false,authenticate=false WebLogic would then be restarted. Subsequently when Oracle JRockit Mission Control (jrmc.exe) is started a new 'Connector' would be created in the tool, using the port number arbitrarily chosen earlier and inserted into the Windows registry. Press the button 'Test connection'...and if the connection is established, an 'OK' message will appear to the left of the button. REFERENCES NOTE:1404239.1 - Oracle Configuration Manager (OCM) and Oracle Hyperion Enterprise Performance Management (EPM) NOTE:1092825.1 - Using RDA To Collect Configuration, Diagnostic and Log Files on an Oracle Essbase v9.3.x or v11.1.1.x Server NOTE:1408604.1 - Using Oracle Diagnostic Framework to Troubleshoot Oracle Hyperion EPM 11.1.2.x [Video] NOTE:1491179.1 - Enterprise Performance Management 11.1.2 Server RDA Preinstall Health Check (HCVE) [Video] NOTE:1435695.1 - Enterprise Performance Management 11.1.2 Client RDA Preinstall Health Check (HCVE) [Video] NOTE:1100612.1 - How to Use Remote Diagnostic Agent (RDA) to Gather Diagnostic Information On Oracle Hyperion Financial Management Servers to Help Resolve Service Requests Faster [Video] NOTE:1304885.1 - Using Remote Diagnostic Agent (RDA) to Troubleshoot Oracle Hyperion EPM 11.1.2.x [Video] NOTE:950621.1 - Use VisualVM Tools to Troubleshoot UCM and Observe Performance Problems Occurring in Java Virtual Machine (JVM)

Attachments

• Run ADRCi(25.03 MB)
• Run Enterprise Manager Fusion Middleware(42.58 MB)
• Run JRockit Mission Control(12.17 MB)
• Run JRockit GUI(31.51 MB)
• Configure Microsoft Windows Registry for JRockit(30.17 MB)
• Run deployment report(12.52 MB)
• Run epmsys_registry(2.92 MB)
• Run JConsole(3.92 MB)
• Run Java VisualVM(2.88 MB)
• Run RDA via a web browser using DA(7.95 MB)
• Run RDA on command line or DA on command line(6.26 MB)
• Run Registry Cleanup(9.14 MB)
• Run resetConfigTask(5.72 MB)
• Run validate(39.75 MB)
• Run WebLogic Scripting Tool(43.47 MB)
• Run ziplogs(4.32 MB)