Resiliency: Circuit Breaker

clip_image002


Circuit Breaker is a new resiliency feature in 12.2.1 that helps to simplify operations and ensure system stability when downstream endpoints become unavailable.

This post is meant to be a quick introduction to this new feature so you can start testing it out.

Circuit Breaker overview

Circuit Breaker enables you to configure the system to automatically suspend upstream endpoints when a downstream system is down or unreachable from a SOA composite. This prevents (more...)

What is SOA 12c ? by Tutorial Diary

clip_image002

Oracle SOA Suite 12c is new version of SOA Suite tool from Oracle. Oracle has introduced lot of new features in this new version. This new version is based upon 4 themes as show below. First two themes (Developer productivity and Industrial SOA) comes as outcome of user/developers feedback and other two themes (Mobile and Cloud) introduced as per industry trend.

SOA 12c Themes

Developer Productivity

This theme is outcome of the community that currently (more...)

OBIEE12c – Upgrading to Version 12.2.1.1

INTRODUCTION

The new version of OBIEE 12c, 12.2.1.1 to be exact, is out, so let’s talk about it. It’s my intent that after reading this, you can expect some degree of comfort in regards to possibly doing this thing yourself (should you find yourself in just such a circumstance), but if not, feel free to drop us a line or give us a ring. It should be noted that Oracle documentation explicitly (more...)

What about to upgrade to Oracle SOA Suite 12.2.1? by Rolando Carrasco


clip_image001

This is my last post of the year.
Strangely this was the year with less posts here in Oracle Radio. And not only that, but I started to do it in English.
Since 2007 I’ve been feeding this blog in Spanish, but for some specific posts I just decided to do it in English to get to a greater audience.
So what about to upgrade to Oracle SOA Site 12.2.1? Is the name (more...)

I don’t like the Mediator by Luc Gorissen

clip_image002

Ok, so there you have it: I just don’t like the Mediator. I don’t really know why. But now that it’s in the open, let’s discuss it.

I often see a pattern where a composite with a synchronous operation is implemented with a Mediator and BPEL component:

I think that in most of these cases, it would be better to either leave out the Mediator component completely. Or replace it with a BPEL component that (more...)

Next Step in Row generation in Oracle Database 12c SQL using JSON_TABLE

One of those things SQL developers are frequently looking at is the generation of rows: having a query return records that do not really exist. For example to generate test data or to produce records for all days in a month. Tom Kyte usually selects from data dictionary views. Various tricks make the rounds, for example based on CONNECT BY or CUBE or UNPIVOT. This blog article by Natalka Roshak (2015) compares various row generation (more...)

How to find purgeable instances in SOA/BPM 12c by Derek Kam

clip_image002If you are familiar with SOA/BPM 11g purging, after you have upgraded/implemented SOA/BPM 12c, you will not be able to use most of the SQL for 11g to determine the purgeable instances.  This is because SOA/BPM 12c is no longer using composite_instance table for composite instance tracking.

In SOA/BPM 12c, a common component is used to track the state associated with a business flow and report audit information.  This design will reduce the (more...)

Dramatically reduce SOA Suite 11g startup time by cleaning the MDS by Maarten Smeets

clip_image002

SOA Suite can sometimes be a bit slow to start. This is especially the case when there are a lot of composites to load. Customers using different versions of composites can benefit from undeploying non-default revisions of processes which do not have any running instances (see for example here). Undeployment in most cases is an asynchronous process which does not give feedback. It can partially fail without you noticing (apparently not an atomic transaction). (more...)

SOA Suite 12c: Topology Suggestions by Jay Kasi

In this article, I make some suggestions and provide opinions on topologies for SOA Suite 12c that is commonly used and supported. Only the EDG topology is thoroughly tested by Oracle though.
  • One consideration when deciding on topologies is that Upgrade is always domain wide. All products deployed to the domain must release in the same release train and you should be willing to upgrade all of them at the same time.

Autumn SOA Suite 12c and BPM Suite 12c free on-demand Bootcamps October 2016

image

Training On-Demand: Oracle Business Process Management 12c

This boot camp is an ideal starting point for an implementer who is planning to learn Oracle BPM Suite 12c and use it on BPM projects. The course provides a combination of lecture segments that present conceptual and feature background and hands-on labs that provide practice with the tooling.

It introduces process developers to Oracle BPM Suite 12c. It covers the key concepts, features and processes needed to (more...)

OOW16 – Focus on Upgrade / Migrate / Consolidate

Almost ready to fly out - just have to pack my suitcase. And looking forward to an exiting Oracle Open World 2016 Conference in San Francisco.  If you are interested in a selection of really useful presentations, labs and meetups around Upgrade / Migration (incl DMU) / Consolidation and the Optimizer in Oracle... [Read More]

The OJVM Patching Saga – and how to solve it – Part III

Related Posts on"The OJVM Patching Saga - and how to solve it": Part I - The Basicshttps://blogs.oracle.com/UPGRADE/entry/the_ojvm_drama_and_how(Sep 5, 2016). Part II - Important Notes and Informationhttps://blogs.oracle.com/UPGRADE/entry/the_ojvm_drama_and_how1(Sep 6, 2016). Part III -... [Read More]

SOA Suite 12.2.1 VirtualBox Image available for download

clip_image002

Thanks to the product management team the latest SOA Suite 12.2.1 VirtualBox image is available for download here.

Overview

Please note that this appliance is for testing purposes only, as such it is unsupported and should not to be used in a production environment.

This VirtualBox appliance contains a fully-configured, ready-to-use SOA Suite 12.2.1 installation.

All you need is to install Oracle VM VirtualBox on your desktop/laptop and import the (more...)

Easy SOA releases with JGitFlow

If you use GIT as your source control system and if you use maven, the jgit-flow plugin is a massive time-saver, especially when we release a slightly large application with multiple modules (Each with it's own pom file). 

Two steps: 
 mvn external.atlassian.jgitflow:jgitflow-maven-plug in:release-start
and 
 mvn external.atlassian.jgitflow:jgitflow-maven-plug in:release-start

do the job. 

The above sequence basically updates the pom file versions to a release version (e.g. from 1. (more...)

Bad Coding and 12c Upgrade Will Break

With the introduction of CDB, many views have added column CON_ID.

DB1:(SYS@DB1):PRIMARY> select inst_id inst,sid,serial#,program,machine from gv$session where sid in ((select * from dba_blockers));
select inst_id inst,sid,serial#,program,machine from gv$session where sid in ((select * from dba_blockers))
                                                                              *
ERROR at line 1:
ORA-00913: too many values


DB1:(SYS@DB1):PRIMARY> desc dba_blockers;
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 HOLDING_SESSION                                                NUMBER
 CON_ID                                                         NUMBER

DB1:(SYS@DB1):PRIMARY> select inst_id inst,sid,serial#,program,machine from gv$session where sid in ((select HOLDING_SESSION from dba_blockers));

INST        SID    SERIAL# PROGRAM                         (more...)

Test Driven SOA – citrus for powerful SOA test coverage

Reading parts of Test-Driven Development for Embedded C" by James W. Grenning inspired me to take another look at this area and look for something new,  fresh and powerful.

I don't think we need much convincing on the importance of  automated test coverage (if someone does, please read the first chapter of the book mentioned above, especially the section on "Physics of TDD" that tries to quantify the high long-term costs of "Debug later programming" (more...)

Oracle 12c: Indexing JSON in the Database Part III (Paperback Writer)

In Part I and Part II, we looked at how to index specific attributes within a JSON document store within an Oracle 12c database. But what if we’re not sure which specific attributes might benefit from an index or indeed, as JSON is by it’s nature a schema-less way to store data, what if we’re not entirely sure […]

ORACLE_MAINTAINED Set From “_ORACLE_SCRIPT” parameter

A huge thank you to Pete Finnigan for his blog post.

Hacking Oracle 12c COMMON Users

Not only is the implementation of ORACLE_MAINTAINED not ideal, it’s a possible security risk.

My tip to you is to always exit the session before performing any object creation.

From my pain as you can see, looks like “_ORACLE_SCRIPT was not reset when new users where created.

Also ORACLE_MAINTAINED Objects Don’t Export

Learned quite a few new thing this weekend and (more...)

ORACLE_MAINTAINED Objects Don’t Export

What a disaster this is with 12c full database export and ORACLE_MAINTAINED objects.

Somehow, oracle thinks MDINH is an ORACLE_MAINTAINED user and user MDINH does not get exported.

———

Why Can an Object Not Be Exported? Expdp of SYSTEM User’s Table Returns ORA-39166 or ORA-31655 (Doc ID 2114233.1)

There are certain system generated schemas that are not exportable using exp or expdp because they contain Oracle-managed data and metadata. SYS, MDSYS, and ORDSYS are some (more...)

To CDB or NOT To CDB (ORACLE_MAINTAINED Column)

I recently discovered about column ORACLE_MAINTAINED added to DBA views and got excited over nothing.

ORACLE_MAINTAINED from DBA_ROLES
Denotes whether the role was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
A role for which this column has the value Y must not be changed in any way except by running an Oracle-supplied script.

It looks like ORACLE_MAINTAINED is only valid for CDB and seems as if Oracle is really wanting all (more...)