Blog Details Page

  • Date: January 25, 2016
  • Article by: Joe Malewicki

iArch Solutions is proud to welcome Alyssa Scalia to the family.  As our most recent hire, we have brought Alyssa on-board as our Director of Operations.  Alyssa’s appointment will allow iArch Solutions to expand our knowledge and expertise in the infrastructure services industry and enable iArch Solutions to develop better quality of service to our expanding client base.

Alyssa comes to iArch with experience in the Finance and Legal industries having worked to develop stronger customer bases and client relationships. Through her professional career, Alyssa has worked for a multi-national hedge fund administrator overseas and was a Controller for a large domestic printing company.  More recently her time spent at a prestigious law firm allowed Alyssa to fine tune her expertise in office and project management.  The combination of her extensive finance background, amazing communication and project management experience and her strong organizational skills proves to be a perfect combination for our growing needs.  Alyssa graduated from St. Anselm College with a Bachelor of Science in Business.

Away from the office, Alyssa is actively involved in her community serving as President of her school’s PTO and as Director of the Egerton, Inc. Monroe 5K Trail Run/Walk supporting a local non-profit organization to help pay heating costs for local families in need.

When not in the office or volunteering, you can usually find Alyssa in a hockey rink watching one of her three sons play competitive hockey all over New England.

Welcome aboard Alyssa and we look forward to many years of success!

 

 

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

Blog Details Page

  • Date: January 6, 2016
  • Article by: Joe Malewicki

ISSUE: When attempting installation of Smart View 11.1.2.5.400 on 32-bit or 64-bit version of Microsoft Office 2013 the following error occurred while running it as a standard user:

ERROR MESSAGE DETAILS:

Oracle Smart View 32-bit for Office

Error 1935. An Error occurred during the installation assembly component
{9BAE13A2-E7AF-D6C3-A01F-C8B3B9A1E18E}.
HRESULT: 0x80070005.

OK

SCREEN SHOTS:

error

Oracle Smart View 32-bit for Office

Oracle Smart View 32-bit for Office Setup failed.

OK

error2 Continue reading

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