Upgrade Hyperion to 11.2.6

Michael Fredericks Michael Fredericks

Michael Fredericks

FinWeb Solutions Inc.

发布日期: 2021年11月2日
+ 关注

We recently just did an upgrade from 11.2.2 to 11.2.6 and wanted to discuss the experience and gotchas with this.

As per the Oracle documentation in order to upgrade to 11.2.6 from 11.2.2, you must do the interim step of upgrading to 11.2.4 first.

I can say that the process of going to 11.2.2 to 11.2.4 was pretty straight forward. Here is a summary of what was done. The environment was Windows 2019 server and SQL 2016 Server. In our upgrade we did 11.2.4 first, configured and deployed, started services and tested.

PLEASE NOTE: You do not have to do the above. You can just install the 11.2.4 files over 11.2.2 and then install the 11.2.6 files.

Our 11.2.4 Process

  • Stop All Hyperion Services
  • Backup All Server
  • After unzipping the installation folder, launch the InstallTool.cmd
  • Select Apply Update for Installation Type
  • Run through the Installer. It should find the products currently installed and update those products only.
  • Launch the Configuration Utility via

From the?Start?menu, select?Oracle EPM System, and then?EPM System Configurator (all instances). If you select this method make sure you put the correct information such as EpmSystem1, etc

Change to?EPM_ORACLE_HOME/common/config/version_number?and then launch?configtool.bat.

  1. Expand Financial Management and then select Configure Application sServer and Upgrade Applications.
  2. For FDQM select Deploy to Application Server
  3. I select Deploy to Application Server for all the products that need upgrade.
  4. Run the Configure Web Server

  • Start Weblogic, Start Node Manager, Start Hyperion Services, Start OHS
  • TEST

After the above was working we moved onto to the 11.2.6 upgrade. The steps here are a little more involved. Please make sure you follow the steps.

  1. Enable Long Path support on every EPM Windows server, details available here:?

The registry key Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem\LongPathsEnabled (Type: REG_DWORD) must exist and be set to 1.

Registry script:

Windows Registry Editor Version 5.00?

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem]

领英推荐

  • "LongPathsEnabled"=dword:00000001

Once Long File Paths are enabled do the following: Delete all except the following folders below. Also MAKE SURE TO TAKE A COPY OF THE .ORACLE.PRODUCTS file

Dbclient32

Dbclient64

EpmSystem11R1

user_projects

Then follow the same steps as with 11.2.4

  • Backup All Server
  • After unzipping the installation folder, launch the InstallTool.cmd
  • Select Apply Update for Installation Type
  • Run through the Installer. It should find the products currently installed and update those products only.
  • NOTE: MAKE SURE TO DO THIS
  • During the install of 11.2.6 it deletes the .Oracle.Products file. Restore the file from the copy you took.
  • Launch the Configuration Utility and make sure to Deploy to Application Server
  • Run the Configure Web Server
  • For FDMEE, if you are upgrading from 11.2.4 Please run the ua.bat utility to update FDMEE. The steps are listed here
  • Update FDMEE to 11.2.6
  • Start Weblogic, Start Node Manager, Start Services, Start OHS
  • Test


So there you have it in a condensed version of the process to upgrade to 11.2.6. Please remember to take a copy of the .Oracle.Products file and to enable Long File Paths.

We found out that when the .Oracle.Products file wasn't there or update, we encountered configuration issues with FDMEE.

Any questions please feel free to reach out to you.

Thank you for reading.




Rohith Dasari

Database Engineer at Uber

3 年

You mentioned, "We encountered configuration issues with FDMEE." What kind of issues and how did you resolve them? "UPGAST-00224: The specified database does not contain any schemas for Oracle Data Integrator or the database user lacks privilege to view the schemas. Cause: The database you have specified does not contain any schemas registered as belonging to the component you are upgrading, or else the current database user lacks privilege to query the contents of the schema version registry. Action: Verify that the database contains schema entries in schema version registry.?If it does not, specify a different database.?Verify that the user has DBA privilege. Connect to the database as DBA." Have you faced this issue?

赞
回复
Amit Shah

Director | EPM & Analytics | Consulting | EY

3 年

Any update on 11.2.7 stability? Any major issue reported? 11.2.6 performance issue is there in 11.2.7?

赞
回复
Vishal Solomon

EPM Senior Consultant || Managed Service Manager

3 年

We are upgrading to 11.2.6 as well however we have a huge impact in our existing process. We are using Generic jobs scheduled in workspace on 11.1.2.4 which is now removed in 11.2.6.

赞
回复
Patrick Ratnaraja ACMA,CISA,CRISC

3 年

11.2.7 is out. Have you checked?

赞
回复
查看更多评论

要查看或添加评论，请登录

Michael Fredericks的更多文章

  • Starting Up Your HFM Application
    2024年6月19日

    Starting Up Your HFM Application

    One of the most frequent questions I get with on-premise HFM is why does it take a little to login or for the HFM…

  • Customize Your EPM Workspace Page
    2024年4月1日

    Customize Your EPM Workspace Page

    Do you have more than one on-premise Hyperion environment? For example, do you have a test and production environment?…

  • Hyperion 11.2.15
    2023年12月7日

    Hyperion 11.2.15

    I know I am late to the game of publishing an article on the Hyperion 11.2.

    13 条评论
  • How to Maintain Smartview Updates
    2023年3月31日

    How to Maintain Smartview Updates

    It's been a while since I published but now I am back with another tip for those using "On Premise Hyperion. Oracle…

  • FDMEE Migration to 11.2.X
    2021年5月3日

    FDMEE Migration to 11.2.X

    If you are upgrading to Hyperion 11.2.

    5 条评论
  • New Timeout Setting Feature with Smartview
    2021年2月11日

    New Timeout Setting Feature with Smartview

    In the earlier versions of Smartview, you had to manually set the timeout settings in the registry. These timeout…

    7 条评论
  • Hyperion 11.2.X with Windows Firewall
    2021年1月21日

    Hyperion 11.2.X with Windows Firewall

    If you are deploying Hyperion 11.2X and want to have Windows Firewall running, you will need to create inbound and…

    1 条评论
  • How to Migrate FDMEE to 11.2.2 or 11.2.3 with SQL Server
    2020年10月19日

    How to Migrate FDMEE to 11.2.2 or 11.2.3 with SQL Server

    If you are upgrading FDMEE from 11.1.

    2 条评论
  • HFM Sample Apps in 11.2.X
    2020年7月28日

    HFM Sample Apps in 11.2.X

    In my quest to keep up with Dave Shay and Joe Malewicki's 11.2.

    1 条评论
  • Hyperion 11.2.1 with Chrome or Edge.....Hold Off
    2020年7月22日

    Hyperion 11.2.1 with Chrome or Edge.....Hold Off

    One of the benefits that is touted with Hyperion 11.2.

    9 条评论

社区洞察

其他会员也浏览了