How to enable Debug mode for Oracle HTTP Server (OHS) within for a WebLogic Managed Server

  • Date: June 10, 2020
  • Article by: Joe Malewicki

As a professional Oracle Hyperion EPM infrastructure consultant we have sometimes been stumped by the misbehaving of the Oracle HTP Server (OHS) to WebLogic Managed Servers traffic proxying as deployed within the Oracle Hyperion EPM configuration at clients.  There are occasions in which we just can’t figure out why things aren’t “communicating” like they should.  So, from our little bag of tricks we pull out the old “how to debug the traffic” card and realize that we always forget these simple yet powerful settings.  Hence, the reason I’ve created this blog post!

My memory is going the older I get so after writing and publishing this, I have a place of my own to find these simple steps for those future pesky troubleshooting engagements.

It’s important to note that these procedures will work for Fusion Middleware (FMW) 11g as is embedded and deployed with the oracle Hyperion EPM System 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, and finally 11.1.2.4.  These precures are not applicable for the newly released Oracle Hyperion EPM System 11.2.0 or 11.2.1 as those new versions come with the newer Fusion Middleware (FMW) 12c.  I’ll post another blog with the procedures for that release shortly.

For the context of this blog we are using oracle Hyperion EPM System 11.1.2.4 running on Windows 2012.

Start by creating a target location for the debug logs.  The name is arbitrary just remember wat you called it and where it’s located on the file system as this will be required in the coming steps.

1-Create new directory or folder in Windows

Backup your existing mod_wl_ohs.conf file.  Depending upon which configuration option you selected when deploying the Oracle Hyperion EPM System, this file could be located on the Oracle HTTP Server (OHS) under the config\OHS folder:

C:\Oracle\Middleware\user_projects\<YourInstanceNameHere>\httpConfig\ohs\config\OHS\ohs_component\mod_wl_ohs.conf
2-Standard mod_wl_ohs conf file location
2-Standard mod_wl_ohs conf file location

Or this file could be located under your customized shared EPM folder for the Oracle HTTP Server (OHS) if you chose that option during the Web Server configure task of the config process.  If you’re not sure, take a look at the httpd.conf file for your OHS instance and find the “include section down towards the bottom of the file.  This will give you the currently configured location.  **NOTE** if you have more than one Oracle HTTP Server (OHS) you should confirm on each server this location and ensure they match and point to the same place. If they don’t you need to update each server’s version of the files for context of this blog post.

C:\Oracle\Middleware\user_projects\Foundation1\httpConfig\ohs\config\OHS\ohs_component\httpd.conf
3-Standard OHS httpd conf file location
3-Standard OHS httpd conf file location
include "moduleconf/*.conf"
<VirtualHost *:19000>
    include "//11124-prd/EPMShared/OHS/mod_wl_ohs.conf"
    Include "//11124-prd/EPMShared/OHS/epm_online_help.conf"
    Include "//11124-prd/EPMShared/OHS/epm_rewrite_rules.conf"
    Include "//11124-prd/EPMShared/OHS/epm.conf"
    Include "//11124-prd/EPMShared/OHS/deflate.conf"
</VirtualHost>
4-httpd conf file include section
4-httpd conf file include section

In all of our deployments we use the shared EPM location for the Oracle HTTP Server (OHS) web server configuration task.  This removes the need for us to re-rerun that web server task whenever a change is made to the Oracle Hyperion EPM System software configuration, the OHS files just get updated automatically.

\\<ServerName>\EPMShared\OHS
5-Shared mod_wl_ohs conf file location
5-Shared mod_wl_ohs conf file location

We copied our mod_wl_ohs.conf file to mod_wl_ohs.conf-ORIG:

6-Backup Shared mod_wl_ohs conf file location
6-Backup Shared mod_wl_ohs conf file location

Edit the mod_wl_ohs.conf file to include the OHS logging parameters as required for the WebLogic LocationMatch section of the WebLogic Managed Server you want to debug traffic for.  Note this log will fill up pretty quick so if you are troubleshooting multiple products communication proxy/web traffic, we suggest creating a separate file for each product’s WebLogic LocationMatch for easier analysis.

Add the appropriate Debug and WLLogFile location parameters using the location you created in the first step above.  The file name and extension of the log itself is arbitrary so we just use a snippet of the WebLogic managed Server we are debugging for in the name with a .log extension. The content being recorded is in plain text.

A very informative (and way to wordy) technical reference guide to these parameters can be found on Oracle’s published documentation website:

https://docs.oracle.com/cd/E28280_01/web.1111/e10144/directives.htm#CIHCACHB

Parameters to add/modify:

Debug ON
WLLogFile C:\MyDebugLogs\OHS-CalcMgr.log

Sample section of one Calculation manager product LocationMatch AFTER adding/updating the required Debug and WLLogFile parameters:

<LocationMatch ^/calcmgr>
    SetHandler weblogic-handler
    WeblogicCluster 11124-PRD:8500
    WLIOTimeoutSecs 14400
    Idempotent OFF
    WLSocketTimeoutSecs 600
    Debug ON
    WLLogFile C:\MyDebugLogs\OHS-CalcMgr.log
</LocationMatch>
7-Edit LocationMatch for mod_wl_ohs conf file
7-Edit LocationMatch for mod_wl_ohs conf file

For the updates to take effect you must restart the oracle HTTP Server (OHS) on each server where you are trying to debug traffic from.  Since we are using Windows, we will use the Windows services.msc control panel and perform a restart of the Oracle Process Manager (ohsInstance####) Windows service:

8-Restart Oracle HTTP Server-OHS from Windows Services
8-Restart Oracle HTTP Server-OHS from Windows Services

To test your Debug and WLLogFile settings log into the product you are experiencing issues with and a new Debug log file should be created in the path and with the name you specified in the LocationMatch section for the WLLogFile section.

9-Open Oracle Hyperion EPM Calculation Manager screen
9-Open Oracle Hyperion EPM Calculation Manager screen
10-WLLogFile Debug file output location for Calculation Manager screen
10-WLLogFile Debug file output location for Calculation Manager screen

If you open and take a look at the WLLogFile Debug output, you will now see any info and error messages being sent from the Oracle HTTP Server (OHS) web traffic proxy to the WebLogic Managed Server (in our example Calculation Manager).

11-WLLogFile Debug file output for Calculation Manager screen
11-WLLogFile Debug file output for Calculation Manager screen

Happy debugging!!!

We hope this Oracle Hyperion EPM System technical blog post/article was helpful and as always, we appreciate any and all feedback!  If you need any assistance, please know we are always here 24×7 and would happy to help with your Infrastructure needs!

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Save The Date!

  • Date: August 14, 2019
  • Article by: Elysha Daly
Microsoft and Oracle have some critical end of life dates quickly approaching.  Any customers running on the platforms listed below should begin to prepare for these upcoming support changes.  Contact us today to discuss how these support policy changes might affect your mission critical Financial Close, Budgeting and Reporting systems.

Microsoft product technology end of life dates:

  • Microsoft Windows 2008 Server – January 2020
  • Microsoft SQL Server 2008 – July 2019
  • Microsoft Office 2010 – October 2020

Read More

Oracle EPM/Hyperion on-premise end of life dates:

  • 11.1.2.3.x – March 2018
  • 11.1.2.4.x – December 2020, extended support can be purchased through December 2021
  • 11.2.x – To be released September 2019,  support end of life date of December 2030 

Read More

Oracle EPM/Hyperion Features Discontinued in 11.1

Hyperion Financial Management

Hyperion Planning

  • Financial Management Analytics
  • Essbase Analytics Link for HFM
  • Quantitative Management and Reporting for Solvency
  • Hyperion Strategic Finance (HSF)
  • Simplified User Interface (SUI)
  • Workforce Planning
  • Capital Expense Planning
  • Project Financial Planning
  • Offline Planning

Hyperion BI +

  • Interactive Reporting (IR)
  • Production Reporting (SQR)
  • Web Analysis (WA)

Additional

  • Disclosure Management
  • EPM Mobile
Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Oracle Hyperion Enterprise Performance Management (EPM) System 11.2: On-Premise isn't dead after all!

  • Date: June 19, 2019
  • Article by: Joe Malewicki

Rumors gossip and software envy for al those “new vendors” claiming that on-premise Hyperion is dead!!!… news flash, Oracle isn’t killing off On-Premise Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 folks!

Here’s a glimpse of what’s to come with the newly announced Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 roadmap! They’re shifting Oracle Hyperion Enterprise Performance Management (EPM) System family of tools and applications under the “Oracle Applications Unlimited” structure and have announcement details on release cycles as well as product support roadmap.

Oracle Application Unlimited Announcement for Oracle Hyperion Enterprise Performance Management (EPM) System 11.2:

https://www.oracle.com/a/ocom/docs/support/hyperion-epm-announcement.pdf

Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 “Continuous Innovation” announcement:

http://www.oracle.com/us/products/applications/applications-unlimited-1970561.pdf

If you have questions about the direction of Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 or if you are interested in discussing how this coming update will impact your organization’s “Path To The Cloud” please let us know! I’ll be happy to chat!!

Joe Malewicki

President – Certified Oracle Cloud Architect, Cloud Infrastructure OCI and Platform Specialist at iArch Solutions, LLC

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

The month of milestones…

  • Date: January 17, 2017
  • Article by: Joe Malewicki

untitled     iArch Solutions is happy to welcome 2017 with lots of exciting news.  January marks the 20th anniversary of Joe Malewicki working within the Oracle EPM/Hyperion software space.  It is this long-standing knowledge that gives clients the confidence, in both Joe and iArch Solutions, to tend to their Hyperion infrastructure architecture needs.  January also marks the 4th anniversary of  iArch Solutions.  Joe Malewicki, Principal owner, took a leap of faith 4 years ago, and has continued to service clients with the utmost knowledge and attention to their needs.  It is this combination of strengths that keeps clients coming back for our work.  As we continue to add the most experienced technical staff year after year, we strive to consistantly provide the best infrastructure services to our current and future clients.
As we previously mentioned, iArch Solutions is very excited to be hosting a booth at this year’s Kscope 17 conference. Well, we recently found out that our founder, Joe Malewicki will also be a presenter at Kscope 17 in June.  We are now less than 6 months away from Kscope 17, and there is lots to do to get ready for our exhibit… we think it will be the best at the conference!  Thinking about heading to San Antonio for the conference, use our discount code IARCH and receive $100 off your registration.
Looking forward to seeing you in June!

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Kscope 17

  • Date: November 22, 2016
  • Article by: Joe Malewicki

untitled
iArch Solutions is proud to announce that we will be an exhibitor at Kscope 17 in San Antonio, Texas (June 2017).
Having presented in year’s past, we are excited to share our ideas at one of the top conferences on Oracle products.  Thinking about attending the conference?  Use our special discount code IARCH and save $100 on the registration!!
Come swing by our booth, check us out and enter yourself a chance in winning one of our great giveaways!  Stay tuned for more updates coming soon.  We look forward to seeing you in Texas!
http://www.kscope17.com/vendors

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Financial Management (HFM) Performance Problems When Using SQL Server Database

  • Date: October 10, 2016
  • Article by: Elysha Daly

Is your Hyperion Financial Management System running “slow?”  That’s good, because now you have a chance to “catch it” and maybe speed it up!!  If you have more than one HFM application server running against a Microsoft SQL Server backend for your database, then please follow these steps to either fix the issue or confirm that this is not causing the issue.
The standard procedure when using Microsoft SQL Server database as a repository for any Oracle Hyperion product is to run the following SQL query for all databases prior to configuring your software:

Set READ_COMMITTED_SNAPSHOT = ON
Set ALLOW_SNAPSHOT_ISOLATION = ON

This pre-requisite requirement can be found in the Oracle Enterprise Performance Management System Installation and Configuration Guide.
However, it has been recently discovered, that this database setting has potential negative performance impact on certain HFM Application tasks, such as consolidations.
Run the following SQL query against all existing HFM databases within your environment(s) to confirm the state of the current database setting.  If your results display a “1” or “on” then please proceed to our offered solution below.

select name, is_read_committed_snapshot_on, snapshot_isolation_state_desc from sys.databases

 
epm_hfm_pics
Solution:
First, confirm that all Oracle EPM Service Software has been stopped.
Second, if possible, perform a restart of the Microsoft SQL Server Windows service to clear any orphaned processes.
Third, perform a cold back up of your HFM database.  ***This is a critical step***
Last, you will run the following SQL query against the HFM database.

alter database <HFM_DB>
set allow_snapshot_isolation off;
alter database <HFM_DB>
set read_committed_snapshot off;

 
In our example we changed the <HFM_DB> within the SQL query to EPM_FM, the name of our Financial Management database.
pic03
Now you can go back and run this query again to confirm the change has taken hold:

select name, is_read_committed_snapshot_on, snapshot_isolation_state_desc from sys.databases

 
Please note the change in the EPM_FM state to “0” and “off.”
pic04
 
When this process is complete, please go ahead and restart your Oracle EPM Service Software.  We always suggest you perform your standard validation to confirm that your environment is still functioning properly.  While there is no guarantee of the amount of performance improvement, through our own testing, we were able to see a client’s Financial Management consolidation process reduced from over 2 hours to approximately 15 minutes.
We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog?  Send us your questions, comments and feedback.
APPLICABLE VERSIONS: 11.1.2.4

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Oracle has released 11.1.2.4 Patch Set Updates!

  • Date: June 24, 2016
  • Article by: Joe Malewicki

Over the last few weeks Oracle has announced the release of three Patch Set Updates for multiple products.  There was one for Oracle Hyperion Calculation Manager 11.1.2.4.006, one for Hyperion Profitability and Cost Management 11.1.2.4.121 and one for Hyperion Essbase 11.1.2.4.010.
iArch Solutions is offering you a FREE, no obligation (yes we said FREE) Patch Analysis of your mission critical Oracle EPM/Hyperion Financial System of software.
So what are you waiting for?  Let’s jump on a quick web conference and we will perform an analysis of your system.  We will let you know which patches are missing and should be considered for application so that your Oracle EPM system is able to be the most stable, secure and best performing environment possible.  You have nothing to lose, so give us a call (203-880-4268) and schedule your free Patch Analysis today!
Check out the link below to see the prerequisites and additional information about theses PSUs.
https://blogs.oracle.com/proactivesupportEPM/entry/psu_essbase_11124010
 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Oracle Smart View Error After Applying Analytic Provider Services (APS) Patch

  • Date: May 4, 2016
  • Article by: Joe Malewicki

After applying Analytics Provider Services Patch Set Update (PSU) 11.1.2.4.006 we can no longer perform an adhoc analysis to an Essbase application.  The following error is thrown inside of Microsoft Excel with the Smart View add-in:
Error:
—————————
Oracle Smart View for Office
—————————
com/essbase/services/olap/grid/EssGGridOption.setOptionSingleMbrPov(Ljava/lang/Boolean;)V
—————————
OK
—————————
Screen Shot of Error:
Pic1
 
To confirm if there is an issue with the Provider Services (APS) patch you can run a test to confirm the version details for the Provider Services JAPI:
http://:13080/aps/Test
The version of Analytic Provider Services should match the JAPI version.  Our test showed a discrepancy:
Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.3.4408
Pic2
This issue is being caused by the ess_japi.jar file being a “Read-Only” file. When the new patch was applied it could not update this file.
 
To correct the issue, use the following procedure:
 
Shut down ALL Oracle EPM/Hyperion services or processes.  If you don’t have a system wide stop/start script, check out our earlier post on creating this such item!  How To Create Microsoft Windows EPM/Hyperion Start and Stop Scripts
Once all services are down, locate and change the file system properties at the EssbaseJavaAPI folder level, right-click and deselect “Read-Only.”
Pic3
De-select “Read-only” and click “Apply.”
Pic4
Click “OK”
Pic5
Click “OK”
Pic6
Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).
Then you want to rollback the Analytic Provider Services (APS) Patch: 11.1.2.4.006:
For example:

opatch.bat rollback -id 22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jdk F:OracleMiddlewarejdk160_35

Type “y” when prompted and press <enter>.
Pic8
Pic9
This would be an appropriate time to go back and confirm that the ess_japi.jar is no longer set to “Read-Only.”  If it is, re-apply the same steps noted above for changing the parent folder and all sub folders/items to be “non-read only.”
Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).
Re-apply the Analytic Provider Services (APS) Patch 11.1.2.4.006:

opatch.bat apply F:OracleMiddlewareEPMSystem11R1OPatch22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jre F:OracleMiddlewarejdk160_35

Pic10
Type “y” and press <enter>.
Pic11
Pic12
Delete all of the contents of the tmp and cache directories for the APS server(s) under the WebLogic Domain.  Do NOT remove the tmp and cache folders themselves, just delete the contents.
Sample locations:

F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0tmp
F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0cache

Restart All Oracle EPM/Hyperion System services.
***NOTE***
The above procedures should be performed on ALL servers which are hosting Analytics Provider Services (APS) within the affected Oracle EPM /Hyperion System environment(s).
Test your Analytics Provider Services (APS) URL again:
http://:13080/aps/Test
The version of Analytic Provider Services should now match the JAPI version.
Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.4.006.003
Pic13
Re-test the Smart View connection and perform an adhoc connection to an Essbase application.  The error should no longer be present and the query should work.
Pic14
 
 
We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog? Send us your questions, comments and feedback.
 
APPLICABLE VERSIONS: 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4
 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Got EPM questions? iArch Solutions has the answers!

  • Date: April 22, 2016
  • Article by: Joe Malewicki

 
Don’t you wish you had a more in-depth understanding of the Oracle EPM/Hyperion System infrastructure?   Have you ever wondered how all of this software actually works under the covers?
Let us guide you in this effort.  iArch Solutions will come to you with our detailed and customized Knowledge Transfer session.  It is our goal to have your IT and Finance Departments on the same page so that your system will continually be a high performing environment.  Some of the topics we will discuss are:

  • Validating your Oracle EPM Hyperion System
  • How to perform baseline tuning
  • Teaching you how to troubleshoot system failures and outages
  • Show you how to safely apply patches to your financial system  environments
  • And much, much more…..

Our experts will empower your team with the confidence and technical knowledge to run your system to it’s fullest ability.
Check out the link below for more information regarding our KT session.  So, what are you waiting for?  Give us a call today for a personalized quote to enhance the knowledge of your staff.
 
Learn more about iArch Solutions Oracle EPM/Hyperion Technical Knowledge Transfer and Infrastructure Training Services
 
iArch Solutions Technical Knowledge Transfer
 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

How To Create Microsoft Windows EPM/Hyperion Start and Stop Scripts

  • Date: March 28, 2016
  • Article by: Elysha Daly

People to tend to think that creating a master start/stop script, which can span multiple servers, is a difficult task.  Some Hyperion consulting firms out there even like to charge for such a beast.  They also try to convince you that you need to purchase their “specialized custom scripts” or “compiled start/stop programs” to do the job.  This just isn’t so!  Remember – anything they charge you for today, they’ll likely want to charge you to modify “tomorrow.”
There’s no secret sauce here folks.  There is no need to go spending your valuable money when all of the tools you need to create your own script are already in place within your Microsoft Windows infrastructure.  In the article below, we will show you step by step how to create your own custom Oracle EPM/Hyperion start/stop scripts which can be easily modified whenever you might need to do so.
Follow these quick and easy steps to create start and stop scripts for your Oracle EPM/Hyperion System running on a Microsoft Windows Operating system today!
On your Foundation Services Server, open/create a new text document using your favorite text editor.   We’re using the built in Notepad application from Widows (Start -> Run -> Notepad.exe).  I often add a few comment lines to the top of my scripts so it is a little easier to know which script I’m working with and what version of software it is for.
Pic1
Save the document by clicking on File and then Save As…
Pic2
Save the script and place it just under the Oracle location in a folder labeled “scripts.”  You can save it wherever you like, but if you place it here, it is less likely to be mistakenly deleted.  Please note that this is being saved as a .txt file.  This will be changed later, but to be safe, it should be saved in this format for now.
Pic3
The first thing to add to your script is a command to start Microsoft Internet Information Services (IIS).  That is, if you are using it for any of the software within your Oracle EPM/Hyperion System deployment.  If you’re not sure if you require this, you can run a Oracle EPM Topology report and check to see if any of the following products are configured:

  • Financial Management (HFM – prior to release 11.1.2.4)
  • Enterprise Performance Management Architect (EPMA)
  • Strategic Finance
  • Financial Data Quality Management (FDQM – not required for Financial Data Enterprise Edition Manager – FDMEE)

For local IIS instances:

iisreset.exe /start

When you need to start IIS on a remote server:

iisreset.exe remote-server-name /start

Pic4
The first part of your start command will contain two items.  First, the  server where your service resides and second, what to do with that service.  Here you are asking it to start.

sc \<your-server-name> <switch>

In the example below, the”sc” stands for Windows Service Control, “Hyperion1” is our test server name and “start” is the action which you wish to perform using the “sc” command.

sc \Hyperion1 start

Pic5
Now, it is necessary to find the “Service Name” of your Oracle EP/Hyperion services in order to use them in your start commands.  Click on the start menu and in ther query box at the bottom type: services.msc and press enter.
Pic6
This will bring up the all the services that are running on this server.  It will not be limited to Hyperion/EPM products.  You will need to locate your services under either Oracle or Hyperion.  This depends on which version of the EPM/Hyperion system you are currently running.
Start by clicking the “Standard” tab at the bottom of the page and then scroll down until you find your services.  This example shows the many different services in this environment.  I will demonstrate the steps needed to finish your first start command.  The process simply repeats for each of these services.
I usually start with the “Oracle Process Manager” and then “Foundation Services.” Generally, in the more recent versions, aside from these two services, the order of starting is not critical.
Pic7
Right click on Oracle Process Manager and select Properties.
Pic8
The information in the Service Name box is what you need to highlight and copy.
Pic9
This is the next component of your start script.  Be sure to add in the double arrows >> to set up the next part of your script.

"OracleProcessManager_ohsInstance4262192120" >>

Pic10
This next part of your script creates a log that will keep the startup information for each command and time you run the script.
For example:

C:OraclescriptsServices_startup.log

Pic11
In this part of the command line you can control how long to wait before allowing the next command to run.  The “10” in “TIMEOUT /T 10” is equal to 10 seconds.  It also puts this information into that same startup.log file.

TIMEOUT /T 10 >> C:OraclescriptsServices_startup.log

Pic12
This is a sample of the second start command.  It is preferable to start Foundation Services second.  Technically speaking, since the release of 11.1.2.3, there is no longer a need for a specific start sequence.  Our experience has shown that starting these two services first reduces occurrence of errors.
Pic13
After copying the Service name from above, paste it into the next start command, as shown in the screen shot below:
Pic14
Once you have completed all your commands for all of your EPM/Hyperion services,  save your work.  Then right click on the file and select “Rename.”
Pic15
Change the .txt file extension to be “.BAT.”  This will convert your text file into a batch file. Click OK.
Pic16
You will now have the ability to run this script.  Please be sure to right click on this file and select “Run as Administrator.”
Pic17
It is now necessary to create a stop script.  You will follow the same steps as before but take notice of the slight changes in the commands.  Now instead of “start” you will use “stop” and you will replace “startup.log” with “shutdown.log.”
The order of processes to be stopped is best when reversed for the stop script.  The exception to this is the IIS stop command.  This can remain in it’s original position.
Pic18
Remember to initially save the document as a text file.
Pic19
Pic20
Then when it is complete, and in place, change it to a batch file.
Pic21
click Yes.
Pic22
As with the start script, it is necessary to run the stop script as an administrator.  Simply right click on the stop script batch file and select “Run as Administrator.”
Pic23
I hope this was an informative and helpful blog for you.  Here is a sample of the start/stop scripts used in this article:

ECHO.
ECHO ------------------Starting Oracle EPM System 11.1.2.4 Services------------------
ECHO.
iisreset.exe /start
sc \Hyperion1 start "OracleProcessManager_ohsInstance3037049148" >> C:OraclescriptsServices_startup.log
TIMEOUT /T 10 >> C:OraclescriptsServices_startup.log
sc \Hyperion1 start "HyS9FoundationServices_Foundation1" >> C:OraclescriptsServices_startup.log
TIMEOUT /T 30 >> C:OraclescriptsServices_startup.log

 

ECHO.
ECHO ------Stopping Oracle EPM System 11.1.2.4 Services-----------
ECHO.
iisreset.exe /stop
sc \Hyperion1 stop "HyS9FoundationServices_Foundation1" >> C:OraclescriptsServices_shutdown.log
TIMEOUT /T 10 >> C:OraclescriptsServices_shutdown.log
sc \Hyperion1 stop "OracleProcessManager_ohsInstance3037049148" >> C:OraclescriptsServices_shutdown.log
TIMEOUT /T 10 >> C:OraclescriptsServices_shutdown.log
Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More