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 220.127.116.11.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 : 18.104.22.168.0 OUI version : 22.214.171.124.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, 126.96.36.199.0... Patching component oracle.oep, 188.8.131.52.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:
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!
Next step: using Stream Explorer for realtime data monitoring.Overzicht blogs