Applies to:
Hyperion Essbase - Version 11.1.2.1.000 to 11.1.2.2.000 [Release 11.1]
Hyperion Planning - Version 11.1.2.0.00 to 11.1.2.2.000 [Release 11.1]
Hyperion Financial Management - Version 11.1.2.0.00 to 11.1.2.2.000 [Release 11.1]
Hyperion BI+ - Version 11.1.2.0.00 to 11.1.2.2.000 [Release 11.1]
Information in this document applies to any platform.
(1) \Oracle\Middleware\user_projects\epmsystem1\bin\ziplogs.bat|.sh
(2) \Oracle\Middleware\ohs\ccr\bin\
(3) \Oracle\Middleware\ohs\rda\rda.cmd
(4) \Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat|.sh
(5) \Oracle\Middleware\user_projects\epmsystem1\bin\validate.bat
Goal
This article aims to help users use various troubleshooting tools to validate or troubleshoot an installation of Oracle EPM 11.1.2.0. or 11.1.2.1
Fix
(1) 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_<servername>_11.1.2.1.0.zip Starting with EPM 11.1.2.2 the logs under \Oracle\Middleware\user_projects\domains\EPMSystem\servers\<server>\logs are also collected.
(2) Oracle Configuration Manager (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
(3) Remote Desktop Assistant (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.
(4) 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.
(5) 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 tool under (1) and gives the output of that tool.
(6) 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\<server>\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\<username>\Oracle\oradiag_<username>\diag\
C:\Users\<username>\.oracle\logs\
(7) Client Debug Some debug tools (*) can be activated if under http://<servername>: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
(8) Enterprise Manager Fusion Middleware 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.
(9) 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.
(10) 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.
(11) 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.
No comments:
Post a Comment