Oracle SOA Suite 12c: database configuration

After the running the rcu i was keen what was created inside the database. The installation showed some additional tablespaces:
select tablespace_name from dba_tablespaces; 
TABLESPACE_NAME              
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
DEV_SOAINFRA
DEV_IAS_TEMP
DEV_STB
DEV_IAS_UMS
DEV_WLS
DEV_MDS
DEV_IAS_OPSS
DEV_IAU

13 Zeilen gewählt.
Ok. Not really exciting.
But the list of the created tables was quite impressing:
select OWNER,TABLE_NAME from all_tables where owner like 'DEV%';

OWNER                TABLE_NAME                             
-------------------- ----------------------------------------
DEV_MDS              MDS_PURGE_PATHS                        
DEV_SOAINFRA         AQ$_IP_QTAB_G                          
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_G            
DEV_SOAINFRA         (more...)

Oracle SOA Suite 12c: rcu from a remote host / database configuration

First step is to configure the database on your Oracle Linux server which hosts your database:
[root@localhost admin]# firewall-cmd --permanent --zone public --add-port=1521/tcp
success
Then run the rcu:
schroff@zerberus:/home/data/opt/oracle/Middleware/Oracle_Home/oracle_common/bin$ ./rcu

    RCU-Logdatei: /tmp/RCU2017-10-14_22-36_851447466/logs/rcu.log
The startup screen:
 Connect to you database:
 Connection successful:
 Certified database?!
 Choose the SOA Suite components:

 Password definition for all created schemas:
 Variables (take a look here)
 Tablespaces:
 Creation of tablespaces:

 Summary:
 Create schemas:
The end:

Oracle SOA Suite 12c: rcu fails on Oracle Linux

Next step after setting up a database is running the rcu script to create the soa suite schema inside the database. But this step fails with an ugly exception:

[oracle@localhost bin]$ pwd
/mnt/Middleware/Oracle_Home/oracle_common/bin
[oracle@localhost bin]$ ./rcu

    RCU-Logdatei: /tmp/RCU2017-10-07_18-13_966788282/logs/rcu.log

Exception in thread "main" java.lang.ExceptionInInitializerError
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method. (more...)

Oracle SOA Suite 12c: Installation – Preparing the database

After a successful installation of Oracle 12c database the next step is to create a plugable databse (PDB).
Therefor you have to run the dbca (database creation assistant):
~/app/oracle/product/12.2.0/dbhome_1/bin/dbca










 The first check fails with:
[oracle@localhost ~]$ export ORACLE_SID=soasuite12c
[oracle@localhost ~]$ sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on Sat Oct 7 17:00:21 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter user-name: bpeladmin
Enter password:
ERROR:
ORA-01034: ORACLE (more...)

Mediator throwing incomplete BusinessFaultException

A while ago I ran into the issue that business fault information was not returned to the calling system by the Mediator component in the SOA composite. Instead, only a message that a business fault occurred was responded to the calling system. The response would look something like the below example:

<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
	<env:Header/>
	<env:Body>
		<env:Fault>
			<env:Code>
				<env:Value>env:Receiver</env:Value>
			</env:Code>
			<env:Reason>
				<env:Text xml:lang="en-US">oracle.fabric.common.BusinessFaultException</env:Text>
			</env:Reason>
			<env:Role/>
			<env:Detail>
				<exception/>
			</env:Detail>
		</env:Fault>
	</env:Body>
</env:Envelope>

(more...)

Integration Cloud Service, SOA Cloud Service or Integration Cloud, are you confused?

Oracle have announced Oracle Integration Cloud, the next evolution in their cloud integration capabilities. So how does it relate to the existing Cloud based integration products and what is the future of different products? To best understand this, let’s first look at the existing landscape. Our first diagram shows a subset of the Oracle PaaS […]

The post Integration Cloud Service, SOA Cloud Service or Integration Cloud, are you confused? appeared first on Implementing Oracle (more...)

Oracle SOA Suite 12c: Running BPEL processes with Jdevelopers built in weblogic server

After creating a BPEL process with jdeveloper i want to run this process inside the jdeveloper built in weblogic server.

Therefor you have to choose "run->start server instance (integratedweblogicserver)":


Enter a password of your choice (more than 8 characters required):

Via bash you can see the weblogic process:
$ ps auxwww|grep weblogic
schroff  17464  287  9.6 4381716 778820 pts/17 Sl+  20:54   1:11 /home/data/opt/jdk1.8.0_131/bin/java -DORACLE_HOME=/home/data/opt/oracle/Middleware/Oracle_Home/oracle_common -Xms32m -Xmx1024m -XX:MaxPermSize=768m weblogic.WLST /home/schroff/.jdeveloper/system12.2. (more...)

Oracle SOA Suite developer IDE: Jdeveloper 12c (download & installation)

After installing an Oracle 12c database onto an Oracle Linux i want to run Oracle's SOA Suite. But before the installation of SOA Suite 12c including the application server, i decided to download Jdeveloper to get a first impression of BPEL processes in version 12c (several years ago i did some projects with Oracel Fusion and Oracle SOA Suite 11g).

First try, to get Jdeveloper with SOA Suite extensions (skip these 4 steps - (more...)

UKOUG Conference

As part of the UKOUG SIG committee for middleware I have had the opportunity to contribute to the planning of the conference in December (Tech17). The agenda looks really exciting with a range a high class submissions covering on-premises to cloud, from micro to monolith, API to application, source to SOA.

Presenters go from newbies to world class names, not to mention key Oracle product managers.

Here are a couple of tweets from the planning (more...)

OGh Tech Experience 2017 – recap

On June 15th and 16th 2017 the very first OGh Tech Experience was held. This 2-day conference was a new combination of the DBA Days and Fusion Middleware Tech Experience that were held in previous years. To summarize: OGh hit bullseye. It was two days packed with excellent in-depth technical sessions, good customer experiences and great networking opportunities.

The venue was well chosen. De Rijtuigenloods in Amersfoort is a former maintenance building of the Dutch (more...)

Interfacing with HCM (or other file source) via FTP – ICS Definitive Tip #8

The techniques for integrating Oracle Human Capital Management (HCM) and several other Oracle SaaS solutions can require the use of Oracle Transactional Business Analysis (OTBI). The need for OTBI comes down to the fact that to  access to the relevant data an API is not available. OTBI can be configured to generate a report and […]

The post Interfacing with HCM (or other file source) via FTP – ICS Definitive Tip #8 appeared first on (more...)

Enterprise World Wide Cloud – Notes from the Oracle #PaaSForum 2017


This must be one of the last posts on #PaaSForum 2017 that anyone has written. Too late but I hope not too little, as it gives us an opportunity to reflect upon the material presented there. I heartily thank Jürgen Kress for organising this event on a grand scale, at a beautiful location (Split, Croatia this year), for his invitation, warm welcome and hospitality. Also thanks to his colleagues from Oracle for their help in (more...)

Back from PaaSForum

So, and now we're back in business after a splendid week in Split, Croatia, to meet with about 200 great, enthusiastic con-colleagues from the fields of SOA and Weblogic. It was the yearly OPN Partner Community Forum, ran by the great Jürgen Kress. He did a formidable job to collect many informatic sessions on the latest news and products from Oracle. We could meet with product managers, eat  and drink with them. To my surprise (more...)

Oracle Weblogic: Tackling Class Loading Issues for SOA Infra

This blog article discusses how to address class loading issues with the Oracle SOA Infra. It's prime "raison d'etre" being a memory dump of something I don't do often, but may spend significant time in finding out how to do it again.

Some time ago I lost valuable time because some library being deployed twice, once in the wrong place ([SOA_HOME]/lib folder) and once in the right place ([SOA_HOME]/soa/modules/oracle.soa.ext_11.1.1). In this (more...)

Oracle BPM: Hiding Faults from BPM? Don’t use Service Activity!

In the following I explain how you can hide faults from BPM by not using (synchronous) Service activities, but (asynchronous) Send/Receive activities instead.

When calling services from a BPM process, you should think about where you want faults to show up and to be handled. This is specifically of interest when you have some integration layer between your BPM processes and external services that you call to abstract the external services from the BPM process. (more...)

Oracle SOA/BPM 12c: Contract WSDL Only in MDS?

In this posting I will discuss if it is a good idea to only have a (contract) WSDL in the MDS, and let your implementing composite point to that, instead of having a WSDL in the project itself (as well).

When developing SCA composites with JDeveloper, initially your WSDL will be in the project of the composite. Some people put a contract WSDL in the MDS, and then let the code of the SCA composite (more...)

Creating and editing forms in Process Cloud Service

For who is PCS?

Oracle Process Cloud Service is a PaaS (Platform as a Service) offering which centers around designing and managing (stand alone) business processes in the cloud. The focus is once again on business analysts and other non-technical people to automate business processes. Oracle has keyed them “citizen developers”. One of the features is the option to create forms that fulfill the “human task” interaction in the BPM process.

A walkthrough for creating (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...)

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 BPM 11g/12c: How to Catch an Event in the Same Process

A customer of mine was kind of surprised that when you throw an event in a component of a SCA composite, that the same component cannot catch that event and act upon it. This is a known limitation, for which there is a work-around, which I will discuss in this article.

The work-around is quite simple: another loosely coupled component in the same composite can listen to the event, so all you have to do (more...)