Blog Details Page

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

Readers, it is here at last, the long anticipated release of 11.2.2.  With this release the Oracle Development Team has brought LINUX support to the latest, and last, on-premise release of EPM.  

The latest support matrix can be found here:  https://www.oracle.com/a/otn/docs/epm-11-2-x-cert-matrix.xlsx

A quick read through reveals a couple of things.  First, the support for EPM 11.2.2 and LINUX is as follows:

·         Red Hat EL 7 (UL0+)

·         Oracle Linux 7 (UL0+)

Second, the browser support for IE 11.x is still listed, though it should be ending soon, so I’d recommend companies make other plans.

Stay tuned for details about an upgrade-in-place from 11.2.1, as well as thoughts about a build-out of the various LINUX versions.

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: June 22, 2020
  • Article by: Elysha Daly

iArch Solutions is happy to announce that Joe Malewicki, Jr. has been recognized as an Oracle ACE. He was promoted from ACE Associate due to his valuable contributions in the Oracle community.

Joe Malewicki, Jr., who’s been working with Oracle products since 1997, has experience implementing, supporting and training customers on Oracle EPM Hyperion. He has also expanded his expertise into Oracle Cloud Infrastructure by becoming a certified OCI Architect. 

What is the Oracle ACE Program?

The Oracle ACE Program highlights excellence within the global Oracle community by recognizing and rewarding members of the Oracle Technology and Applications communities for their contributions. These individuals are technically proficient and willingly share their knowledge and experiences through presentations, blog posts, articles, social media posts, community forum support and more. The Oracle ACE Program award is given for a one year term.

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

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

Join us on Wednesday, June 24th for another stirring Oracle EPM session presented by Jeff Henkel, Managed Services Practice Lead at iArch Solutions.  The topic for the discussion will be EPM 11.2.1, the latest (and last) on-premise release from Oracle.

Some topics for discussion will be:

  • What’s New in 11.2.1 versus 11.1.2.4
  • Installing and Configuring
  • Migration Consideration
  • Future State Direction

The Webinar will be held Wednesday, June 24th from 12-1PM EST. Join us and bring your questions.  We look forward to hearing from you.

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • 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 Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: June 4, 2020
  • Article by: Robert Barrett

I recently took the Oracle Cloud Infrastructure 2019 Architect Associate exam. There was a question about Load Balancers and I only knew half the answer. I went back after the exam to search for the correct answer but had a really hard time finding it in any of the materials I had been using to study. This includes the videos and the transcripts too. Eventually I found the answer. The question I ran into is similar to the one below.

Which two will occur when a back-end server that is registered with a back end set is marked to drain connections?

A. It forcibly closes all connections to that instance after a timeout period.

B. It keeps the connections to that instance open and attempts to complete any in-flight requests.

C. It disallows new connections to that back-end server.

D. It immediately closes all existing connections to that instance.

E. It redirects the requests to a user-defined error page.

The “two” part is what threw me. I knew the first half of the answer was C. It disallows new connections to that back-end server. But had to guess at the second half. Afterwards, I eventually found a website that directed me to this url: https://docs.cloud.oracle.com/en-us/iaas/Content/Balance/Reference/sessionpersistence.htm

At the bottom of the page I did find this excerpt: “The Load Balancing service considers a server marked drain available for existing persisted sessions. New requests that are not part of an existing persisted session are not sent to that server.”

Based on this piece of information I am led to believe that the correct second half to the question is B. It keeps the connections to that instance open and attempts to complete any in-flight requests. Please feel free to respond to this and let me know your thoughts.

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

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

Oracle EPM 11.2 does not include the Oracle HTTP server (OHS) startup service we are used to seeing in prior version of the product. This requires us to be more hands-on when starting and stopping the EPM environment. Fortunately, if you use a services start/stop script, you can add commands to ensure the OHS processes and prerequisites are on-line before your Hyperion services are started, and to shut down the OHS and WebLogic processes after the Hyperion services are stopped.

The proper sequence for startup is to first bring up the Oracle WebLogic server:

  • Open a Command Prompt
  • Navigate to <MW_HOME>/user_projects/domains/EPMSystem/bin folder
  • Execute ‘startWeblogic.cmd’ (no quotes)
  • You may be prompted for a password, use the same one you provided when configuring the EPM WebLogic portion of your installation
  • Once WebLogic is started, you may then start the OHS component from a command prompt:
  • cd<ORACLE_EPM_INSTANCE>\httpConfig\ohs\bin
  • startComponent ohs_component
  • You may be prompted for a password, use the same one you provided when configuring the EPM WebLogic portion of your installation

Until Enhancement Request Bug 17694797 HOW TO START OHS 12C AS WINDOWS SERVICE has been completed and released, managing your OHS application processes must be a manual or scripted affair.

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

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

Whether you’re a small business owner, a home-gown independent software developer, my middle school aged on trying to make his own Minecraft server, a college student needing a new term paper topic or the CIO of a global fortune 100 enterprise, Oracle has made it simple for you to explore the full feature set of their Gen-2 Cloud Infrastructure offerings.  As is the case with some of those “other” IaaS players, Oracle now offers a new “Always Free Services” tier for anybody and everyone!   To sweeten the pot, depending upon when you sign up, we’ve seen Oracle granting free Oracle Cloud Infrastructure credits to new accounts anywhere from $300-$500 USD ($300 is the standard) – something I haven’t those “other” IaaS providers even come close too offering.  

This little monetary freebie is a great way to check out almost all of the services they offer!  (just don’t forget to turn things off and remove them or like a good taxicab – the meter will keep running!!!).

Let’s get started!!!

Launch a web browser (we find that Chrome works best with Oracle Cloud Infrastructure (OCI) interfaces and enter the URL for Oracle’s Cloud Infrastructure Free Tier Account page.  If the URL below no longer works., simple open your favorite search engine and search for “Oracle Cloud Free Tier” and it should be one of the top few results.

https://www.oracle.com/cloud/free

Oracle cloud free tier searching google.com
Oracle cloud free tier searching google.com
Oracle cloud free tier search results from google.com search
Oracle cloud free tier search results from google.com search

Click either the “Start for free” button or the “Try Oracle Cloud Free Tier” button.  They both bring you to the sign-up screen for new accounts.

Oracle cloud new always free services welcome screen
Oracle cloud new always free services welcome screen

On the “Sign Up for Oracle Cloud” screen you will see the current Always Free Services offers at the top of the page (green box).  Fill in the form fields below.

Select your “Country/Territory” from the dropdown list.

Enter a your valid “Email Address” in the field (notice the green check marks validates the address is acceptable).

Click “Next”

Oracle cloud new always free services screen-create account
Oracle cloud new always free services screen-create account

On the “Enter Account Details” screen you will need to enter your personal or company details.  If you select “Company Use” then the mandatory “Company Name” field will display under the contact details section below.  For purposes of this Oracle Cloud Infrastructure Tutorial Series we will be using the “Personal Use” account.

Fill in the form fields as required:

Cloud Account Name:  

joeociarchitect

(This will become the name of your “Tenancy” name and cannot be changed).

Home Region:

US East (Ashburn) – Always Free Eligible

(Normally select the closet OCI “Region” to the mass of your user base.  This “Home Region” cannot be changed once it is selected and your tenancy has been setup however you can always deploy resources to any OCI Regions which you choose to subscribe too after account creation is complete.  There is no additional cost to subscribe to multiple Regions once your OCI tenancy is setup.

It’s also important to understand which resources are available at which Regions.  Oracle’s “Always Free Services” are only available in specific Regions.  You can find that list of resources per Region here.

First Name:

Joe

Last Name:

OCIArchitect

Address:

PO Box 12345

City:

Monroe

State:

Connecticut

Zip/Postal Code:

06468

Country/Territory:

United States

Mobile Number:

(203) 555-1212

(The Mobile Number must be a valid cell number as it will be used to validate your authenticity for the new account.

Click the “Next: Verify Mobile Number” button.

Screen capture 1 of 2.

Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen

Screen capture 2 of 2.

Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen

Oracle Cloud Infrastructure setup will send a text message to the mobile phone number entered on the previous screen.  You have 2 minutes to enter that code into the “Code:” field and then continue the process.

Code:

<enter your code here>

Click the “Verify Code” button to continue.

Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen

On the “Enter Password” screen there is a long list of password complexity requirements.  Please take note of those requirements and try to come up with a password to meet those requirements.

Password:

************

Confirm password:

************
Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen

Click the “Next: Payment Information” button to continue.

Oracle requires a valid credit card to create the account/tenancy.  There will be no charges to this card upfront HOWEVER make sure you keep on top of your usage.  Once you exceed the free $300 USD comp Oracle Credits, or pass your first 30 days of account access, you may incur charges for Oracle Cloud Infrastructure resources and services.  Just be conscious of your time and usage.  Oracle provides VERY easy tools to see your billing usage within the OCI console.

Click the “Add Credit Card Details” button to continue.

Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen

Enter your valid credit card details and click “Finish” to continue.

Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen

On the “Payment Information” confirmation screen, you should see a confirmation message stating that you provided your credit card details properly and are able to continue.

Check the box next to the “Edit Payment Method” confirmation message stating you agree to the terms and conditions….

Click the “Complete Sign-Up” button to continue.

Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen

After a few minutes your new Oracle Cloud Infrastructure (OCI) tenancy will be setup and a login screen will be displayed. In addition, you will receive and email confirmation from Oracle with your username (no passwords will ever be sent via email).

At this point your new account has been setup! Feel free to login and start playing!!!

Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen
Oracle cloud new always free services screen-create account continued screen

I hope you found this post helpful.  As always any and all feedback is greatly appreciated and if you have further topics to suggest or any questions, please contact us and we’ll be happy to assist!

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More