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 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
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 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

Blog Details Page

  • Date: May 26, 2020
  • Article by: Joe Malewicki

SSH Key Pairs are required by most Cloud Infrastructure (Infrastructure as a Service) providers for use in authenticating the root or admin level users for various UNIX or Linux compute instances and compute shapes as well as for other IaaS provider management systems (i.e. Amazon Web Services – AWS LightSail, Oracle Cloud Infrastructure – OCI console access, etc…)  The procedures below will walk you through creating your own SSH Key Pair using a Mac OS X operating system.

Launch the terminal.app

macOS Catalina Terminal app located within the "Utilities" folder.
macOS Catalina Terminal app located within the “Utilities” folder.

***NOTE***

Backup any existing SSH Key Pairs you might want to save or ensure the target directory/folder is unique from the default location on the Mac ( /home/.ssh)

Run the ssh-keygen command at your shell and answer the prompts.  It will run interactively by default (prompting you for the appropriate information as needed).  The name of the Key Pair we are using for this tutorial is RSA-KEY and will be located under the directory /tmp/oci-stuff/.ssh

ssh-keygen
/tmp/oci-stuff/.ssh/RSA-KEY
***
***
ssh-keygen command on macOS Catalina with interactive prompts
ssh-keygen command on macOS Catalina with interactive prompts

Optionally you can enter all of the details in a single command line.  There are several parameters required at a minimum.  -t <key type>, -N <passphrase>, -b <number of bits in key>, -C <key name>, and -f <filename>

For Example:

ssh-keygen -t rsa -N “yourPassphraseGoesHere” -b 2048 -C “RSA-KEY” -f /tmp/oci-stuff/.ssh/RSA-KEY
ssh-keygen command on macOS Catalina with single command line
ssh-keygen command on macOS Catalina with single command line

Once the SSH Key Pair has been created, do a quick sanity check of it’s contents:

cat /tmp/oci-stuff/.ssh/RSA-KEY.pub
macOS Catalina results of generating a SSH Key Pair using ssh-keygen
macOS Catalina results of generating a SSH Key Pair using ssh-keygen

This completes the process to generate an SSH Key Pair on the Mac OS X for use with various Cloud Infrastructure providers such as Oracle Cloud Infrastructure, Amazon Web Services, Google Cloud, etc..

PLEASE NOTE:

It’s important to keep this SSH Key pair safe including noting the path it’s stored in and also if you opted to include a passphrase, that should also be recorded safely.  The passphrase cannot be recovered if lost! 

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

Blog Details Page

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

Sometimes the simple becomes complex, and you spend more time fixing the little things than expected.  Recently, a client was changing domain names in an 11.1.2.x environment, and issues were encountered with Reporting and Analysis Framework.  This issue will not pop-up in the new 11.2 versions, since Framework has gone the way of the Dodo.  But there are a LOT of clients still on earlier releases, and so this one is probably of some interest.

The EPM toolkit provides a couple of ways to update host values.  In particular, the EPMsys_Registry.bat application offers triggers to update both the hostname, and individual parameter values.  While it can be involved (since the update host change does not seem to update any localhost_name values), the process is straight-forward and well documented by Oracle.

Where an issue was encountered was in updating the V8 tables under Reporting and Analysis.  These values are set during the initial configuration of the system, and they are locked by various table/DB constraints, so editing them in SQL Plus or the Microsoft SQL Management Console is not easy.  Also, a re-configuration prior to the steps below did not update the domain/host values listed in the tables.

Instead, the process to update them requires deleting values in the Shared Services database, and then the BI/RA database.  In both cases, it is recommended that the contents be backed-up before proceeding with any changes.  

Once you have the backups in hand, you can follow the process below:

  1. Backup the RM1 folder (this is the file structure for Reporting and Analysis)
  2. Stop all services and run following two SQL statements against EPM registry database and RA/BIPLUS database

Execute the following statement against the EPM Registry (Shared Services/Foundation) DB/schema:

delete b from hss_component_property_values b where b.component_id in (select a.component_id from hss_component a where a.component_type_id in(49, 50,51,52,53,54,55,56,68))

Execute the following statement against the EPM Registry (Shared Services/Foundation) DB/schema:

delete a from hss_component as a where a.component_type_id in(49, 50,51,52,53,54,55,56,68) 

Execute the following statements against RA/BIPLUS DB/schema:

delete from v8_sa_props

delete from v8_serviceagent

delete from v8_host

Re-run the EPM configuration on hosts running the raframework agents, and select the following tasks:

  • Configure Database (note: select to reuse the tables instead of dropping and recreating)
  • Configure Framework Services
  • Configure Reporting and Analysis Services

Once the above is complete, you will now be able to start the various RA Framework services and successfully explore and execute reports.

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: May 13, 2020
  • Article by: Joe Malewicki

Updated for 2020 with current insight and enterprise technology trending, please join our President and Certified Cloud Architect Joe Malewicki as he cracks open his award winning presentation “Find Your Path To The Cloud: Encore”. Joe will share more real world experiences and best practices to help you and your organization start (or improve) your journey to the cloud. 

Migrating to cloud may seem like an overwhelming task, but if you want to stay with your current on-premises software, you can still take the first step towards the cloud with an Infrastructure as a Service (IaaS) solution. With this option, it’s like you are getting a new stadium to compete in, but you’re keeping the same high-performing team. 

We will go over the different cloud offerings and if upgrading your software in the process can also benefit your team now or in the long run. We will discuss just how cost effective an on-premise migration to a cloud infrastructure (IaaS) solution can actually be. The cost and time savings alone might make you head back to the office and start planning the project today. If you’re ready to move to the cloud and migrate off of your on-premise software, then a Software as a Service (SaaS) solution might be for you. You can get the cutting-edge products with no hardware costs involved. 

We’ll discuss the various options during this presentation and also look at a hybrid approach of starting with IaaS and then moving to SaaS as you bring on new technologies or sunset existing legacy systems. 

Please join us for this educational and informative session and let’s get you up to where you should be today! And remember—one person’s “cloud” is just someone else’s “computer.”

The Webinar will be held Wednesday, May 27th from 12-1PM EST.

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: May 8, 2020
  • Article by: Joe Malewicki

Taking regular backups of a Development Oracle EPM environment is a task many companies neglect to perform, yet is a critical step towards insuring the investment in time and money an EPM implementation requires. In a new Hyperion environment, we assume server and relational database backups are being taken, however we do find businesses in which Development servers are not regularly backed up, as they are deemed to be non-essential by the IT portion of the business. Failure of these servers would mean losing not just the Development data, but the Oracle EPM infrastructure would have to be re-built as well! At later stages of the Oracle EPM application creation and deployment process, the assumption that Development is not critical may be true – you have copies of applications, data and objects in Production, QA or Stage you may recover from. However, the early development stages of Oracle EPM applications can be the most costly in terms of consultant time and dollars. Perhaps Production is not yet built, or there may be a new application that is not yet ready for promotion to the Stage environment.  A loss of Development data in this case would mean a substantial set-back for the team. 

There will be two types of backups discussed in this article: external storage and local storage. External storage is defined as a backup that is taken by a 3rd party such as a NetBackup group, that is stored outside of the Oracle EPM server environment. Often, operating system backups are regularly scheduled but exclude the application disk drives. Generally, the Oracle EPM application/infrastructure groups are not in control of these backups directly, but may give directions regarding what to include and exclude from these regularly-scheduled backups.

Local storage is defined as those stored backups that the Oracle EPM application/infrastructure teams create themselves, and are normally located on one or more servers within the Oracle EPM environment. The Oracle EPM team is able to schedule or run these backups at will, and has control over what is backed up and where those backups will be moved to within the Oracle EPM server environment. These backups include exports of Reports, Level0 exports of Essbase, LCM extracts of security, among others. 

iArch Solutions strongly recommends both external and local storage backups be implemented in all environments, including the Development environment, as a critical safety net to keep your investment in Oracle EPM applications safe.

The most common backup sequence looks like this:

  1. Local storage backups are taken by the Hyperion apps/infrastructure team – Essbase Level0 backups are taken while the apps are running, and stored in another local folder. Essbase is then taken down and the remainder of the Essbase-specific files are copied to the same local folder as the Level0 backups. Essbase is then restarted.
  2. Essbase backup files are zipped and moved to a location on another server for safekeeping. This location may be in the same environment or in a different datacenter, depending on the needs of the business.
  3. A weekly full backup, or a daily incremental/differential backup is taken of the Essbase local backup directory, as well as the Essbase /app/epm/Oracle filesystem, with the exclusion of the Essbase /app and /bin directories.

After this procedure completes, there will be three locations from which to retrieve Essbase application backups (local storage, the remote server, and external storage) that are no older than 24 hours. With the current scripts we would have yesterday’s backup, as well as the backup taken the day before that. Should one need Essbase application files from a date prior to those stored by local storage backups, they are available via the external storage backups.

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: May 1, 2020
  • Article by: Joe Malewicki

So now that Oracle EPM 11.2.1 has been out for a while, most folks who were eagerly awaiting it have probably installed it, or at least installed components of it.  There are a lot of tips and tricks swirling throughout the interwebs, and I thought I’d add my own take.  

So, I decided to do a couple things different from my usual approach.  First, I decided to build my environments in increments, and actually start small.   Usually with these new versions I go for a big complex initial build and force myself to deal with the fallout.  

But this time I decided on a minimalist approach with a small cloud server for the Oracle DB and EPM suite.  I opted for Microsoft Azure, and while I had the option of using SQL Server 2016, I thought it might be too easy and I wanted a challenge.

For server sizing I opted for 4 VCPUs and 32 GB of RAM.  I was a little skeptical about the amount of RAM but figured I could always detune some of the JVMs or not start some of the services…it was just a lab build after all.

So, after provisioning my Windows 2019 image and getting connected, I installed Oracle DB and got things moving.  Following the install documentation, most things worked ‘as expected’.  The exception to this came with the RCU (Repository Creation Utility).  The RCU builds out the schemas that support the Java applications and requires SYS/SYSDBA credentials.

Filling in the basic information and clicking next, Oracle runs some basic pre-requisite checks when the following message was delivered:

  • RCU-6080:Global prerequisite check failed – The selected Oracle database is a multitenant container database (CDB).

I initially had no idea what this message meant, but some research led me to understand that when installing Oracle 12c, the database server now functions slightly differently than the last time I’d installed it (11g).  

Previously when you installed Oracle DB, one simply used the install specified database and then created tablespaces and schemas.  Once that bit was done, you took those schemas and told the various EPM components which one to use.  As it turns out, now we have multi-tenancy, and the RCU was not happy about it.

Resolving this error was interesting, but relatively simple.  When the Oracle DB Server is installed, it creates the CDB (Container Database), and prior to 12c all Oracle databases were non-CDBs.  However, the installer also offers to create a PDB (Pluggable Database)…and what is that you ask?

  • A PDB is a user-created entity that contains the data and code required for a specific set of features. For example, a PDB can support a specific application, such as a human resources or sales application.

Based on the above, I found that you can locate your PDB with the command:

  • select name from v$services;
    • This should list your Oracle databases and you can note the name of pdb one for future reference, as this is what you’ll feed to the RCU

I also found out that even having the correct DB was not enough, you also need to make it writable with the following command:

  • alter pluggable database all open;

With both of these complete, I could now run the RCU successfully (following the rest of the Install Guide directions).  

Of course, there was still more fun to be had when it came to updating the RCUSchema.properties file, but that’s a tale for our next installment.

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