Follow Us on Twitter

Setting up Oracle Stream Explorer 12.1.3

by Patrick Sinke on March 13, 2015 · 0 comments

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

Next step: using Stream Explorer for realtime data monitoring.

Ratings:
VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

{ 0 comments… add one now }

Leave a Comment

 

Previous post:

Next post:

About Whitehorses
Company profile
Services
Technology

Whitehorses website

Home page
Whitebooks
Jobs

Follow us
Blog post RSS
Comment RSS
Twitter