Thursday, July 23, 2020

EPM 11.2.2.0 on Linux: Got It Working!



 Initial observations:

  • If you've ever installed EPM 11.1.2.x on Linux before, the installTool.sh process for EPM 11.2.2.0 is identical.
  • You obviously want a VNC client or PuTTY+XMing (unless you're using the VirtualBox console or the like).  If you don't own a license for VNCViewer, look up "TightVNC" on your favorite search engine.  It is open source.
  • Before you dive in and run configtool.sh, stop and run RCU. As I've stated in other posts and in comment replies, in a distributed environment you need to do this on every server except the Essbase server.
  • HFM is grayed out unless you're either installing on Exalytics or Windows.
  • The certification matrix says Red Hat 7 and Oracle Linux 7 are the only certified UNIX platforms for this release; AIX and Solaris are not mentioned.
  • After you run RCU and then configtool.sh, you will need to fix script permissions
  • If you've tried 11.2.0.0, 11.2.1.0 or 11.2.2.0 in Windows, the Linux directory structure is laid out in an identical fashion.  If you haven't tried 11.2.x yet, the directory structure is mostly the same as 11.2.1.x, but there are some minor differences (primarily with Oracle Middleware... user_projects is the same as what you're used to).
  • Financial Reporting's "FRConfig.sh" still shows an incorrect database schema, as do all prior EPM 11.2.x releases.  This is a bug someone will need to report to Oracle.  This bug means you will be forced to use either Workspace->Explore->File->Export or the LCM batch utility rather than LCM to export your reporting repository.  LCM will throw an error for this specific task.
  • Auto-installed patches are the same as 11.2.1.0's, and mostly the same as 11.2.0.0's (minor difference where WebLogic is concerned due to the addition of Chrome and Edge support).  Essbase is still 11.1.2.4.033 and Java is still about 1 year old at 1.8 Update 181.  Once you get the system stable, you'll want to look into applying WebLogic and Java patches from the July 2020 Oracle Critical Patch Update.  You can also patch the Essbase suite up to 11.1.2.4.039 or .040 if you want (as of this writing).
I'll look into writing a more thoughtful post over the weekend if there's anything else worthy of sharing.  Have fun installing!

Why won't EPM 11.2.2 Linux services start?

Why won't EPM 11.2.2 Linux services start using the pre-delivered scripts?

Because the executable permission is missing on some of the scripts after you've finished running configtool.sh

Quick & dirty fix:

cd to your Middleware directory and type

find . -type f -name *.sh -exec chmod u+x {} \;

Problem solved.

Wednesday, July 22, 2020

Confirmed: No HFM in EPM 11.2.2.0 for Linux

Rather than a lengthy post about Hyperion / Oracle EPM 11.2.2.0, how about a screenshot?

























So if you are running a Linux-heavy shop and need HFM, you will need Windows Server 2016 or 2019 in the mix.

July 27, 2020 Update:  an Oracle SVP of Development commented on my LinkedIn post about this topic, and stated HFM for Linux would become available sometime in 2021.  This is great news!