Follow Up to SOA 11g Database Guide Webcast

On April 11th I presented a webcast talking about the SOA Suite 11g database guide. This post is a follow up to answer the questions asked and also provide the link for the presentation recording.

The presentation recording can by found here
(https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=ANNOUNCEMENT&id=740964.1)

The schedule for future webcasts can be found here
(https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=ANNOUNCEMENT&id=740966.1)

Questions


Q. I've just finished setting up partitioning for our SOA installation. My question is if we drop a partition for BRDECISIONINSTANCE table for example, how do we avoid violating constraints and FKs?

A. This is answered in the following documentation:

- Referential Integrity and Equipartioning (version 11.1.1.6)
(http://docs.oracle.com/cd/E23943_01/admin.1111/e10226/soaadmin_partition.htm#autoId3)


Q. I am working on an 11g upgrade (11.1.1.3.0 -> 11.1.1.5.0), and reviewing the 11.1.1.5.0 documentation, I do not explicitly see information on running the RCU for the BAM schema, so does this mean that there is no requirement to upgrade BAM in this version?

A. With RCU you would create new and empty schemas. As you want to upgrade your schemas from 11.1.1.3 to 11.1.1.5, the tool to do this is called Patch Set Assistant (PSA). After upgrading your software installation to 11.1.1.5, you would then use PSA to upgrade the schemas. I would recommend to check the related section in the guide 1384379.1:

Upgrade --> Updating SOA Schemas from 11g to a Later Patch Set
Check this section to understand the update process.
Then check the km document linked from there - Note 1325406.1 - Updating Repository Schemas for Oracle Fusion Middleware 11g with Patch Set Assistant (PSA) [Video]
This document has a video that explains step by step how to run PSA and what to do to update the schemas.

Finally, before actually running PSA, check section Which Schemas and Objects Need to be Upgraded? in the guide 1384379.1 to understand which schemas need to be updated if updating from 11.1.1.3 to 11.1.1.5. This information is available in the documentation linked from the guide.


Q. Is there also a way to programatically terminate long running composites? We have to many to manually terminate them?

A. These instances need to be terminated either manually in EM or via the API. Information is available in KM note 1400612.1 - How to Purge Active Instances ("Running" / "Recovery Needed" State) in the SOA Application.


Q. Q: I want to know basic to SOA. Can you send some links or doc id for basics of SOA?

A. This link to the Oracle SOA Suite, Business Process Management Suite, and Web Services Documentation Library is a good starting point:

http://docs.oracle.com/cd/E23943_01/soa.htm.


Q. How can we delete long running instances that will never complete?

A. These instances need to be terminated either manually in EM or via the API. Information is available in KM note 1400612.1 - How to Purge Active Instances ("Running" / "Recovery Needed" State) in the SOA Application


Thank you to everyone who attended and to anyone who views the recording. If there are further questions or discrepancies please add a comment to this post for update.
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

This is the official blog of the SOA Proactive Support Team. Here we will provide information on our activities, publications, product related information and more. Additionally we look forward to your feedback to improve what we do.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today