SOA/BPEL/ESB/OSB

Simple steps to Configure JMS Resources:

2013-10-01T01:17:00.002-07:00

Below are 3 simple steps to Configure JMS Resources:

1. Create JMS Server
2. Create JMS Module
3. Create JMS Resource (Sub deployment, connection factory, queue or topic)

What is Throttling in OSB11g?

2013-09-30T04:57:00.002-07:00

1.Throttling is used to "regulate the flow". By using Oracle Service Bus throttling feature
we can control number of requests sent to target service.
2.Every system has its own capacity means it can process only certain number of message at one time, if we try to send messages beyond its capacity then that system's performance can degrade or in worst case it can crash. So to avoid all this we can use OSB throttling feature to send limited messages to target system.
3.To enable throttling inside OSB, Open Business Service then click on "Operational Settings".

4.Then you can see throttling options available under Operational Setting tab.

Action Controls in OSB:

2013-09-30T04:50:00.003-07:00

Action Controls are categorized as below:

        1) Communication Actions
            a) Dynamic publish
            b) Publish
           c) Publish table
           d) Routing options
           e) Service callout
           f) Transport headers

     2) Flow Control Actions
         a) For Each
         b) If Then
        c) Raise Error
        d)Reply
        e) Resume
        f)Skip

    3) Message Processing Actions
       a) Assign
       b) Delete
       c) Insert
       d)Java callout
       e) MFL transform
       f) Rename
      g) Replace
      h) Validate

    4) Reporting Actions
          a)Alert
          b)Log
         c)Reporting

How to Implement REST in OSB and what is VETRO in OSB?

2013-09-30T04:48:00.000-07:00

We can Implement REST in OSB using Branch Node.
VETRO stands for
V – Virtualisation
E – Enrichment
T – Transform
R – Route
O – Operate

Stored Procedure Syntax:

2013-09-30T00:07:00.001-07:00

The syntax for a procedure is:

CREATE [OR REPLACE] PROCEDURE procedure_name
[parameter1, parameter2…]
IS
[declaration_section]

BEGIN
executable_section

[EXCEPTION
exception_section]

END [procedure_name];

Details about SOA Certification.

2013-09-27T01:20:00.003-07:00

Please Find below details for SOA Certification.

Exam Number: 1Z0-478
Exam Name: Oracle SOA Suite 11g Certified Implementation Specialist
Duration:120 Min
Number Of Questions:73
Passing Score:60%
Exam Price:US$245 (Approximately)
To Register Exam Or for more details please refer below Oracle Link:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=51

Difference between services and components?

2013-09-27T01:08:00.001-07:00

Services are logical grouping of components to achieve business functionality.

Components are implementation approaches to make a service. The components can be in JAVA, C#, C++ but the services will be exposed in a general format like Web Services.

Link to download JDeveloper's extension for SOA technologies?

2013-09-23T02:53:00.002-07:00

Below is the link to download all SOA technologies extensions for Jdeveloper.
http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/156082.xml

Link to Download JDK6 for Windows

2013-09-20T06:46:00.001-07:00

Below is the link to download JDK6 for window:

https://code.google.com/p/springshowcase/downloads/detail?name=jdk-6-windows-i586.zip&can=2&q=

What are the free available tools to test Web services?

2013-09-19T08:02:00.000-07:00

Below are the free available tools to test web services:

1. SoapUI

2. Eclipse

What are the free available tools to develop Web services?

2013-09-19T07:59:00.000-07:00

Below are the free available tools to develop services:

1. Jdeveloper

2. Eclipse

Steps to Create BAM Report?

2013-09-19T01:00:00.000-07:00

Below 3 steps used to create BAM Report:

Step1: Create a BAM Data Object

Step2: Create a BAM Report layout using template.

Step3: Propagate data to BAM Data Objects from SOA Composite.

What are Data Objects in BAM

2013-09-18T06:59:00.000-07:00

Data Objects are like tables or like excel sheet columns, which are data containers,
BAM generates Reports based on data available in data objects. Irrespective of how the data is populated BAM generates same sort of reports.

Important things to remember BAM

2013-09-18T06:54:00.001-07:00

Important paints of BAM:

1.All BAM dashboards and reports can be viewed directly as webpages without ActiveViewer. To get the URL for the report,
see ActiveStudio- select report – copy shortcut URL.
2. All BAM dashboards can be referenced using a URL, these can be
embedded in other portals and webpages as iFrame.
3.SOA/BPEL10g is compatible with Oracle BAM 11g. If you have not used Oracle BAM before then you should start with Oracle BAM 11g. If you use Oracle BAM 10g,you can upgrade your Oracle BAM deployment to 11g. It will continue to work with SOA/BPEL 10g.There is an upgrade utility packaged as part of the Oracle BAM 11g installation to provide a seamless upgrade of your Oracle BAM 10g metadata to Oracle BAM 11g.
4.Oracle BAM 11g is 100% Java and runs on OS and Java Enterprise Edition application servers that are supported by the Oracle SOA Suite.

OSB11g Project Export and Import?

2013-08-26T23:43:00.001-07:00

Importing and Exporting the OSB Project from One Environment to Other Environment:

We needs to propagate OSB Configurations from one environment to another environment..

We can’t export users,groups,roles using JAR file..needs to use web logic admin console to do this…

To Export Project needs to follow below steps:

IMPORTANT POINTS TO BE REMEBERED WHEN EXPORTING PROJECT:

In Export Resources we are exporting using option EXPORT PROJECT; we should not check INCLUDING DEPENDENCIES option.
This option needs to be checked when we are exporting using EXPORT RESOURCES OPTION.
Needs to export projects outside session, to export complete project. We should not export project with starting new session

IMPORTING PROJECT IN ANOTHER ENV:

To import project needs to be start new session in OSB Console.

Example For Create,Insert,Delete Commands in Oracle.

2013-08-26T05:08:00.002-07:00

Below are the scripts to create,insert and delete with example:

Step1: Creating Product Taable:

Script Used to Crate the table:

CREATE TABLE Product

(

ProductID varchar(100) NOT NULL,

ProductName varchar(50) NOT NULL,

ListPrice varchar(50),

Category INT NOT NULL,

PRIMARY KEY (ProductID)

);

Below is the structure for Created Product table:

Script Used: describe Product;

Step2: Inserting values into Product Table:

Example:

Script used to insert the values into Product table:

INSERT INTO Product

(ProductID,ProductName,ListPrice,Category)

VALUES

(300,'Wave Cruiser','$49.99',11)

Checking for values successfully inserted in Product table:

Scripts to insert all values:

Script to Insert Values one by one column:

1) INSERT INTO Product

(ProductID,ProductName,ListPrice,Category)

VALUES

(299,'Chest','$99.99',10);

2)INSERT INTO Product

(ProductID,ProductName,ListPrice,Category)

VALUES

(300,'Wave Cruiser','$49.99',11);

3)INSERT INTO Product

(ProductID,ProductName,ListPrice,Category)

VALUES

(301,'Megaland Play Tent','$59.99',11);

4)INSERT INTO Product

(ProductID,ProductName,ListPrice,Category)

VALUES

(302,'Wind-Up Water Swimmer','$2.99',11);

5)INSERT INTO Product

(ProductID,ProductName,ListPrice,Category)

VALUES

(303,'Garmin Pocket or Vehicle GPS Navigator','$609.99',12);

Below are the list of values inserted in table:

Step3: Update the name of a product whose ID is 299 to "Small Chest"

Script Used for update:

update Product set ProductName ='Small Chest' where ProductID=299;

To check for product successful update:

select * from product where ProductID=299;

Step4: Select all unique categories from product table.

Script Used:

select distinct(Category)from Product;

Sep5: Delete all products in category 12

Script Used: delete Product where Category=12;

Check for table for successfully deleted row:

Step6: Create view Product_Category11 that will include only products from category 11

Script used for creation of VIEW:

CREATE OR REPLACE VIEW Product_Category11 AS

SELECT *

FROM Product

WHERE Category=11;

Checking the values in view:

Step7: Display all products fromCategory11

select * from Product where category=11

What are the files creates when DBAdapter Configuration complete in Jdev?

2013-07-19T05:23:00.002-07:00

Once the DBAdapter Configuration complete below files will be create:
1. <ServiceName>.wsdl
2. <ServiceName>_table.xsd
3. <ServiceName>_or-mappings.xml
4. <ServiceName>_db.jca
5. <ServiceName>.properties

What is the basic step to troubleshoot the DBAdapter?

2013-07-19T05:21:00.002-07:00

1. The basic step to troubleshoot the adapter is to set the oracle.soa.adapter logger level to Trace: 32(FINEST) in the FMW Console.

2. Once this configuration is done, reproduce the issues and check the SOA Manager Server log fileMW_HOME/user_projects/domains/<domain_name>/servers/<soa-server>/logs/soa-diagnostic.log …Look for JCABinding and BINDING.JCA-xxxx strings and take actions accordingly.

What are Mimimum Age, TriggerFilePhysicalDirectory and TriggerFile?

2013-07-18T04:29:00.002-07:00

MinimumAge – This parameter specifies the minimum age of files to be retrieved. This enables a large file to be completely copied into the input directory before it is retrieved for processing. The age is determined by the last modified time stamp

TriggerFilePhysicalDirectory- The directory path where the Oracle File or FTP Adapter looks for the trigger files.

TriggerFile-The name of the trigger file that activates the inbound Oracle File or FTP Adapter

About SOA 11g MDS Repository?

2013-07-18T01:08:00.000-07:00

About SOA 11g MDS Repository:

1. MDS Facilitates greater re-use of SOA artifacts such as XML Schemas,WSDLs,FaultPolicies,Rule repositories and Service Data Objects(SDOs) among others..

2. MDS can be File based or Database based.

Below are the steps to create MDS in Jdeveloper.
3. MDS is created under <jdeveloper-home>/integration/seed directory.

4. Default folder “soa” is used to store common system soa artifacts.

5. All custom artifacts are supposed to be stored under a folder called “apps”, since this folder already exists in server.

6. Deploy MDS Repository to Weblogic Server.

First, we need to create JAR file bundle to include schemas we need. Then we need to include this jar file into a SOA bundle that can be deployed to the SOA Server.

Step1: Create Generic Application – MediatorMetaData
In Jdev àApplication àGeneric Application àSay “OK”….Give Application Name as “MediatorMetaData” and choose Directory.

Step2: Create project as “MediatorLib” and choose Directory.

Step3: Right Click on MediatorLib and select NewàDeployment Profile àJAR File.

Step4: Enter mediatorlib as the deployment profile name.

Step5: In the JAR deployment properties dialog, click on Contributors, click on Add button and select appsdirectory from JDeveloper seed location – <jdeveloper_home>/integration/seed/apps and say “OK”.

Step6: Click on Filters and select the schemas you would like to be deployed.
Click on OK. This completes creation of JAR file. We now need to create an application deployment profile to install these schemas in SOA Server.

Step7: Right click on MediatorMetaData application and select Deploy –> New Deployment Profile. Select “SOA Bundle” as Profile type.

Step8: Enter mediatorlib for Deployment Profile Name. From the properties dialog, open Dependencies and select mediatorlib.

Step9: To deploy MediatorLib to SOA Server, right click on MediatorMetaData and select Deploy –> mediatorlib.

When deploying soa components into to a cluster in soa 11g using ant do we need to deploy in 2 nodes (if we have 2 node environments)?

2013-04-08T08:15:00.000-07:00

As per my knowledge, we don't need to do any additional configurations for this and not required to deploy in 2 nodes.

Used developed ant scripts for non-clustered environments also work in clustered environment also. If deploy the codes in single node soa_server1. The default coherence rule of Web logic replicates the deployment to all the nodes under a cluster; hence it was deployed to second soa_server2 instance automatically.

About Signal Activity and Receive Signal Activity?

2013-04-08T07:56:00.000-07:00

1. Signal and Receive Signal Activities are used to coordinate master and detail processes in a BPEL process.This coordination enables you to specify the tasks performed by a master BPEL process and its related detail BPEL processes. This is sometimes referred to as a parent and child relationship.

2. Master and detail coordinations consist of a one-to-many relationship between a single master process and multiple detail processes.

3. The following BPEL process activities coordinate actions between the master and detail processes:

· signal: notifies the other processes (master or detail) to continue processing

· receive signal: waits until it receives the proper notification signal from the other process (master or detail) before continuing its processing

In simple words:

Signal Activity in BPEL is used in a master process to notify detail processes to perform processing at runtime and used in detail processes to notify a master process that processing has completed.

Receive Signal activity in detail processes to wait for the notification signal from the master process to begin processing and use in a master process to wait for the notification signal from all detail processes indicating that processing has completed.

If A...	Contains A...	Then...
Master process	Signal activity	The master process signals all of its associated detail processes at runtime.
Detail process	Receive signal activity	The detail process waits until it receives the signal executed by its master process.
Detail process	Signal activity	The detail process signals its associated master process at runtime that processing is complete.
Master process	Receive signal activity	The master process waits until it receives the signal executed by all of its detail processes.

XA and Non-XA Transaction?

2013-04-06T06:42:00.002-07:00

Location of fault policy file (fault-policies.xml) and fault policy bindings file (fault-bindings.xml)?

2013-04-06T04:42:00.001-07:00

1. In the same directory as the composite.xml file of the SOA composite application.

2. In a different location that is specified with two properties that you add to the composite.xml file. This option is useful if a fault policy must be used by multiple SOA composite applications. This option overrides any fault policy files that are included in the same directory as the composite.xmlfile, the fault policy files are placed into the SOA Metadata Service (MDS) shared area.

Difference between Abstract wsdl and Concrete wsdl?

2013-04-06T04:16:00.001-07:00