SOA integrated with EBS R12.2.X doc

HI,

here is the doc for SOA Intigration with EBS R12.2.X ..

Doc ID 1311068.1

Part A: Configuring Oracle E-Business Suite SOAP Services

Section 1: Configuring Oracle E-Business Suite Integrated SOA Gateway for SOAP Services on a New Installation of Release 12.2.3 or Higher

Thnaks
Srini

SOA ADMINISTRATION Index

Learn To:

·          Install Oracle SOA Suite 11g

·          Deploy SOA Composite Applications

·          Configure and Administer Oracle SOA Suite 11g and its components

·          Monitor, troubleshoot, and tune Oracle SOA Suite 11g components

·          Configure Security Policies for SOA Composite applications

·          Backup and recover Oracle SOA Suite 11

ORACLE SOA SUITE 11G: ADMINISTRATION CONTENT DETAILS

Introducing SOA and Oracle SOA Suite 11g

·          Introducing Oracle SOA Suite 11g Administration Tools

·          Describing Service-Oriented Architecture (SOA) Concepts

·          Introducing Service Component Architecture (SCA) Composite Applications

·          Describing Oracle SOA Suite 11g Architecture and Components

·          Configuring Oracle SOA Suite 11g SOA Infrastructure Properties

Installing Oracle SOA Suite 11g SOA

·          Exploring Oracle Enterprise Manager Fusion Middleware Control Console

·          Configuring an Oracle WebLogic Domain with SOA Suite 11g Components.

·          Creating SOA Schemas with the Repository Creation Utility.

·          Installing Oracle SOA Suite 11g.

Managing SOA Composite Applications

·          Managing Composite Application Life Cycle

·          Deploying Composite Applications

·          Testing and Monitoring Composite Applications

·          Describing Composite Application Structure and Dependencies

Administering the SOA Infrastructure

·          Monitoring SOA Infrastructure Run-time Information

·          Configuring Oracle SOA Suite 11g SOA Infrastructure Properties

Administering Human Task Service Components and Human Workflow Service Engines

·          Describing User Messaging Preferences Preferences

·          Configuring Human Workflow Task Service Properties

·          Exploring the Work list Application for Task Management Application

·          Describing Human Workflow Components and Service Engine

·          Configuring the Human Workflow Services

Administering Oracle BPMN Process Service Components and Engines

·          Monitoring Oracle BPMN Process Service Components and Engines

·          Describing BPMN Process Service Components and Engines

·          Configuring BPMN Process Service Components and Engines

Administering Oracle Business Activity Monitoring

·          Describing Oracle BAM Components and Architecture

·          Configuring the Oracle BAM Adapter

·          Configuring Oracle BAM Server Properties

·          Managing Oracle BAM Users and Distribution Lists

·          Monitoring BAM Activity and Components

Administering Oracle B2B

·          Monitoring B2B Messages in Oracle B2B Console

·          Testing a B2B Implementation

·          Describing the B2B Components and Concepts

·          Configure a B2B Implementation

·          Describing the B2B Console and Administration Tasks

Administering Business Events

·          Monitoring Business Event Occurences

·          Describing Business Events

·          Describing the Event Delivery Network Architecture

·          Managing Business Event Subscriptions

Administering Oracle JCA Adapters and Binding Components

·          Monitoring JCA Adapter Instances and Faults

·          Describing JCA Adapters and Binding Components

·          Configuring JCA Adapter Properties

·          Configuring File, Database, and JMS JCA Adapter Run-time Resources

Administering BPEL Process Service Components and Engines

·          Managing BPEL Process Component Instances and Faults

·          Describing BPEL Components and Service Engine

·          Configuring BPEL Service Engine Properties

·          Tracking Messages in a Composite Application With a BPEL Process

·          Monitoring BPEL Process Component Instances

Administering Oracle Mediator Service Components and Engines

·          Monitoring Mediator

·          Describing Mediator Components and Service Engines

·          Configuring Mediator Service Engine Properties

·          Managing Mediator Faults

·          Component Instances and Routing Information

Administering Decision Service Components and Business Rules Service Engines

·          Monitoring Business Rules Service Engine Instances and Faults

·          Describing Decision Services and Business Rules Service Engines

Administering Oracle User Messaging Service

·          Testing UMS Services

·          Describing User Messaging Service (UMS) Architecture and Components

·          Configuring UMS for Human Workflow and BPEL Process Components

·          Configuring Oracle WebLogic Server Embedded LDAP Server

·          Configuring the Email Messaging Driver

Configuring Security Services and Policies

·          Describing Oracle Web Services Manager Functionality

·          Describing Web Service Security Concepts

·          Creating a Simple Web Service Security Policy

·          Securing a Service Endpoint with the Security Policy

·          Monitoring Web Service Security Violations

Tuning Performance of Oracle SOA Suite and Components

·          Implementing Best Practice Starting and Stopping Managed Servers

·          Extending SOA Database Table spaces

·          Managing connection thresholds

·          Optimizing Loading of Enterprise Manager Metric Page Information

·          Purging data from Dehydration Store

Troubleshooting Oracle SOA Suite

·          Resolving Managed Server Startup Problems

·          Managing Connection Timeouts

·          Identifying Log Files

·          Configuring Log Levels

·          Viewing Log File Entries

·          Identifying and Resolving Common Application Problems

Configuring High Availability for Oracle SOA Suite

·          Describing Types of High Availability Options

·          Describing High Availability Implementations

Backing Up and Recovery of Oracle SOA Suite Instances

·          Adopting a Backup and Recovery Strategy

·          Backing Up Oracle Fusion Middleware Environments

·          Backing Up the SOA Database Schemas

·          Recovering Oracle Fusion Middleware Environments

·          Recovering SOA Database Schemas
 Thanks 
Srini

SOA Upgrade 11.1.1.3 -> 11.1.1.6

 

We upgraded our SOA install from 11.1.1.3 to 11.1.1.6 and hit a few issues.   One of the main issues was that after upgrading DEV our inflight processes disappeared.    We talked back and forth with Oracle and it was supposed to be supported but for some reason it wasn't working for us.    I know that from SOA 10g to SOA 11g in-flight processes are not supported as part of the upgrade.

One of the ways we use BPEL is workflow for a custom application.  It could take months for a workflow to complete and there are always in-flight processes.    So there is never a quiet time, or a point at which all workflows are complete to do the upgrade.

We put a plan in place to manually re-place all items back in the proper stage.    It seems like it was going to be a fair amount of effort so for DEV we only re-placed a subset of items to make sure we had the process correct.

However, once we upgrade TEST the in-flight processes somehow magically survived.    We aren't sure why, there could be some small inconsistencies between DEV and TEST which caused it.  Another reason could be that in DEV we upgraded to 11.1.1.6 first, then at a later point upgraded to 11.1.1.6.6.   In TEST we went directly to 11.1.1.6.6.

The SOA upgrade itself isn't a very resilient process.   If the PSA (Patch Set Assistant) gets interrupted for some reason its not smart enough to recover.  In DEV it wasn't a big issue, I had an export of the MDS and SOAINFRA schemas and I just dropped and recreated.    For PROD tho, the amount of data, thus downtime, would prevent us from doing this.    We only hit an issue once in DEV and TEST was smooth,  so for PROD we all had our fingers cross.

The PROD install was going smoothly until I had to run the PSA.     Shortly after I started the schema upgrade it failed and a dreaded error appeared.  In the $FMW_HOME/oracle_common/upgrade/logs directory I found:


[2013-08-21T19:28:09.239-04:00] [SOA] [ERROR] [] [upgrade.SOA.SOA1] [tid: 13] [ecid: 0000K2ZD5BJ9lZWpPws1yd1I5Klw000004,0] [[
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

The problem was a database session holding a lock in the SOAINFRA schema.   We hit this problem in DEV and the solution was to shutdown applications that access SOAINFRA tables and change the schema password.   However, I didn't notice a hung database session by one of our custom applications.

If you try to run the PSA again it says the SOAINFRA schema isn't valid and won't let you continue with the upgrade.   So I tried manually updating the registry to state the schema is valid.

update schema_version_registry set status='VALID' where mr_name='SOAINFRA';

Great!  The installer started up again but it quickly failed.  Checking the logs:

2013-08-21 19:36:19.378 rcu:Extracted SQL Statement: [ALTER TABLE BPM_CUBE_PROCESS ADD (SubType VARCHAR2(200), DeploymentInfo BLOB)]

2013-08-21 19:36:19.378 rcu:Statement Type: 'DDL Statement'

JDBC SQLException - ErrorCode: 1430SQLState:72000 Message: ORA-01430: column being added already exists in table

Since this was production, I opened a P1 SR with Oracle right away.   In these situations I try to get Oracle involved as quickly as possible.   I'll still continue to do research on my end.  Sometimes I find the solution quicker, sometimes Oracle Support does.   

This time I found the following note:

Patch Set Assistant Failed for SOA 11.1.1.6.0 when Patch 13606871 is Applied on SOA 11.1.1.5.0 (Doc ID 1517404.1)

It provided a set of SQL statements to help rollback the schema upgrade.  Only problem was my upgrade was from 11.1.1.3, not 11.1.1.5.    Knowing that Oracle now supported manually rolling back the upgrade, then I looked at the script that was failing:

/u01/app/oracle/product/fmw11g_SOA/SOAHome_1/rcu/integration/soainfra//sql/upgrade_soainfra_111130_111140_oracle.tsql

After a few trial and errors I managed to write a script to undo all the changes.     Unfortunately if you missed one, which was easy to do as the script is a few thousand lines, you had to start over.   Finally I managed to find all updated objects and continued with the upgrade.

Another upgrade issue I encountered showed itself in the startup logs for soa_server1:

java.sql.SQLException: ORA-25226: dequeue failed, queue UPG_SOAINFRA.EDN_OAOO_QUEUE is not enabled for dequeue

The solution to this problem was to manually restart the queues:

SQL> show user
USER is "UPG_SOAINFRA"
SQL> exec dbms_aqadm.start_queue('IP_OUT_QUEUE',true,true);
PL/SQL procedure successfully completed.
SQL>  exec dbms_aqadm.start_queue('EDN_OAOO_QUEUE',true,true);
PL/SQL procedure successfully completed.

After the startup we waited anxiously to hear from the superusers to let us know the status of in-flight processes.    To much celebration (more so from them than us since they had alot of potential work to do) in-flight processes did not disappear.

 

Thanks

Srini