Thursday Apr 04, 2013

Case Management Part 3: Runtime Lifecycle of a Project

Now that we understand what Case Management is and the anatomy of an Oracle BPM 11g PS6 Case Management project, we can look at the simplified lifecycle of a project at runtime.... how the stakeholder interacts, what happens when a Case Activity is triggered, what happens when it ends etc....

Case Management Runtime Lifecycle

[Read More]

Wednesday Apr 03, 2013

Case Management Part 2: Anatomy of a Project

In Oracle BPM 11g PS6, BPM Studio (JDeveloper) is the design-time environment for Case Management. This blog entry will describe the make-up of a Case Management project in BPM Studio, stepping through all the terms and properties associated but will stop short of giving recommendations or best-practices, which will follow in a later blog entry.

BPM Studio: Case Management Project 

[Read More]

Tuesday Apr 02, 2013

Case Management Part 1: An Introduction

With the release of PS6 on 1st April, Case Management made its appearance. In this series of blogs I intend to....

  • introduce the concept of case management
  • explain the anatomy of a case management project in BPM 11g
  • explain the lifecycle of a typical case management project at runtime
  • give pointers as to best practices in the design of a case management project

Case Management Part 1: An Introduction

[Read More]

Tuesday Jan 29, 2013

SOA Suite for Healthcare Integration startup errors due to expired passwords.


SOA Suite for Healthcare integration involves starting up the managed servers, which are in turn, dependent on valid connections to databases. In many low-maintenance environment like Virtualbox images distributed for training and workshops, the database passwords are likely to expire after a certain period. Subsequently, the related SOA startup error becomes a road-block for users not familiar with the database dependencies.

This note describes the step-by-step instructions to resolve the password expiry errors and get the SOA Suite for Healthcare Integration environment back up and running.


The errors seen on startup of SOA server could look like the following:

  • Caused by: javax.ejb.CreateException: SDP-25700: An unexpected exception was caught.
  • Cause: weblogic.common.resourcepool.ResourceDeadException:
  • weblogic.common.ResourceException: Could not create pool connection.
  • The DBMS driver exception was: ORA-28001: the password has expired


The error is caused by the fact that the database passwords in the image are set to expire after a definite period. To get past the issue, the passwords for the following database users have to be reset:


These users with DEV_ prefix are the default but could vary in other situations, where custom prefixes may have been used during installation of SOA Suite repository. 

All the passwords can be set to the original value, e.g. welcome1 by logging into a SQL*PLus session as a DBA and using the following command for each database user one at a time :

  • SQL> Alter user <username from above list> identified by welcome1;
The above procedure is applicable to all database users. Alternatively, upon attempts to login to a SQL*Plus session as a database user with expired password, the session itself can prompt for new passwords.


Below, we have the excerpt from a terminal session captured from the Virtualbox image, distributed for SOA Suite for Healthcare Integration training. It shows how the passwords were reset using the approaches mentioned earlier.

[oracle@soahc ~]$ . oraenv
ORACLE_SID = [orcl] ?
The Oracle base for ORACLE_HOME=/u01/DBInstall/product/11.2.0/dbhome_1 is /u01/DBInstall
[oracle@soahc ~]$ sqlplus

SQL*Plus: Release Production on Date...

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

Enter user-name: system
Enter password: welcome1
ORA-28001: the password has expired

Changing password for system
New password: welcome1
Retype new password: welcome1
Password changed

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter user DEV_SOAINFRA identified by welcome1;

User altered.

SQL> alter user DEV_MDS identified by welcome1;

User altered.

SQL> alter user DEV_ORASDPM identified by welcome1;

User altered.

SQL> conn / as sysdba


Tuesday Apr 10, 2012

Running Built-In Test Simulator with SOA Suite Healthcare 11g in PS4 and PS5

SOA Suite Healthcare Integration Pack provides a built-in utility to simulate an external endpoint for HL7 messaging flows. This lightweight, ant-based utility can be very useful to quickly simulate an endpoint for setting up round-trip HL7 messaging in a standalone, closed environment.

This note gives an overview about the setup and usage of the simulator utility. It also points out the differences that users have to keep in mind when migrating from PS4 to PS5 release.

[Read More]

Tuning B2B Server Engine Threads in SOA Suite 11g

B2B Server Properties from EM console can be used to tune the thread configuration of the B2B engine to improve overall B2B performance.[Read More]

Wednesday Mar 14, 2012

Enterprise-class SOA on Exalogic... what, why and how?

Exalogic A-Team member Rupesh Ramachandran has recently blogged about his OpenWorld 2011 talk on enterprise-class SOA systems on Exalogic. He covers some of the basic "what, why, and how" questions about Exalogic. Please follow this link to the A-Team Exalogic blog to read more.

This is the blog for the Oracle FMW Architects team fondly known as the A-Team. The A-Team is the central, technical, outbound team as part of the FMW Development organization working with Oracle's largest and most important customers. We support Oracle Sales, Consulting and Support when deep technical and architectural help is needed from Oracle Development.
Primarily this blog is tailored for SOA issues (BPEL, OSB, BPM, Adapters, CEP, B2B, JCAP)that are encountered by our team. Expect real solutions to customer problems, encountered during customer engagements.
We will highlight best practices, workarounds, architectural discussions, and discuss topics that are relevant in the SOA technical space today.


« August 2016