ESB CONTROL TAKES LONG

Recently I have experienced that esb control taking to long to display services. Oracle has confirmed this as a bug when you have got a lot of BPEL process and you can get around this by adding a LazyLoad parameter to esb_config.ini file.

This has been reported by oracle as a bug 7720420

Adding the esb.console.services.lazyLoad.Allowed=true property to $OARCLE_HOME/integration/esb/config/esb_config.ini and restarting the services fixed the issue.

Oracle fusion middleware components and architecture

Oracle fusion middleware architecture overview

Oracle fusion middleware components

Singleton adapters issues in HA

Recently I  faced with the issue of Singleton (non-concurrent) adapters in HA (clustered environment). Two instances were created for a single file that resulted in a file will be processed twice.

Singleton adapters can not run in active-active configuration. For this type of adapters you must make sure there is only one adapter instance active at runtime independent of the number of clusters you have. This effectively means you will only have one non-concurrent adapter at runtime. If this active adapter fails, one of the passive adapter becomes active.

There are a lot resources in metalink that you will be able to use. I have listed some of them below.

How to Enable a Singleton Adapter in an ESB Cluster Environment

How to Enable a Singleton Adapter in BPEL Cluster Environment

How to Setup FileAdapter in Cluster for High Availability
and more can be found on metalink.

Oracle Fusion Middleware 11gR1 Software Downloads

All Oracle Fusion Middleware 11gR1 Software Downloads can be found at Oracle Fusion Middleware 11gR1

Delete single or multiple esb instance

From time to time you may need to delete stale esb instances. I had difficulty in finding a script that does it. But actually you can use oracle provided purge scripts and modify to be used only for single or multiple instance deletion. See scripts below it will delete single esb instance

DELETE FROM ESB_ACTIVITY
WHERE ID IN
(SELECT ID
FROM ESB_ACTIVITY A
WHERE EXISTS
(SELECT FLOW_ID
FROM ESB_ACTIVITY B
WHERE Flow_id = 'instance Id'
AND A.FLOW_ID = B.FLOW_ID));



DELETE ESB_TRACKING_FIELD_VALUE
WHERE ACTIVITY_ID IN
(SELECT ID
FROM ESB_ACTIVITY A
WHERE EXISTS
(SELECT FLOW_ID
FROM ESB_ACTIVITY B
WHERE Flow_id = 'instance Id'
AND A.FLOW_ID = B.FLOW_ID));

--

DELETE FROM ESB_FAULTED_INSTANCE
WHERE ACTIVITY_ID IN
(SELECT ID
FROM ESB_ACTIVITY A
WHERE EXISTS
(SELECT FLOW_ID
FROM ESB_ACTIVITY B
WHERE Flow_id = 'instance Id'
AND A.FLOW_ID = B.FLOW_ID));

--

DELETE FROM ESB_TRANSACTION_STATUS
where Flow_id = 'instance Id'

--

DELETE FROM ESB_INSTANCE_RELATION_XML
WHERE FLOW_ID IN
(SELECT FLOW_ID
FROM ESB_ACTIVITY A
WHERE EXISTS
(SELECT FLOW_ID
FROM ESB_ACTIVITY B
WHERE Flow_id = 'instance Id'
AND A.FLOW_ID = B.FLOW_ID));

--

DELETE FROM ESB_RELATION_XML A
WHERE NOT EXISTS
(SELECT RELATION_XML_ID
FROM ESB_INSTANCE_RELATION_XML);

--

DELETE ESB_SERVICE_RELATION
WHERE RELATION_XML_ID IN
(SELECT ID
FROM ESB_RELATION_XML
WHERE NOT EXISTS
(SELECT RELATION_XML_ID
FROM ESB_INSTANCE_RELATION_XML
WHERE ID = RELATION_XML_ID));
commit;

Compare Weblogic and Oracle Application Server

Few not long list but will help in understanding SOA on application server and weblogic. To find more click this blog Compare Weblogic and Oracle Application Server

FEATURE MATRIX

A useful comparison of feature matrix of oracle weblogic server standard edition 11g, oracle weblogic server enterprise edition 11g and oracle weblogic suite 11g can be found at FEATURE MATRIX.
On one of the line Oracle Application Server: for customers running existing environments on this application server, complete access and use rights to oracle weblogic suite 11g. Does this mean it is possible to upgrade to weblogic 11g from apps server 11 g ? again wait and see.

Understand hidden parms for corruption recovery

Burleson explains that many Oracle DBA staff are not aware of special hidden parameters that allow you to open a corrupt database

These parameters allow you to ignore corrupt data blocks when your database is corrupted. These should only be used in emergencies. The following are direct copy from his post.

_allow_resetlogs_corruption - This parameter may be the only way to start a db backed-up open without setting backup on tablespaces, it will result in an unsupported system.

_corrupted_rollback_segments - The only way to start up with corrupted public rollback segments. This undocumented parameter can be used without fear of invalidating support.

_allow_read_only_corruption - This parameter allows the database to be opened even if it has corruption. This should only be used to export as much data from a corrupted database as is possible before re-creating a database. A database that has been opened in this manner should not be used in a normal manner, as it will not be supported.

_corrupt_blocks_on_stuck_recovery – This parameter can sometimes be useful for getting a corrupted database started. However, it probably won't be supported if done without Oracle's blessing. Immediately export the tables needed and rebuild the database if used.

Oracle Fusion Middleware 11g conference

The launch of oracle fusion middleware 11G was held on july 2nd 2009 in Hilton London Paddington.

Keynote :
Charles Philips, President, Oralce
Thomas Kurian, Senior vice president, Oracle Development.
The main components discussed were
- Oracle SOA suite 11G
- Oracle WebCenter suite 11G
- Oracle WebLogic Suite 11G
- Oracle Identity management
- Oracle Fusion middleware for various sectors.

The conference was exciting and there were no much marketing. My expectation was that as it always been the morning session normally have a lot of marketing than substance but in this occasion it was all about the product.

Some of eye catching stuff that I have come accross are:

Weblogic server --> this has brought a lot of question to my mind. Are those who are on Application server 10 will be able to upgrade with no extra cost.It was vague and will still remain like that until the time come when oracle decides. It seems that oracle have put a lot of money and time on getting this product right. You wouldn't know what the issues will be until you actually use it but from what I have seen it is a wonderful product.

Oracle JRocket real time :

Oracle claims that JRockit Real Time is the industry’s fastest real-time solution for standard Java and the only one with average microsecond response performance. It guarantees a five nines maximum garbage collection latency on the order of one millisecond. JRockit uses deterministic garbage collections . Oracle datasheet also claims that JRocket can help you in predicting latency and extreme performance, zero coding when you swap JVM and advanced monitoring tools.

Oracle WebLogic Real Time is also the version of Oracle JRockit Real Time offered exclusively with Oracle WebLogic Suite. JRockit seems to run on unix like (Liunx) platforms and windows (both 32 and 64 bits)

New Jdeveloper :

Looks very promising. It reminds me of when Microsoft launched .Net framework. Oracle have revamped this products with many added features. To just mention few ability to use any source control, collaboration with your colleagues , assigning tasks, drag and drop capability is highly improved. There are more to it than mentioned her.

SOA suite 11 : it will run on weblogic server 11 and it looks like it is going to stay that way.

Application grid is also mentioned which again could improve application performance.

Last but not least the lunch was fantastic. For those who stayed behind there was also drinks (cool !!!!!!!!!)