is a new resiliency feature in 12.2.1 that helps to simplify operations
and ensure system stability when downstream endpoints become
This post is meant to be a quick introduction to this new feature so you can start testing it out.
Circuit Breaker overview
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...)
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
SOA 12c Themes
theme is outcome of the community that currently (more...)
The new version of OBIEE 12c, 220.127.116.11 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...)
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.
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...)
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:
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...)
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...)
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
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...)
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
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...)
Training On-Demand: Oracle Business Process Management 12c
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
It introduces process developers to Oracle BPM Suite 12c.
It covers the key concepts, features and processes needed to (more...)
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
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
Thanks to the product management team the latest SOA Suite 12.2.1 VirtualBox image is available for download here.
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...)
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
----------------------------------------------------- -------- ------------------------------------
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...)
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 […]
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...)
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...)
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...)