Sunday, 10 April 2011

Applying EPM 11.1.2.1 maintenance release

I am not here today to announce the release of 11.1.2.1 as I think the news has definitely has been posted enough times now, I’d be extremely shocked if you didn’t know, maybe you have been living in a cave and decided to visit my blog when you first ventured out.

Now with this new release there are more options to move to it, you can upgrade/migrate from previous versions, fresh install or apply the maintenance patch to upgrade 11.1.2 to 11.1.2.1, some of this options I will be covering in future blogs.

This release is also about bug fixes as masses have been addressed, there are a number enhancements and new features in a selection of the products but nothing ground breaking (you may disagree), it looks like planning has a larg share of them.

As in past blogs I have gone through the installation and maintenance patches for previous releases so I thought I might as well share my experience of apply the maintenance release today. The release has only been around for a few days so I apologise if I provide any incorrect information.

The OS the maintenance release is being applied to is windows 2008 x64 SP2.

If you are intending of applying the maintenance release I recommend having a read of the “Installation and Configuration Guide” as it covers important detailed information

Next step is download all the required files, I usually obtain them from Oracle edelivery, the files that are required are covered in the install and config guide, note this release there are seven foundation files and not four, also don’t forget the additional content file.

Once you have all the files then extract them all to the same location (if you have the install files in a folder from the previous release 11.1.2 make sure you extract to a different folder), if you are installing on a distributed environment make sure you extract the necessary files on each machine and take note of information provided in the config guide, for instance
  • On the machine on which you plan to administer the WebLogic Server, you must install all Web applications for all applications you plan to deploy on any machine in the environment. (The WebLogic Administration Server is installed and deployed on the Foundation Services machine.)


There are a number of extra folders at root level in this release.

Now there is a list of prerequisites to be met before installing the Maintenance Release to move from 11.1.2 to 11.1.2.1, here is a summary of the main points.

• You must apply the maintenance release on top of your existing EPM System installation.

• You must apply the maintenance release to all EPM System products in the deployment. You cannot apply the maintenance release to only some products.

• If you are applying the maintenance release to move from EPM System release 11.1.2.0 to EPM System Release 11.1.2.1, or if you are reinstalling EPM System products, you must first stop all the services for EPM System products.

• If you are applying the maintenance release to move from Essbase Release 11.1.2 to Release 11.1.2.1, you must first export linked reporting object information from the 11.1.2 database, and then delete the linked reporting objects. After applying the maintenance release, import the exported linked reporting objects. More information available
here

One more point before starting the installation is to be sure you have more than 5GB spare on the drive where EPM is currently installed, if there is not you will not be able to complete the installation steps.

Once all the prerequisites have been met then start up the installation by executing InstallTool.cmd/sh



A new addition to the start up of the installer is the check whether UAC is enabled, I know this could cause problem with 11.1.2 if it was enabled, if it is enabled in this release a warning will be displayed and the installer will not start up.



There are also a few more prerequisite checks, good news all have been passed.



Nothing new on this screen, displays the current Middleware Home.



Three main options to choose from and this time it is “Apply maintenance release”.



Check that there is a tick in each of the products with “11.1.2.0.0” against them, if there is not then you have not downloaded and extracted all the required files.

Once you click next a list of products to patched will be shown, click next again and the maintenance patching will start up, this is a good point to go and spend time doing something that is actually meaningful in life and then on your return hope the status is all green.



All green, see it wasn’t worth hanging around staring at the screen.

Click the Configure button, when I first installed 11.1.2 the configure button never worked but in this release it actually opened up the configurator.



You have the choice whether to stick with the original instance or create a new one, I have no reason to change this so I kept with the default.



The configurator should have checked all the pending tasks for each product that need configuring, I unchecked everything except foundation as I want to be sure there are no issues with the maintenance release, if there is a problem with foundation there wouldn’t be any point configuring the other products.

Another reason for doing this is I have used a separate Oracle schema for each product database configuration, if you leave everything selected then it wouldn’t give the option to apply to separate schemas.

This is just a personal preference Oracle no doubt recommends to leave all products checked and the choice is yours.

If you choose to only configure foundation then you would have “Configure Web Server” again when you configure the other products, this step should always be done last.

I do notice there is a new option “Setup connection to Oracle BI and Publisher”, it is not checked by default and I am not intending on changing that today.



Keep “connect to a previously configured Shared Services database” selected.



Once again there should be no need to change anything when applying the maintenance patch.



Guess what, kept the defaults, can’t beat just clicking next.



Next one more time for me and then it will configure as I am only configuring foundation



All green again, nice smooth ride up to now.



Right that’s me satisfied, back to the configurator to run through the rest of the pending tasks product by product, remembering to check “Configure Web Server” in foundation as the last step, this may not be necessary as I have already configured the web server but I am not taking any chances.
Instead of selecting uncheck all, I unchecked the products I was not configuring for, this way I knew the product I was configuring had the required tasks checked.

I am not going to paste all the screens because as this is a maintenance release there were no new surprises and the process I followed was to stick with the defaults for each product, it was basically reconfiguring the database and redeploying the web application servers.

What I did notice after installing is the number of services being used by EPMA has now been cut down, originally this is how it looked in 11.1.2



The five non web app related services have been combined into one service called “Hyperion EPMA Server”.



I also noticed after the deployment of the web applications the issue I posted about here has been resolved; the installer’s temporary directory is no longer used.

I went through each product and quickly tested I could access them without problems, understandably this is not a rigourous test but it didn't show up any major issues, I will update this post if I do come across any.



For each planning application I had to log in and upgrade from 11.1.2 to 11.1.2.1

If you are using EPMA then this is taken from the installation readme -
"After the installation and configuration of Enterprise Performance Management Architect 11.1.2.1.000, you must install Enterprise Performance Management Architect patch 11804477"

13 comments:

GiacomoL said...

Haven't seen the FR patch reference, but there is also a patch for EPM Architect mentioned in the main Install Readme.

Just testing out a few things, looks to me like we now need HSS to be actually *started* before we can successfully configure other products. Don't think this was the case in .0 (but it certainly was in previous releases).

John Goodwin said...

Thanks Giacomo,
I have added details about the EPMA patch.
I am not sure about foundation having to be started as I think I had it running after I configured and tested it first.

GiacomoL said...

Yeah, that was a somehow premature comment. Have you set it up all on one box ? I've split it across two, with HFM appserver and R&A services on a different image from Foundation webapp, and they're failing to "register with Shared Services", something I hoped we'd left in the past for good. Time to revert to snapshot...

John Goodwin said...

It was only a single server environment I have not had the time to look at it yet on a distributed set up.

Anonymous said...

John, will you be running a compare of the full install of 11.1.2.1 vs 11.1.2 with any changes in the install and config process? Keep up the great work!

Michael said...

Thanks John!
One question. We have Planning, Essbase, HFM, EPMA, etc installed on a server under 11.1.2.0. In order to upgrade to .1, is it required to download ALL assembly files for the products we use or only the required files? (7 foundation, installer, addt'l comps, etc)

John Goodwin said...

You can download the files that are needed for each product which are detailed in the installation document, personally I would download all the foundation files, installer, additional content and product files.

NathanG said...

Hi John,

I have upgraded from 11.1.2 to 11.1.2.1. My AD connection in HSS is not present. Did the environment you upgraded have AD? If so, was it present post upgrade?

Thanks,

Cyril said...

Hi John,
thanks for the great blog.
I have a little question though... I want to install Essbase alone in another box. First thing, even if I only picked Essbase to install, it's still installing Foundation. When I want to configure it, first it forces me to create a new Oracle instance, which I don't think I need and I don't see any way I can register it to my existing Shared Services. I miss the good old 'Register with Shared Services'... :(
Thanks a lot for your work.
Cyril

John Goodwin said...

Hi Cyril, I suggest you have a read of the installation/configuration documentation there is a section on installing to a distributed environment.

John Goodwin said...

Hi Nathan, sorry it did not have an AD already configured.

Shane said...

Hi John,

I know that this has been out for a while but this is the first time that I am doing a maintenance release. I'm kind of in a jam and would like to know what will happen if "You must apply the maintenance release on top of your existing EPM System installation" was not done and one component was missed?
Actually what had happened was, the component was not unzipped then was overlooked, and the maintenance release was applied. The option is no longer available to apply the release, what can I do at this point? Will it mess up the installation if I just do a new installation of that component?

John Goodwin said...

Hi Shane, it is an interesting question and to be honest it is not something I have encountered. I suppose it depends on the components that were missed as it may be alright just to install them.