We have recently been working on and completed an entire Oracle Fusion Middleware 11g environment setup for a customer:

• Identity Management
• WebCenter (Framework and Services)
• SOA Suite
• UCM

This article is part of the recent work short blurb series.

A few of us have got some writer’s cramp (is there such a thing when typing?) from writing an excellent WebCenter 11g book.

Complete the below to receive scripts to automatically startup and shutdown your Oracle Application Server 10.1.2.x or 10.1.3.x midtier environment.

We have implemented and maintain many Oracle Application Server environments, so we are simply sharing some of the knowledge.

The economy is evolving, technology is getting better, and overall, the game is changing with cloud computing. M&S is now resellers for the Amazon EC2 Cloud, providing customers with access and expertise to make their enterprises run on “the cloud”. To host an enterprise environment, let alone Oracle, simply does not appear cost effective in the long run. In fact, I am open to healthy discussion contending that statement.

Oracle provides a dynamic, web-based application they call “Certify” that lists out the certification information by either Product or Platform.

SOA Labels

Among their many characteristics, all too often SOA projects have been labeled in their worst moments as:

• Overly complex in architecture, design, and communication to the organization
• Lacking the ability to control costs during implementation and maintenance
• Difficult to attract and retain talent with valuable experience, deep skills, and real success

It’s Not SOA’s Fault

Guess what. None of these are characteristics of SOA, but instead…

As part of the M&S Dynamic Oracle Portal utility, the Oracle Portal Dynamic Menu allows you to generate hierarchical links available to the visitor navigating your portal, styled exactly the way you want.

For a limited time, contact us with how you would use this solution and we will provide a single domain license of the Oracle Portal Dynamic Menu free of charge to your organization, which must have a valid Oracle Portal license.

M&S Consulting has begun a revolutionary service where we will write Oracle SQL statements for FREE. We have named this service FreeQL^TM.

Who can use FreeQL?

Anybody can request an Oracle SQL statement to be written, as complex as you desire. You must provide a valid, non-free email address that we will use to communicate with you. That means that we will not entertain requests from gmail, hotmail, yahoo, etc.

What’s the catch?

With years in the business writing high performing, very practical SQL statements for Oracle customers (many in the business intelligence space), we want to share our knowledge and get the word out about our skills, ability, and friendly business style.

You are welcome to sign up for our newsletter or make a small payment if you desire, though that is not a requirement.

I’m in. Now what?

Simply populate the FreeQL form and we will respond to you with SQL. Everyone wants something without spending money…and we’re here to give it to you!

Oracle has made some great strides with their BPM and SOA offerings. For M&S, combining process and technology has become even more exciting with Oracle’s tools. For the first time, Oracle has made it possible for our consultants to more easily bring together best of breed solutions (IDS Scheer’s ARIS and Oracle SOA) and leading industry standards (BPMN, BPEL, and BPEL4People) to our implementations, which typically involve some level of process management/improvement and technology automation (workflow and reporting).

Following is a quick image of how each person in an organization fits into our approach when combining process with technology using Oracle technologies:

Marc Kelderman wrote a helpful article on this topic:

http://orasoa.blogspot.com/2007/03/delete-bpel-instances.html

One of the users there notes:

Note there is a patch to 10.1.3.3 to purge old data (6372741). Its a fairly dumb one that deletes everything older than a given date. Trying to do something more elaborate we have noticed that if you use the script in this article as a basis then rows in xml_document table are not removed.

We have written code to conditionally purge BPEL instances in a sophisticated manner, taking into account custom logic, scheduling, and performance for multiple customers in SOA/BPEL versions 10.1.2 and 10.1.3.x. The fact is that purging should be strategically planned to meet your unique use of Oracle BPEL.

Drop us a note if you would like to discuss your specific needs. We are very responsive and happy to jump onto an initial call for FREE.