icon-arrow icon-check icon-mail icon-phone icon-facebook icon-linkedin icon-youtube icon-twitter icon-cheveron icon-download icon-instagram play close close icon-arrow-uturn icon-calendar icon-clock icon-search icon-chevron-process icon-skills icon-knowledge icon-kite icon-education icon-languages icon-tools icon-experience icon-coffee-cup
Werken bij Integration & Application Talents
Blog 13/03/2015

Setting up Oracle Stream Explorer 12.1.3

Setting up

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
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    :
OUI version       :
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]
User Responded with: Y
Backing up files...

Patching component oracle.oep,

Patching component oracle.oep,

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.

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!


Next step: using Stream Explorer for realtime data monitoring.

Overzicht blogs

Geen reacties

Geef jouw mening

Reactie plaatsen

Reactie toevoegen

Jouw e-mailadres wordt niet openbaar gemaakt.


  • Geen HTML toegestaan.
  • Regels en alinea's worden automatisch gesplitst.
  • Web- en e-mailadressen worden automatisch naar links omgezet.

Wil je deel uitmaken van een groep gedreven en ambitieuze experts? Stuur ons jouw cv!