Oracle Critical Patch Update for July 2021

  • Date: July 21, 2021
  • Article by: Jeff Henkel

Oracle has released the quarterly patch update for July, and this list includes a number of EPM related items.  Here is the full list of July patch items.

First off the list are the usual suspects for WebLogic Server and Java:

For EPM 11.2 customers, the details are as follows:

For EPM 11.1.2.x customers (and thus running WebLogic 10.3.6) the details are as follows:

For Java, there are updates to both Java 7 (supported for EPM 11.1.2.x) and Java 8 (supported for 11.2.x):

The EPM Products have also released a series of patches:

Of the above patches, the only one new to this release is the one for Financial Reporting, which is available only in 11.2.6, though it is reported as an issue in EPM 11.1.2.4.  So, this is probably the first instance of Oracle demonstrating that EPM 11.1.2.x is truly end-of-life and will not be supported past 12/31/2021.  The exact verbiage in the patch is:

As always, if you are in need of assistance with patching, please feel free to reach out to iArch Solutions and we are happy to assist with your patching or upgrade needs.

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

April Snow Brings…Oracle Critical Patch Update

  • Date: April 21, 2021
  • Article by: Jeff Henkel

Well folks, it’s that time of year again.  No, I’m not talking about the snow outside at the end of April.  I’m talking about the Oracle Critical Patch Update for the first quarter of 2021.

As always, full details of the patch can be found right here

For this particular release, there are a couple of items for EPM and the general updates to both Java and WebLogic for security purposes.  For EPM, the focus is on Analytic Provider Services (APS) and Financial Management (HFM).

Analytic Provider Services has a high-rated vulnerability:

HFM has one of lesser concern:

Oracle Fusion Middleware (which includes OHS and WebLogic) contains a number of vulnerabilities:

Patch Availability for any of the issues defined is tracked here.

Analytic Provider Services 11.1.2.4.043 PSU resolves the security concern and the HFM issues is addressed in the new 11.2.x code-line and is not being addressed in EPM 11.1.2.4 (as it’s end-of-premeir support in December 2021).  If the HFM issue is a concern, we recommend upgrading and would be happy to assist in any conversations around that process.

Lastly, Oracle has released the standard Java updates.  Depending on your version, these can be applied to EPM systems, but the 11.1.2.4 and earlier code-lines do not suppore Java 8 or higher.

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Oracle has released 11.1.2.4 Patch Set Updates!

  • Date: June 24, 2016
  • Article by: Joe Malewicki

Over the last few weeks Oracle has announced the release of three Patch Set Updates for multiple products.  There was one for Oracle Hyperion Calculation Manager 11.1.2.4.006, one for Hyperion Profitability and Cost Management 11.1.2.4.121 and one for Hyperion Essbase 11.1.2.4.010.
iArch Solutions is offering you a FREE, no obligation (yes we said FREE) Patch Analysis of your mission critical Oracle EPM/Hyperion Financial System of software.
So what are you waiting for?  Let’s jump on a quick web conference and we will perform an analysis of your system.  We will let you know which patches are missing and should be considered for application so that your Oracle EPM system is able to be the most stable, secure and best performing environment possible.  You have nothing to lose, so give us a call (203-880-4268) and schedule your free Patch Analysis today!
Check out the link below to see the prerequisites and additional information about theses PSUs.
https://blogs.oracle.com/proactivesupportEPM/entry/psu_essbase_11124010
 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Are you scared of Oracle's EPM/Hyperion patches?

  • Date: May 24, 2016
  • Article by: Joe Malewicki

 

  • Have you ever wondered if your Oracle EPM/Hyperion system is patched to date?
  • Did you know that Oracle releases a collection of security fixes for their products called “Critical Patch Updates” on the Tuesday closest to the 17th day of January, April, July and October?
  • Are you aware that Oracle Technical Support has the right to refuse assisting you on an issue if that issue has been addressed in a later Patch Set?
  • When was the last time your system was patched?

 
If these are questions that scare you, then give the experts at iArch Solutions a call.  For a limited time, we are offering you a FREE, no obligation (yes we said FREE) Patch Analysis of your mission critical Oracle EPM/Hyperion Financial System of software.
Let’s jump on a quick web conference and we will perform an analysis of your system.  We will let you know which patches are missing and should be considered for application so that your Oracle EPM system is able to be the most stable, secure and best performing environment possible.
You have nothing to lose, so give us a call (203-880-4268) and schedule your free Patch Analysis today!
 
We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog? Send us your questions, comments and feedback.
 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Oracle Smart View Error After Applying Analytic Provider Services (APS) Patch

  • Date: May 4, 2016
  • Article by: Joe Malewicki

After applying Analytics Provider Services Patch Set Update (PSU) 11.1.2.4.006 we can no longer perform an adhoc analysis to an Essbase application.  The following error is thrown inside of Microsoft Excel with the Smart View add-in:
Error:
—————————
Oracle Smart View for Office
—————————
com/essbase/services/olap/grid/EssGGridOption.setOptionSingleMbrPov(Ljava/lang/Boolean;)V
—————————
OK
—————————
Screen Shot of Error:
Pic1
 
To confirm if there is an issue with the Provider Services (APS) patch you can run a test to confirm the version details for the Provider Services JAPI:
http://:13080/aps/Test
The version of Analytic Provider Services should match the JAPI version.  Our test showed a discrepancy:
Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.3.4408
Pic2
This issue is being caused by the ess_japi.jar file being a “Read-Only” file. When the new patch was applied it could not update this file.
 
To correct the issue, use the following procedure:
 
Shut down ALL Oracle EPM/Hyperion services or processes.  If you don’t have a system wide stop/start script, check out our earlier post on creating this such item!  How To Create Microsoft Windows EPM/Hyperion Start and Stop Scripts
Once all services are down, locate and change the file system properties at the EssbaseJavaAPI folder level, right-click and deselect “Read-Only.”
Pic3
De-select “Read-only” and click “Apply.”
Pic4
Click “OK”
Pic5
Click “OK”
Pic6
Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).
Then you want to rollback the Analytic Provider Services (APS) Patch: 11.1.2.4.006:
For example:

opatch.bat rollback -id 22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jdk F:OracleMiddlewarejdk160_35

Type “y” when prompted and press <enter>.
Pic8
Pic9
This would be an appropriate time to go back and confirm that the ess_japi.jar is no longer set to “Read-Only.”  If it is, re-apply the same steps noted above for changing the parent folder and all sub folders/items to be “non-read only.”
Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).
Re-apply the Analytic Provider Services (APS) Patch 11.1.2.4.006:

opatch.bat apply F:OracleMiddlewareEPMSystem11R1OPatch22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jre F:OracleMiddlewarejdk160_35

Pic10
Type “y” and press <enter>.
Pic11
Pic12
Delete all of the contents of the tmp and cache directories for the APS server(s) under the WebLogic Domain.  Do NOT remove the tmp and cache folders themselves, just delete the contents.
Sample locations:

F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0tmp
F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0cache

Restart All Oracle EPM/Hyperion System services.
***NOTE***
The above procedures should be performed on ALL servers which are hosting Analytics Provider Services (APS) within the affected Oracle EPM /Hyperion System environment(s).
Test your Analytics Provider Services (APS) URL again:
http://:13080/aps/Test
The version of Analytic Provider Services should now match the JAPI version.
Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.4.006.003
Pic13
Re-test the Smart View connection and perform an adhoc connection to an Essbase application.  The error should no longer be present and the query should work.
Pic14
 
 
We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog? Send us your questions, comments and feedback.
 
APPLICABLE VERSIONS: 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4
 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Time for some Hyperion Spring Cleaning?

  • Date: March 22, 2016
  • Article by: Joe Malewicki

 
Well the first day of Spring has come and that means one thing, time for Spring cleaning!
Not only do we need to do this in our personal lives, but professional too.  Now is the time to take a good look at your Hyperion Infrastructure and see if there are some potential problems brewing or maybe a way to get a little more gusto out of your Oracle EPM System technical investment.
Give the experts at iArch Solutions a call to schedule your detailed assessment and ensure you are working on the most stable and secure environment.  Check out the link below to see how comprehensive of an assessment we provide our clients.
 
Learn more about iArch Solutions Hyperion Technical Infrastructure Assessment and Environment Reviews Services
 
iArch Solutions Hyperion Technical Assessment
 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

2016 – The year of the Oracle EPM/Hyperion Upgrade!

  • Date: March 7, 2016
  • Article by: Joe Malewicki

 
2016 appears to be the year of the Upgrade!  There has been a common theme to many of the calls coming into iArch Solutions these past several months;

  • How do I upgrade?
  • How soon can you do it?
  • How much will this cost me?

Is your system running on the latest Oracle EPM software release 11.1.2.4?  Corporations no longer need to rely on long term application and/or functional consulting engagements to perform an upgrade of their Hyperion system.  Leveraging a technical services firm for your software upgrade can prove to be a much more efficient option and lead to a huge savings in project costs.
Why do you need an upgrade?

  • Microsoft is ending support for older operating systems and web browsers.
  • Oracle’s lifetime support policy for releases.
  • Hardware warranty expiration.
  • Increase your system’s overall performance and stability.

At iArch Solutions, we are your technical UPGRADE experts, it’s what we do.  So, now that we have your attention, what are you waiting for?  Call our experts to discuss how we can help you upgrade today.
 

Learn more about iArch Solutions Installation and Upgrade Services

iArch Solutions Installation and Upgrades
 
 
 
 
 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Is your Oracle Hyperion Essbase patched to date?

  • Date: February 22, 2016
  • Article by: Joe Malewicki

Did you hear the news?  Our good friend Tanya over at Oracle recently updated the Oracle Proactive Support Blog with the news that the Hyperion Product Management team has released a new Patch Set Update (PSU) for Oracle Hyperion Essbase 11.1.2.4.x.
Looking for someone to patch your system?  The infrastructure experts at iArch Solutions are your answer.  Contact us today to plan your patching services.
Patch Set Update for Oracle Hyperion Essbase 11.1.2.4.007
 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Your path to your OPatch inventory

  • Date: January 20, 2016
  • Article by: Elysha Daly

Ever wonder what patches have already been applied to a given server or Oracle EPM/Hyperion environment? The opatch.bat lsinventory command is a good place to start to answer this question. Newer versions of the Oracle EPM System may not require any switches in order to run the OPatch lsinventory command, but in older versions they are likely needed.
How to run the opatch.bat lsinventory command for Oracle Hyperion EPM 11.1.2.x.
Location:
Where to run this command from is very important. If you are looking for the patch inventory for the EPMSystem11R1, then you need to run your lsinventory command from that location. The same holds true if you are looking for the inventory of oracle_common, ODI, etc., you must run the commands from these specific locations.
Here are some common OPatch locations included with the EPM System of software:
D:\Oracle\Middleware\EPMSystem11R1\OPatch
D:\Oracle\Middleware\oracle_common\OPatch
D:\Oracle\Middleware\ODI\OPatch
Changing to the OPatch location:
Open a command prompt and select the drive and path to your EPMSystem11R1OPatch location.
Enter the D: and press <enter>. This will bring you to the particular drive needed for this example. It could be a different drive depending upon the environment.
Then enter cd and the path to OPatch under EPMSystem11R1 which in this example is OracleMiddlewareEPMSystem11R1OPatch.
The full command would look like this:
D:>cd Oracle\Middleware\EPMSystem11R1\OPatch <enter>
Pic1
Command:
The next step in the process is to run the correct command to obtain the patch inventory. In this example we are using “opatch.bat lsinventory” as the command.
In some older versions of the EPM System we need to add the location of the Oracle Home (oh) as well as the Java Runtime Environment (JRE) as shown in the example below. The –oh and –jre are referred to as switches or parameters.
Example 1 – Output to screen:
This command is run as a single line.
opatch.bat lsinventory –oh D:\Oracle\Middleware\EPMSystem11R1 –jre D:\Oracle\Middleware\jdk160_29
Pic2
Output:
Pic3
Below is the actual text output displayed on the screen:
D:\Oracle\Middleware\EPMSystem11R1\OPatch>opatch.bat lsinventory -oh D:\Oracle\M
iddleware\EPMSystem11R1 -jre D:\Oracle\Middleware\jdk160_29
Oracle Interim Patch Installer version 11.1.0.10.2
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home       : D:\Oracle\Middleware\EPMSystem11R1
Central Inventory : C:\Program Files\OracleInventory
from           : n/a
OPatch version   : 11.1.0.10.2
OUI version       : 11.1.0.9.0
Log file location : D:\Oracle\Middleware\EPMSystem11R1\cfgtool\logs\opatch\opatch
2016-01-18_14-14-46PM_1.log
OPatch detects the Middleware Home as "D:\Oracle\Middleware"
Lsinventory Output file location : D:\Oracle\Middleware\EPMSystem11R1\cfgtoollog
sopatchlsinvlsinventory2016-01-18_14-14-46PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle EPM System                                                   11.1.2.2.0
There are 1 products installed in this Oracle Home.
Interim patches (11) :
Patch 18148673     : applied on Sun Jul 06 12:20:16 CDT 2014
Unique Patch ID: 17567911
Created on 7 Apr 2014, 13:44:33 hrs
Bugs fixed:
18148673, 17277747, 17608114, 16171585, 14763959, 14400519, 17075142
Patch 17595825     : applied on Sun Jul 06 12:19:12 CDT 2014
Unique Patch ID: 17567956
Created on 9 Apr 2014, 04:21:50 hrs
Bugs fixed:
14400509, 17595825, 16171581, 17277761, 14764021
Patch 18148649     : applied on Sun Jul 06 12:18:50 CDT 2014
Unique Patch ID: 17567922
Created on 8 Apr 2014, 01:43:59 hrs
Bugs fixed:
14400504, 14763943, 17277713, 17595830, 16171607, 18148649

--------------------------------------------------------------------------------
OPatch succeeded.
D:\Oracle\Middleware\EPMSystem11R1\OPatch>
Example 2 – Output to Text file:
In this example a path has been provided to store the output. It can be located anywhere that is convenient. It is helpful to create it as a text file by adding .txt as the extension.
This command is run as a single line.
opatch lsinventory –oh D:\Oracle\Middleware\EPMSystem11R1 –jre D:\Oracle\Middleware\jdk160_29 > D:\Oracle\LSinventoryEPMSYS_Date.txt
Pic4
Output:
Pic5
Contents of the text file:
Pic6
These examples will help you to review the patches that have been applied to your particular Oracle EPM Environment. Also by creating a text document you will be able to upload the information for Service Requests. Remember, you need to know what version of Oracle EPM System you are working with, the drive, and the location of the patches you are trying to inventory. This information will make it easier to input the correct command to get the required output.

APPLICABLE VERSIONS: 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More