Follow Up to SOA 11g Database Guide Webcast
By MariaSalzberger on Apr 18, 2012
The presentation recording can by found here
The schedule for future webcasts can be found here
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 126.96.36.199)
Q. I am working on an 11g upgrade (188.8.131.52.0 -> 184.108.40.206.0), and reviewing the 220.127.116.11.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 18.104.22.168 to 22.214.171.124, the tool to do this is called Patch Set Assistant (PSA). After upgrading your software installation to 126.96.36.199, 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 188.8.131.52 to 184.108.40.206. 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:
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.