SOA 11g SOA Infra DB states for SOA Composites and Components

12
June
2013

I found this extremely useful list of states for SOA 11g composites and various components in the SOA INFRA DB which we have benefited greatly in various engagements, so I thought it was worth sharing with you all. COMPOSITE_INSTANCE States State Description 0 Running 1 Completed 2 Running with faults 3 Completed with faults 4 […]

07
March
2013

By Nits
Best Practices, BPEL, ESB, Mediator, Oracle, OSB, Singleton, SOA
Comments Off on Duplicate instances when using DB adapter in high availability environment.

Many a times I have noticed that when you use DB Adapters (SOA Suite 11g) for integrating with applications like the E Business Suite in a clustered high availability environment, at times there will be multiple instances for the same request. The number of instances each entry in the DB would generate would directly correlate […]

01
March
2013

By Nits
BPEL, SOA
Comments Off on SOA 11g – Useful SOA Infra DB Queries [Advanced users]

Sometimes you want to identify all the faults for the messages that were sitting in BPEL Engine Level recovery as undelivered Invokes. We can run this SQL on the SOA Infra Schema to obtain this info. select wif.* FROM WI_FAULT WIF WHERE wif.cikey IN (SELECT ci.cikey FROM Dlv_Message dlv, cube_instance ci WHERE dlv.State = 0 AND […]

07
February
2013

By nitin
Best Practices, ESB, Oracle, OSB, SOA, Web Services
Comments Off on Performace Tunning with OSB – RouterRuntimeCache and Proxy initialisation

As your project grows and the number of proxy services you have in the project grows significantly (>100) you might notice that the performance of the services degrades heavily. This can be attributed to the face that the OSB is now unable to Cache all your services at runtime. OSB caches proxy service runtime meta-data […]

05
October
2012

Problem: I am having an issue while trying to connect to my remote OSB server from my eclipse IDE installed as per instructions on oracle blog as per my previous post. I am running the prebuilt Oracle VBox Images for SOA 11.1.1.6.0 Downloaded from http://www.oracle.com/technetwork/middleware/soasuite/learnmore/vmsoa-172279.html Configured it for SOA_OSB_DEV Domain and started the servers which […]

31
May
2012

We have created a list of Useful WLST commands for SOA covering how we can use the WLST commands to retire/shutdown/start/activate/deploy/undeploy a composite. Use the scripts located at: (UNIX) MIDDLEWARE_HOME/ORACLE_SOA1/common/bin/wlst.sh (Windows) C:oracleMiddleware11116Oracle_SOA1commonbinwlst.cmd Note: Do not use the WLST script in the WebLogic Server home. In case you use the WLS tool from MIDDLEWARE_HOMEoracle_commoncommonbin Or from MIDDLEWARE_HOME wlserver_10.3commonbin It will throw following error. Traceback (innermost last): File […]

18
May
2012

By nitin
SOA
Comments Off on SOA 11g Composite states and behavior

Useful composite states and the behaviour for reference. Composites Table The Composites table enables you to manage the state of a selected SOA composite application. All actions in this table, except Deploy, require you to select a row in the table. Element Description Shut Down Shuts down a running SOA composite application revision. Any request (initiating or a […]

23
March
2012

By nitin
AIA, BPM, ESB, OER, OESB, SOA
Comments Off on Start Small, Grow Fast

A really useful post by Edwin, Ronald and Demed Start Small, Grow Fast. Start Small, Grow Fast by Edwin Biemond, Ronald van Luttikhuizen, and Demed L’Her A set of pragmatic best practices for deploying a simple and sound SOA footprint that can grow with business demand. Published January 2012 Table of Contents Administrative considerations Does your […]

01
December
2011

By nitin
OER, SOA
Comments Off on Oracle Enterprise Repository – Admin Account locked.

I came across this situation where my admin account for OER got locked, So I could not get on the management screen to rectify this and was pretty much stuck. Solution: Follow these Steps to unlock user Accounts(including admin account) in OER: Stop the OER server if running. Log onto your DB server and log […]

10
November
2011

By admin
SOA
Comments Off on Oracle JCA Adapter for Database

Distributed Polling First Best Practice: SELECT FOR UPDATE (SKIP LOCKED) via Oracle JCA Adapter for Database.

Category Archives: SOA

Duplicate instances when using DB adapter in high availability environment.

SOA 11g – Useful SOA Infra DB Queries [Advanced users]

Performace Tunning with OSB – RouterRuntimeCache and Proxy initialisation

OSB: Remote Server Connection Issue from OEPE

Useful WLST Scripts – Managing composite state using command line WLST

SOA 11g Composite states and behavior

Start Small, Grow Fast

Oracle Enterprise Repository – Admin Account locked.

Oracle JCA Adapter for Database

Recent Posts

Recent Comments

Archives

Categories

Meta

Recent Posts

Recent Comments

Archives

Categories

Meta

Categories

Recent Posts

Meta

Search Site