OIC, Oracle SOA, OSB, Weblogic

Main tables used by the BPEL engine cube_instance – stores instance metadata, eg. instance creation date, current state, title, process identifier cube_scope – stores the scope data for an instance … all the variables declared in the bpel flow are stored here, as well as some internal objects to help route logic throughout the flow. work_item – stores activities created by an instance … all BPEL activities in a flow will have a work_item created for it. This work item row contains meta data for the activity … current state, label, expiration date (used by wait activities) … when the engine needs to be restarted and instances recovered, pending flows are resumed by inspecting their unfinished work items. document - stores large XML variables. If a variable gets to be larger than a specific size (configurable via the largeDocumentThreshold property via the domain configuration page) then the variable is stored in this table to alleviate loading/saving time from t

Introduction to the Oracle AQ Adapter: Oracle Streams Advanced Queuing (AQ) provides a flexible mechanism for bidirectional, asynchronous communication between participating applications. Advanced queues are an Oracle database feature, and are therefore scalable and reliable. Other features of Oracle database, such as backup and recovery (including any-point-in-time recovery), logging, transactional services, and system management, are also inherited by advanced queues. Multiple queues can also service a single application, partitioning messages in a variety of ways and providing another level of scalability through load balancing. Oracle AQ Adapter Features : The Oracle AQ Adapter is both a producer and a consumer of AQ messages. The enqueue operation is exposed as a JCA outbound interaction. The dequeue operation is exposed as a JCA inbound interaction. The Oracle AQ Adapter supports ADT (Oracle object type), XMLType , and RAW queues as payloads. It also supports extr

AIA 11.1.1.6.0 Installation Install AIA 11.1.1.6.0 from scratch: Undoubtedly, it was a little challenge while trying to install AIA 11.1.1.6.0. Firstly the long Installation guide and very generic error descriptions leave you nothing but perplexed, secondly, our OS being Windows 7 adds fuel to the fire. But, despite all the odds, what matters most is that AIA 11.1.1.1.6.0 runs successfully. However, just to save the time of world's greatest developers, I'm writing this document to give some of the tips and tricks that I found while installing in my machine. Below are the steps that I followed to install AIA: 1. Install Oracle Database 11g (Express Edition). Download the Oracle database installable as zip file and extract that file into a directory. Run the setup file (Don’t forget to Run as administrator). Proceed with the steps and after successful installation check the database console http://<host-name>:8080/apex/f?p=4950 2. Create