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.
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 220.127.116.11.0 product files.
- 22655174 – Contains updates to SOA and BAM 18.104.22.168.0.
- 22659236 – Contains updates to Service Bus 22.214.171.124.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:
If you are installing Oracle Insight in a Service Bus-only Home, install the patches in this order:
If you are installing Oracle Real-Time Integration Business Insight in a SOA & Service Bus Home, install the patches in this order:
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:
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 :
[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.
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.
Click Next. No need to select anything here. I clicked on deployments to show the Insight application and its target:
As we see in the below screen, our domain will be expanded with the below applications and agents:
In the summary, we can see what is being updated in the domain:
Click on Update to update the domain.
Click on Next and Finish and start the servers.
Once the servers are started, we can see that the deployments are active and ready:
TO launch the Insight UI, use the below URL:
Insight Console looks like below:
We will explore more on the Insight in my next post. Happy Patching J