Attaching Oracle Home to OraInventory

OPatch Apply

When patches are applied to Oracle Products, patch utility checks/updates Oracle Inventory. If  pre-requisites  (e.g particular version of product)  information is not present in Inventory, patching process will fail. Oracle Inventory may not be up to date for many reasons. One of the primary reason is presence of multiple oraInventories… Read moreAttaching Oracle Home to OraInventory

TypeError: Cannot find function in object http://docs.oasis-open.org/wsbpel/2.0/process/executable

With Soa 12.2.1 , we can create BPEL component and use Javascript inside the BPEL activities like assign, while , if , wait, etc We also have a Javascript activity in which we can write block of javascript code to manipulate the data. “bpel” is one of the global object which… Read moreTypeError: Cannot find function <name> in object http://docs.oasis-open.org/wsbpel/2.0/process/executable

Soa 12.2.1 New Feature – End to End JSON and Javascript Example

Output from REST GET Query

SOA 12.2.1 provides support for end-to-end JSON and Javascript. We don’t have do internal mapping between XML and JSON as in 12.1.3. As part of this post, let us implement a simple REST service to demonstrate this new feature – End to End JSON with Javascript. Let us create a very… Read moreSoa 12.2.1 New Feature – End to End JSON and Javascript Example

Get value from Coherence Cache using Coherence Adapter

Test Result

This post is in continuation to Add Coherence node to Soa 12c’s integrated weblogic coherence cluster post.  As part of earlier post, we created another coherence node , added a value to out-of-box adapter-local cache. As part of this blog, we will see how to get value from coherence cache using coherence… Read moreGet value from Coherence Cache using Coherence Adapter

Add Coherence node to Soa 12c’s integrated weblogic coherence cluster

Standalone Coherence Node

Let us see how to add coherence node to Soa 12c’s integrated Weblogic coherence cluster. We will put value in out-of-box “adapter-local” cache from the added node and access that value from a SOA Composite using Coherence Adapter. We will use the out-of-box cache config  from Soa 12c’s Coherence Adapter. It… Read moreAdd Coherence node to Soa 12c’s integrated weblogic coherence cluster

Soa 12.2.1 – RCU Installation Error – Error Creating PL/SQL Object – MDS Internal Common

Error in DB

While Installing schemas using RCU utility for the latest SOA 12.2.1 release, following error occurred irrespective of Database version (10g XE, 11g XE, 11gR2, 12c). After Ignoring the error, rest of RCU installation went through fine. On logging in with MDS schema user account (<prefix>_MDS), JDev shows following error These… Read moreSoa 12.2.1 – RCU Installation Error – Error Creating PL/SQL Object – MDS Internal Common

Soa 12.2.1 Feature – Patching Running instance of Composites

BPEL Process

Soa 12.2.1 was released recently. Let us see how to implement one of the new feature of this release – Patching Running instances of composites. With this feature, we can make selective modifications to running composites’ base code, create a patch using JDeveloper. Using WLST commands, we can apply the patch to server…. Read moreSoa 12.2.1 Feature – Patching Running instance of Composites

Finding instances using wildcard search on title field in SOAINFRA schema

Query Sca_Flow_Instance table

This post is about finding instances using wildcard search by querying SOAINFRA schema. Edited on 6th Feb: Wild Card search in EM on instance title works in 11g and 12c . Tested with 11.1.1.7.8 and 12.2.1. Specific composite instance can be located in EM using  composite instance’s title and composite sensor’s… Read moreFinding instances using wildcard search on title field in SOAINFRA schema

Soa12c – Creating DB Connection in JDeveloper to JavaDB

Java DB Connection Details

In 11g, we need to have Oracle DB(minimum 10g XE version) for SOA Dehydration store. However, SOA 12c Quick Installation comes with a Java based Database called JavaDB. Let us see how to create a connection to Java DB and execute a query. Start JDeveloper’s Integrated Weblogic Server. This should automatically start… Read moreSoa12c – Creating DB Connection in JDeveloper to JavaDB

Soa12c – How to locate a composite instance using title and sensors in EM

Searching by Sensors

In a high-volume environment, it is not easy to go and find a  particular composite instance which processed a particular Order Id. We will see in this blog two ways in which we can locate a particular composite instance in Enterprise Manager. To locate a composite instance using wild card search see Wild… Read moreSoa12c – How to locate a composite instance using title and sensors in EM