Insight | Experiencing FMW

Introduction:

Oracle Real-Time Integration Business Insight or Oracle Insight is designed for business users to model, collect and monitor business level metrics. It comes fully integrated with Oracle SOA Suite and Oracle Service Bus.

Insight helps the business analysts to control the content and format of metrics they need to know by simply identifying the key points within their business integrations. They will have access to detailed information and data in real-time quickly in hand without any deployments.

Installation:

In current release, Oracle Insight works on Oracle SOA Suite and Oracle Service Bus (may be it will be expanded to other products like BPM, MFT etc later). So, we need to have SOA / OSB 12.2.1 installed for Insight. Oracle Insight can be downloaded from here: http://www.oracle.com/technetwork/middleware/insight/downloads/index.html

The installed is a zip file with 3 patches:

22189824 – Contains Oracle Real-Time Integration Business Insight 12.2.1.0.0 product files.
22655174 – Contains updates to SOA and BAM 12.2.1.0.0.
22659236 – Contains updates to Service Bus 12.2.1.0.0.

Although the readme claims that they are marked as zero-downtime patches (i.e., they can be applied without stopping the server), the patch readme mentions to stop the server and then apply the patches (it could be a readme documentation bug, I am not sure J. Will try in my next installation).

The patches are very straight forward and simple to apply. They have an order to apply though:

If you are installing Oracle Insight in a SOA-only Home, install the patches in this order:

1. 22189824

2. 22655174

If you are installing Oracle Insight in a Service Bus-only Home, install the patches in this order:

1. 22189824

2. 22659236

If you are installing Oracle Real-Time Integration Business Insight in a SOA & Service Bus Home, install the patches in this order:

1. 22189824

2. 22655174

3. 22659236

To apply the patch, it is same way like any other patch using OPatch command. Source the environment variables and then use “opatch apply” command:

set oracle_home=C:\Installs\Oracle\FMW12c\12.2.1

set java_home=C:\Installs\Java\jdk1.8.0_51

set path=%oracle_home%\opatch;%path%

Note: We might encounter the below error while patching:

[Mar 23, 2016 9:37:49 AM] Prerequisite check “CheckActiveFilesAndExecutables” failed.

The details are:

Following files are active :

C:\Installs\Oracle\FMW12c\12.2.1\soa\soa\modules\oracle.soa.fabric_11.1.1\tracking-fabric.jar

C:\Installs\Oracle\FMW12c\12.2.1\soa\soa\modules\oracle.soa.fabric_11.1.1\fabric-runtime.jar

C:\Installs\Oracle\FMW12c\12.2.1\soa\soa\modules\oracle.soa.fabric_11.1.1\tracking-core.jar

[Mar 23, 2016 9:37:49 AM] OUI-67073:UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed.

[Mar 23, 2016 9:37:49 AM] Finishing UtilSession at Wed Mar 23 09:37:49 IST 2016

[Mar 23, 2016 9:37:49 AM] Log file location: C:\Installs\Oracle\FMW12c\12.2.1\cfgtoollogs\opatch\22655174_Mar_23_2016_09_37_47\apply2016-03-23_09-37-35AM_1.log

This is OPatch error. Searched but didn’t find any answer to this. Most of them are asking to restart the servers. On my Windows machine, I have killed conhost.exe and closed JDeveloper, sihost.exe and taskhostw.exe and again ran opatch apply and it worked. Not sure exactly why sihost and taskhostw will lock the above files. Please note that I am on Windows 10 and once we kill taskhostw, Windows will throw an error and force us to logoff. I moved that dialog box to a side and continued to apply the patch. The patches were successful. But ultimately, I had to restart my windows.

Post Patch:

After the patch installation, we need to expand our existing domain (or create a new domain if you need a fresh one) to include Insight components and SOA agents. Run config.cmd from %Oracle_HOME%\oracle_common\common\bin directory to launch Configuration Wizard.

In the below screenshot, I am updating/expanding my existing domain – e2_domain.

We need to select the below components from the available templates for Insight:

Insight SOA Agent 12.2.1 [soa]
Insight Service Bus Agent 12.2.1 [osb]
Insight 12.2.1 [soa]

Choose Next to continue:

There is NO separate schema needed for Insight. It will use SOAINFRA schema and BEAM tables for its metadata. So, continue clicking on Next until the end.