Installing Oracle SOA Suite 12c

Hi All, As you all know that the Oracle 12c is out now… this is the first Major release where oracle has now combined the Oracle Service Bus with the SOA Suite Install… and its apparently only a 30 min single installation… So firstly download the soa suite  from http://download.oracle.com/otn/nt/middleware/12c/121300/fmw_12.1.3.0.0_soaqs_Disk1_1of1.zip This contains SOA Suite 12.1.3 Size: 2.97 GB, Check […]

read more

Configuring Automatic Engine Recovery for Oracle BPEL Process Manager

Oracle SOA Suite provides an automatic recovery feature in Oracle Enterprise Manager Fusion Middleware Control Console that enables you to configure and recover: All activities (for example, wait activities and OnAlarm branches of pick activities) that have an associated expiration date and are scheduled with the SOA Infrastructure to be rescheduled All activities that are […]

read more

SOA 11g SOA Infra DB states for SOA Composites and Components

I found this extremely useful list of states for SOA 11g composites and various components in the SOA INFRA DB which we have benefited greatly in various engagements, so I thought it was worth sharing with you all.   COMPOSITE_INSTANCE States State Description 0 Running 1 Completed 2 Running with faults 3 Completed with faults 4 […]

read more

Duplicate instances when using DB adapter in high availability environment.

Many a times I have noticed that when you use DB Adapters (SOA Suite 11g) for integrating with applications like the E Business Suite in a clustered high availability environment, at times there will be multiple instances for the same request. The number of instances each entry in the DB would generate would directly correlate […]

read more

SOA 11g – Useful SOA Infra DB Queries [Advanced users]

Sometimes you want to identify all the faults for the messages that were sitting in BPEL Engine Level recovery as undelivered Invokes. We can run this SQL on the SOA Infra Schema to obtain this info. select wif.* FROM WI_FAULT WIF WHERE wif.cikey IN (SELECT ci.cikey FROM Dlv_Message dlv, cube_instance ci WHERE dlv.State = 0 AND […]

read more