Thursday, February 23, 2012

Oracle FMW 11.1.1.6 (Patch Set 5) Released

All,

This should be a good news to many, Oracle released its latest version of Oracle FMW 11g family.


The complete release of Oracle Fusion Middleware 11R1 (11.1.1.6.x). includes the following products:
  • Oracle WebLogic Server 11g R1 (10.3.6)
  • Oracle SOA Suite 11g R1 (11.1.1.6.0)
  • Oracle Business Process Management 11g R1 (11.1.1.6.0)
  • Oracle Complex Event Processing 11g R1 (11.1.1.6.0)
  • Oracle Service Bus 11g R1 (11.1.1.6.0)
  • Oracle Enterprise Repository 11g R1 (11.1.1.6.0)
  • Oracle Service Registry 11g R1 (11.1.1.6)
  • Oracle Application Integration Architecture Foundation Pack 11g R1 (11.1.1.6.0)
  • Oracle Data Integrator 11g R1 (11.1.1.6.0)
  • Oracle WebCenter Portal 11g R1 (11.1.1.6.0)  (previously known as Oracle WebCenter Suite)
  • Oracle WebCenter Content 11g R1 (11.1.1.6.0) (previously known as Oracle Enterprise Content Management)
  • Oracle Identity Management 11g R1 (11.1.1.6.0)
  • Oracle Forms, Reports, Portal & Discoverer 11g R1 (11.1.1.6.0)
  • Oracle Traffic Director 11g R1 (11.1.1.6)
  • Oracle Repository Creation Utility 11g R1 (11.1.1.6.0)
  • Oracle JDeveloper & Application Development Framework 11g R1 (11.1.1.6.0)
The 11.1.1.6 documentation is available here

To download the new release from OTN visit here.

I would soon try and post on some bug fixes we have on WLS/SOA Suite. For now you can go through the Product release document here

Sunday, February 12, 2012

Follow Us On Facebook and Stay In Touch....

Please login through you facebook account and help vote for the posts you would like to see...Additionally you can post your comments on our wall about any other topics you would like to read...

You can use the facebook like button on the right hand side of our blog to follow us...




Now you can folow us on facebook and post your comments/views and questions for expert advise. Check this out facebook


Find us on facebook here

Thursday, February 2, 2012

How to find out number of BPEL instances in SOA 11g dehydration store?

A common task for fusion admins would be to find out the number of BPEL instances in the SOA dehydration store,the SOA database. Basically this information is stored in a table called COMPOSITE_INSTANCE and the owner of the table id DEV_SOAINFRA schema.

There are two major ways of doing it:

1. From EM Console

For finding out the instance count from EM console:

a. Login to the SOA 11g EM console and expand the SOA folder on your left.This is shown below. Click on the soa-infra

b. On the right hand side of the screen click on Number of Instances as shown below:


c. The number of instances is displayed as shown below:





2. Select query on SOA dehydration table

 For finding out the number of BPEL instances in your SOA 11g Dehydration using SQL query follow  below steps:

a. Login to the SOA 11g Database using a SQL Client as DEV_SOAINFRA user.(Check out if your prefix ie DEV here is different)

b. Issue below command:

select count(*) from COMPOSITE_INSTANCE;

That would give you the number of instance present in the SOA dehydration store :)

Number of Instances for a specific Composite:


What if you wanted to find the number of instance for each composite,well use the below query

select count(*) from composite_instance where source_name='Composite Name'


Now you can folow us on facebook and post your comments/views and questions for expert advise. Check this out facebook


Find us on facebook here

What posts are you looking out for?

Guys,

Thanks for all your support and kind words.

I have been thinking what topics could I be writing that helps you in your professional fields. Please let me know any specific topics you are looking for related to Oracle SOA Suite,Oracle Weblogic Administration. Some of the topics I feel should help is:

1.  Code Versioning Tools for SOA and Fusion Middleware 11g
2.  Datasource tuning and best practices for SOA 11g
3.  ADF server installation steps and best practices
4.  Learning path for a Oracle FMW Admin!!
5.  SOA 11g Database maintenance steps
6. Purging SOA 11g in detail and best practices
7. SSL setup for Weblogic/OHS

Please follow us on facebook and vote for below options. You can use the like button on the right hand side of this blog to follow us on facebook.


Please suggest some other areas you feel should be of any help.


Now you can folow us on facebook and post your comments/views and questions for expert advise. Check this out facebook


Find us on facebook here