How to migrate EPMA enabled Planning applications from 11.1.2.1 to 11.1.2.4 - Part II

Introduction

During Part I we discussed the general steps. In this post I will go into commonly faced issues and how to address them. Although these issues where experienced by myself, it could very well be others / you will experience different issues.

Do-It-Your-Self Demo - PSKeePass

​Introduction

This post will provide a do-it-your-self demo in order to understand the basics and potential of the PSKeePass PowerShell module. Completion time is about 10 minutes.

What will you learn?

After completing the demo you will have a basic understanding on how to use the module and how it can be applied.

Geek Stuff (Linux) - Show Chmod Numerical Permissions

During Linux installations of EPM, setting and validating the correct security on folders and files can be a challenge. The chmod command is used to set security access, while chown sets the ownership's. As you might now chmod has two modes of reading and applying security access: Symbolic and Octal mode.

Wrong Essbase ARBORPATH?

Today I accidentally created a new EPM 11.1.2.4 Essbase instance with the wrong ARBORPATH. Strangely enough I discovered that the EPM Configuration Tool doesn't allow to change the ARBORPATH. This seems to be the default behavior since EPM 11.1.2.3.

Clarifying Oracle EPM Versioning

Introduction

Even for EPM insiders, Oracle's versioning scheme for Oracle EPM can be confusing. With this post I attempt to shed some light on this matter. This post will assume the latest version of EPM available at the time of writing, which is 11.1.2.4.x. The rumour is that this is the last EPM 11.x version, in 2017 version 12.x is expected. Essbase v12.x has recently been released embedded in the latest version of OBIEE.

Identification of Landscapes Through Workspace Title Bar

Introduction

Most clients have two or more Oracle EPM landscapes. Landscape is e.g. development or production. In some cases clients have 5 landscapes: development, staging, acceptance, production and a disaster recovery environment. During certain processes it is common that administrators have Workspace open from different landscapes. In those cases it might be practical to be able to easily identify on which landscape you are working.

How to migrate EPMA enabled Planning applications from 11.1.2.1 to 11.1.2.4 - Part I

One of the most recent challenges I faced is migrating EPM Architect enabled Planning applications from 11.1.2.1 to 11.1.2.4. Personally I find it hard to get an official approach from Oracle. The only official path seems to be a in-place upgrade. However this is rarely an option, it is unlikely a customer would agree to this for various reasons. Maybe a subject for a different post.

So, what to do? Personally I like to recommend a "test migration" using the customers most critical application. During these test migrations you will have the opportunity to determine the best method to migrate their application(s). In addition this allows you to discover any customer and product issues which you can than resolve and document. When you perform the final migration, you simply follow your own manual and you should be good to go.This will shorten you final migration run time significantly!