Blog Details Page

  • Date: June 4, 2020
  • Article by: Robert Barrett

I recently took the Oracle Cloud Infrastructure 2019 Architect Associate exam. There was a question about Load Balancers and I only knew half the answer. I went back after the exam to search for the correct answer but had a really hard time finding it in any of the materials I had been using to study. This includes the videos and the transcripts too. Eventually I found the answer. The question I ran into is similar to the one below.

Which two will occur when a back-end server that is registered with a back end set is marked to drain connections?

A. It forcibly closes all connections to that instance after a timeout period.

B. It keeps the connections to that instance open and attempts to complete any in-flight requests.

C. It disallows new connections to that back-end server.

D. It immediately closes all existing connections to that instance.

E. It redirects the requests to a user-defined error page.

The “two” part is what threw me. I knew the first half of the answer was C. It disallows new connections to that back-end server. But had to guess at the second half. Afterwards, I eventually found a website that directed me to this url: https://docs.cloud.oracle.com/en-us/iaas/Content/Balance/Reference/sessionpersistence.htm

At the bottom of the page I did find this excerpt: “The Load Balancing service considers a server marked drain available for existing persisted sessions. New requests that are not part of an existing persisted session are not sent to that server.”

Based on this piece of information I am led to believe that the correct second half to the question is B. It keeps the connections to that instance open and attempts to complete any in-flight requests. Please feel free to respond to this and let me know your thoughts.

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 15, 2020
  • Article by: Robert Barrett

Oracle has great tool to help you evaluate and compare different releases of Hyperion EPM. It covers releases back to 9.3.1 up to its newest release of 11.2.1.0.000. Using this tool, you will be able to see the products that continue to be available and the ones that have been discontinued. For those products that have not been discontinued the report will show what Oracle has done to improve the functionality and user interface of each Product.

If, for example, you were presently on Oracle EPM 11.1.2.3 and wanted to compare it with Oracle EPM 11.2.  Your first step would be to go to https://apexapps.oracle.com/pls/apex/f?p=20620:1:0 . 

A screenshot of a computer

Description automatically generated

It is fairly straight forward from there. Please select your current release. Or the earlier version of the 2 you wish to compare. 

A screenshot of a computer

Description automatically generated

I have chosen 11.1.2.3

A screenshot of a social media post

Description automatically generated

Next choose your Target version. Here I have chosen 11.2

A screenshot of a social media post

Description automatically generated

Now choose the Products you wish to compare. I have chosen to compare Calculation Manager, EPM Architect and Essbase. Then click on “Generate Report.”

A screenshot of a social media post

Description automatically generated

As you can see here it shows all the major changes and improvements that have been made up to the newest release requested.

A screenshot of a computer

Description automatically generated
A screenshot of a social media post

Description automatically generated

If you take a look at EPM Architect, you will see that the last release is shown to be in 11.1.2.4. Meaning that it is no longer available in later releases.

A screenshot of a social media post

Description automatically generated

As a further example, let’s look at Essbase.

A screenshot of a computer

Description automatically generated

I hope this was helpful for you to get a look into your future. Please use this tool as a starting point to help you understand what EPM Products are available in newer releases. Feel free to contact iArch Solutions to answer any of your Hyperion EPM infrastructure and Application questions.

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: October 21, 2016
  • Article by: Robert Barrett

When bad things happen and you have to start troubleshooting, it is important to know what version of software you are using.  Whether you or someone else is doing the work, knowing what version or even the patch level of your system, will be required.  Below we have listed a few programs and how to find their versions.

Microsoft Excel

First, go to your “Start” menu and open your Microsoft Excel program.

 

png1

 

Second, select the “File” tab and  choose “Help.”  You will find the versioning information to the right.

png2

 

If you are using Smart View the information you will need is under the SmartView tab.

First, from Excel select your Smart View tab.

Second, Choose the “Help” option and then go to “About(z)…”

png3

 

The Smart View version will then  be displayed for you.

png4

 

To find your Operating System information go to your “Start” menu and select “Computer.”

png5

 

Second, right click on your “Computer” and choose “Properties.”

png6

 

Here you will find which operating system you are running on as well as your computer’s name and other vital information.

png7

 

In order to see what version your various Hyperion products are at, you will need to log into Workspace.

Second, click on the “Tools” option and choose “About Oracle Enterprise Performance Management System Workspace, Fusion Edition.”

png8

 

Third, select “Show Details.”

png9

 

You will be able to scroll through the various Hyperion products and their given patch levels.

png10

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 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: October 10, 2016
  • Article by: Robert Barrett

Is your Hyperion Financial Management System running “slow?”  That’s good, because now you have a chance to “catch it” and maybe speed it up!!  If you have more than one HFM application server running against a Microsoft SQL Server backend for your database, then please follow these steps to either fix the issue or confirm that this is not causing the issue.

The standard procedure when using Microsoft SQL Server database as a repository for any Oracle Hyperion product is to run the following SQL query for all databases prior to configuring your software:

Set READ_COMMITTED_SNAPSHOT = ON
Set ALLOW_SNAPSHOT_ISOLATION = ON

This pre-requisite requirement can be found in the Oracle Enterprise Performance Management System Installation and Configuration Guide.

However, it has been recently discovered, that this database setting has potential negative performance impact on certain HFM Application tasks, such as consolidations.

Run the following SQL query against all existing HFM databases within your environment(s) to confirm the state of the current database setting.  If your results display a “1” or “on” then please proceed to our offered solution below.

select name, is_read_committed_snapshot_on, snapshot_isolation_state_desc from sys.databases

 

epm_hfm_pics

Solution:

First, confirm that all Oracle EPM Service Software has been stopped.

Second, if possible, perform a restart of the Microsoft SQL Server Windows service to clear any orphaned processes.

Third, perform a cold back up of your HFM database.  ***This is a critical step***

Last, you will run the following SQL query against the HFM database.

alter database <HFM_DB>
set allow_snapshot_isolation off;
alter database <HFM_DB>
set read_committed_snapshot off;

 

In our example we changed the <HFM_DB> within the SQL query to EPM_FM, the name of our Financial Management database.

pic03

Now you can go back and run this query again to confirm the change has taken hold:

select name, is_read_committed_snapshot_on, snapshot_isolation_state_desc from sys.databases

 

Please note the change in the EPM_FM state to “0” and “off.”

pic04

 

When this process is complete, please go ahead and restart your Oracle EPM Service Software.  We always suggest you perform your standard validation to confirm that your environment is still functioning properly.  While there is no guarantee of the amount of performance improvement, through our own testing, we were able to see a client’s Financial Management consolidation process reduced from over 2 hours to approximately 15 minutes.

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

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 16, 2016
  • Article by: Robert Barrett

When recently trying to deploy Essbase Studio, I ran into an issue where it would not create the Windows service because the password for the Windows Services install account contained one or more unacceptable characters.

Here are the steps I performed to work around this issue.

Start by re-launching the Configuration tool on the Essbase server.  This time be sure to choose “Configure Common Settings.”  Then click “Next.”

Pic1a

Deselect the “Run Windows Services as non-local system account” option. Then click “Next.”

Pic1

Now follow through the rest of the process of configuring Essbase Studio.  As you have already tried to configure Essbase Studio once, you will encounter the option to either “Drop and re-create Tables” or “Reuse existing database.”  I would choose to “Reuse the existing database.”  Click “OK” and then “Next.”

Pic2

Now continue with your configuration.  When you have completed the process, if you look at your deployed services, you will find that Essbase Studio has been deployed.  Please note, that it has configured to run as the “local system” account.

Pic3

It is important to go back to you services screen now and change the Essbase Studio settings manually.  So, right click on Essbase Studio and click on “Properties.”

Pic8

Select the “Log on” tab.  Input the correct windows account information and select “Apply.”  When you go back to your services screen, you will find that the Essbase Studio Service is no longer a local system service.  It will now be the windows service account that you previously input.

Pic6

The next step is to run the configuration tool again, this time, only select “Configure Common Settings.”

Pic4

Select to “Run Windows Services as non-local system account.”  Input the right domainusername and Password.  Then click “Next.”

Pic5

And now finish the rest of the steps in the configuration process.

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 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: March 28, 2016
  • Article by: Robert Barrett

People to tend to think that creating a master start/stop script, which can span multiple servers, is a difficult task.  Some Hyperion consulting firms out there even like to charge for such a beast.  They also try to convince you that you need to purchase their “specialized custom scripts” or “compiled start/stop programs” to do the job.  This just isn’t so!  Remember – anything they charge you for today, they’ll likely want to charge you to modify “tomorrow.”

There’s no secret sauce here folks.  There is no need to go spending your valuable money when all of the tools you need to create your own script are already in place within your Microsoft Windows infrastructure.  In the article below, we will show you step by step how to create your own custom Oracle EPM/Hyperion start/stop scripts which can be easily modified whenever you might need to do so.

Follow these quick and easy steps to create start and stop scripts for your Oracle EPM/Hyperion System running on a Microsoft Windows Operating system today!

On your Foundation Services Server, open/create a new text document using your favorite text editor.   We’re using the built in Notepad application from Widows (Start -> Run -> Notepad.exe).  I often add a few comment lines to the top of my scripts so it is a little easier to know which script I’m working with and what version of software it is for.

Pic1

Save the document by clicking on File and then Save As…

Pic2

Save the script and place it just under the Oracle location in a folder labeled “scripts.”  You can save it wherever you like, but if you place it here, it is less likely to be mistakenly deleted.  Please note that this is being saved as a .txt file.  This will be changed later, but to be safe, it should be saved in this format for now.

Pic3

The first thing to add to your script is a command to start Microsoft Internet Information Services (IIS).  That is, if you are using it for any of the software within your Oracle EPM/Hyperion System deployment.  If you’re not sure if you require this, you can run a Oracle EPM Topology report and check to see if any of the following products are configured:

  • Financial Management (HFM – prior to release 11.1.2.4)
  • Enterprise Performance Management Architect (EPMA)
  • Strategic Finance
  • Financial Data Quality Management (FDQM – not required for Financial Data Enterprise Edition Manager – FDMEE)

For local IIS instances:

iisreset.exe /start

When you need to start IIS on a remote server:

iisreset.exe remote-server-name /start

Pic4

The first part of your start command will contain two items.  First, the  server where your service resides and second, what to do with that service.  Here you are asking it to start.

sc \<your-server-name> <switch>

In the example below, the”sc” stands for Windows Service Control, “Hyperion1” is our test server name and “start” is the action which you wish to perform using the “sc” command.

sc \Hyperion1 start

Pic5

Now, it is necessary to find the “Service Name” of your Oracle EP/Hyperion services in order to use them in your start commands.  Click on the start menu and in ther query box at the bottom type: services.msc and press enter.

Pic6

This will bring up the all the services that are running on this server.  It will not be limited to Hyperion/EPM products.  You will need to locate your services under either Oracle or Hyperion.  This depends on which version of the EPM/Hyperion system you are currently running.

Start by clicking the “Standard” tab at the bottom of the page and then scroll down until you find your services.  This example shows the many different services in this environment.  I will demonstrate the steps needed to finish your first start command.  The process simply repeats for each of these services.

I usually start with the “Oracle Process Manager” and then “Foundation Services.” Generally, in the more recent versions, aside from these two services, the order of starting is not critical.

Pic7

Right click on Oracle Process Manager and select Properties.

Pic8

The information in the Service Name box is what you need to highlight and copy.

Pic9

This is the next component of your start script.  Be sure to add in the double arrows >> to set up the next part of your script.

"OracleProcessManager_ohsInstance4262192120" >>

Pic10

This next part of your script creates a log that will keep the startup information for each command and time you run the script.

For example:

C:OraclescriptsServices_startup.log

Pic11

In this part of the command line you can control how long to wait before allowing the next command to run.  The “10” in “TIMEOUT /T 10” is equal to 10 seconds.  It also puts this information into that same startup.log file.

TIMEOUT /T 10 >> C:OraclescriptsServices_startup.log

Pic12

This is a sample of the second start command.  It is preferable to start Foundation Services second.  Technically speaking, since the release of 11.1.2.3, there is no longer a need for a specific start sequence.  Our experience has shown that starting these two services first reduces occurrence of errors.

Pic13

After copying the Service name from above, paste it into the next start command, as shown in the screen shot below:

Pic14

Once you have completed all your commands for all of your EPM/Hyperion services,  save your work.  Then right click on the file and select “Rename.”

Pic15

Change the .txt file extension to be “.BAT.”  This will convert your text file into a batch file. Click OK.

Pic16

You will now have the ability to run this script.  Please be sure to right click on this file and select “Run as Administrator.”

Pic17

It is now necessary to create a stop script.  You will follow the same steps as before but take notice of the slight changes in the commands.  Now instead of “start” you will use “stop” and you will replace “startup.log” with “shutdown.log.”

The order of processes to be stopped is best when reversed for the stop script.  The exception to this is the IIS stop command.  This can remain in it’s original position.

Pic18

Remember to initially save the document as a text file.

Pic19

Pic20

Then when it is complete, and in place, change it to a batch file.

Pic21

click Yes.

Pic22

As with the start script, it is necessary to run the stop script as an administrator.  Simply right click on the stop script batch file and select “Run as Administrator.”

Pic23

I hope this was an informative and helpful blog for you.  Here is a sample of the start/stop scripts used in this article:

ECHO.
ECHO ------------------Starting Oracle EPM System 11.1.2.4 Services------------------
ECHO.
iisreset.exe /start
sc \Hyperion1 start "OracleProcessManager_ohsInstance3037049148" >> C:OraclescriptsServices_startup.log
TIMEOUT /T 10 >> C:OraclescriptsServices_startup.log
sc \Hyperion1 start "HyS9FoundationServices_Foundation1" >> C:OraclescriptsServices_startup.log
TIMEOUT /T 30 >> C:OraclescriptsServices_startup.log

 

ECHO.
ECHO ------Stopping Oracle EPM System 11.1.2.4 Services-----------
ECHO.
iisreset.exe /stop
sc \Hyperion1 stop "HyS9FoundationServices_Foundation1" >> C:OraclescriptsServices_shutdown.log
TIMEOUT /T 10 >> C:OraclescriptsServices_shutdown.log
sc \Hyperion1 stop "OracleProcessManager_ohsInstance3037049148" >> C:OraclescriptsServices_shutdown.log
TIMEOUT /T 10 >> C:OraclescriptsServices_shutdown.log


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: February 29, 2016
  • Article by: Robert Barrett

The Smart View Diagnostic tool is an invaluable piece of your troubleshooting abilities.  It allows the end user the ability to easily gather the necessary technical information to assist in solving difficult Smart View issues which might arise.  Once the information is obtained, it can then be sent to Oracle Technical Support for further analysis and hopefully lead to quick response and solution.

The Smart View Diagnostic Tool is a newer addition to Smart View release 11.1.2.3+ product line.  As each new version of Smart View is released, the abilities of the diagnostics tool often enhanced.  Consult your Smart View product ReadMe for more details on each version’s actual use of this feature.  For this article, we are demonstrating its usage with relate 11.1.2.5.520 Smart View.

You will first need to find and display the Diagnostics tools. To perform this function, once in Smart View, select “options.”  Then under Advanced > Logging, check the box “Show Diagnostic group on Smart View ribbon” and click OK.

Pic1

 

The Diagnostic tools will then be available in the menu ribbon as seen below.

Pic2

 

Your next step will be to left click on the “Start Diagnostics” option in the menu. You will be prompted to restart Office. This is highly recommended by Oracle because it allows for all the actions involved in a particular issue to be recorded from the very beginning. It is better to give them too much information rather than too little. At this point, click OK and restart Office.

Pic3

 

Now, you will see that when you restart Office, the option has changed to “Stop Diagnostics.”

Pic4

You can use the “Take Screenshot” Option at various important points during your session. Simply click “Take Snapshot.” Something to keep in mind when taking snapshots is that it takes a picture of your entire screen not just Smartview itself. Any open applications not pertaining to your issue will be captured.

The next option is “Save Document.” This should be used a few times during the diagnostic process to provide more information about your issue to Oracle. Each time the document is saved it will add a different suffix to the saved file. This prevents overwriting.

The files are saved each time to a current diagnostics session folder (see example below).  This setting can be adjusted within the Smart View options menu:

C:Usersusername.domainAppDataRoamingOracleSmartViewDiagnostics

This is a sample screen capture of the path to the folder and what you might expect to find there.

Pic4b

 

 

When you have successfully demonstrated the issue at hand, you can now create an archive. The Create Archive dialog box will be displayed when you select “Create Archive.”

 

C:UsersepmadminDocumentsSmartView_Diagnostics_2822016

Pic5

 

This is an example of the path and location of the Archived file.

Below is the standard name given to the file by default.

SmartView_Diagnostics_ddmmyyyy.zip

Pic5b

 

This diagnostic zip file is what Oracle wants to see. Make sure to add this file to your Service Request.

There is the ability to clean up your files after sending your information to Oracle. If you still have the diagnostic tool running then you can click “Clear Diagnostics Folder.” This will clear all diagnostic sessions except for the one you are currently running. When you click “Clear Diagnostic Folders” this dialog box will be displayed.

Pic6

By using the “Stop Diagnostics” option and then closing all office applications, you can now restart Smart View. Now open any Office application and use the “Clear Diagnostics Folder” to clear all diagnostic sessions including your most recently opened one.

 

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

 

We at iArch Solutions hope you found this blog helpful.  Is there a question you want answered in a blog?  Send us your questions at info@iarchsolutions.com.

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: February 15, 2016
  • Article by: Robert Barrett

Problem:

My Internet Explorer navigation windows open on top of each other!

The links don’t cascade correctly!

Why do my options open over each other?

I don’t know how to describe this problem!!

When logged into your workspace using Internet Explorer 9 or later, I sometimes encounter a problem where my second window link opens directly over my first. The hardest part of this problem is trying to find the correct term to use to describe this problem and search for a solution.  I did manage to find an answer though.

An example is shown here where my first link is selected by clicking on the File option.

Pic1

This second screen shows that by moving down to the presented options the next set of choices opens directly above the first.

Pic2

 

Solution:

Select the “Tools” option in Internet Explorer.

Then select “Internet Options.”

Pic3

 

 

Under the Security tab select “Custom Level…”

Pic4

Scroll down until you find “Allow Script-initiated windows without size or position constraint”

Pic5

 

Then change it to “Enable” and click “OK.”

Pic6

Click “Yes.”

Pic7

It will be necessary to restart your browser session for the changes to take effect. Once reset your windows will open as below.

Pic9

 

We hope you found this tip helpful.  Here at iArch Solutions, we strive to enable our customers with the knowledge and confidence for a smooth running system.  Should you have any questions, please do not hesitate to give us a call.

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 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: February 1, 2016
  • Article by: Robert Barrett

Ever get the “request timed out” error message and there is not anyone available to help you fix it?  Read below and find a step by step guide on how you can adjust your settings and not slow down your uptime.

ERROR:

Oracle Smart View for Office

The request timed out. Contact your Smart View client system administrator to extend your windows internet explorer time out settings (ReceiveTimeout, KeepAliveTimeout, and ServerInfoTimeout).

image002

Solution:

In order to for SmartView to connect to Analytic Provider Services(APS) it uses Internet Explorer (IE).  Generally IE can have a low default time setting for obtaining the necessary data. It will display the above error message.

Enter Registry settings and increase the time allotted.

  1. Go to “Start” and Select “Run…”

image004

  1. Type “regedit” and select “OK”

image006

3.Navigate to Computer > HKEY_CURRENT_USER > Software > Microsoft > Windows > Current Version > Internet Settings

image008

  1. Select Edit > New > DWORD (32-bit) Value.

image010

  1. Right click on “New Value #1” and change it to “ReceiveTimeout”

image012

image014

  1. Right click on ReceiveTimeout and select “Modify”

image016

  1. Using the Decimal option, please enter “480000.” This corresponds to 480000 milliseconds which is equal to 8 minutes.

 

Newpic

Newpic2

 

 

image022

  1. Follow the same steps to add the parameters “ServerInfoTimeout” and “KeepAliveTimeout”  as well. For the value of the latter two parameters enter “180000.” This Decimal term is equal to 180000 milliseconds or 3 minutes.

image024

9.Close the registry window and restart services.

We hope this step by step process was helpful to you. Should you have any questions on this, or any of our other blogs, please feel free to give us a call. Check back next week with another helpful tip to keep your system stable and ensure maximum uptime.**Please note you might require local administrative privileges to perform these steps.

 

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 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: January 20, 2016
  • Article by: Robert Barrett

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.

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