- Whitehorses - http://blog.whitehorses.nl -

Setting up Oracle Stream Explorer 12.1.3

Tweet [1]

Oracle Stream Explorer is available now for download. For those unfamiliar with the product, it is a new tool based on Oracle Event Processing (OEP, formerly known as Complex Event Processing). It’s a graphical interface on OEP, hiding the rather daunting CQL (Continuous Query Language) from the user.

Installation is pretty straightforward. You start with installation of OEP 12.1.3.

Mind you that OEP is installed in a separate Oracle Home.

Where is Stream Explorer? Well, that’s disguised as patch 20225179. Install it using OPatch in your OEP home.

psinke@psinke-WHLT-M4600:~/Downloads/sxinstall/20225179$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 13.2.0.0.0
Copyright (c) 2014, Oracle Corporation.  All rights reserved.

Oracle Home       : /home/psinke/Oracle/Middleware/Oracle_Home
Central Inventory : /home/psinke/oraInventory
   from           : /home/psinke/Oracle/Middleware/Oracle_Home/oraInst.loc
OPatch version    : 13.2.0.0.0
OUI version       : 13.2.0.0.0
Log file location : /home/psinke/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/20225179_Mar_13_2015_15_06_11/apply2015-03-13_15-06-08PM_1.log

OPatch detects the Middleware Home as "/home/psinke/Oracle/Middleware"

mrt 13, 2015 3:06:11 PM oracle.sysman.oii.oiii.OiiiInstallAreaControl initAreaControl
INFO: Install area Control created with access level  0
Applying interim patch '20225179' to OH '/home/psinke/Oracle/Middleware/Oracle_Home'
Verifying environment and performing prerequisite checks...
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/home/psinke/Oracle/Middleware/Oracle_Home')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Patching component oracle.oep, 12.1.3.0.0...

Patching component oracle.oep, 12.1.3.0.0...

Verifying the update...
Patch 20225179 successfully applied
Log file location: /home/psinke/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/20225179_Mar_13_2015_15_06_11/apply2015-03-13_15-06-08PM_1.log

OPatch succeeded.
psinke@psinke-WHLT-M4600:~/Downloads/sxinstall/20225179$

Configure your OEP installation with [OEP_HOME]/oep/common/bin/config.sh. Create a new domain (mostly default settings here), and start it by running:

$ [OEP_HOME]/user_projects/domains/oep_domain/defaultserver/startwlevs.sh

Once the domain is fired up, go to http://localhost:7101/sx (or another host and port when applicable) and login with the user and password provided in the OEP configuration. You are done!

Oracle Event Processing Visualizer [3]

Next step: using Stream Explorer for realtime data monitoring.