SOA INFRA useful everyday queries


Nits:

Very useful daily SOA 11g queries

Originally posted on soArchitecture:

First of all, if you have not allready read the following links, this is the way to start…
Take a look:
https://forums.oracle.com/forums/thread.jspa?threadID=962459
The next blog holds all the information about the states and their meaning:
https://blogs.oracle.com/ateamsoab2b/entry/list_of_all_states_from

So, once you have read the above, you can easily understand the rest:

* Find running instances of a single composite

1

* Count Instances that have run for a specific composite in a single period

1

* Count All Instances by state in human readable format.

1
SELECT (CASE WHEN STATE=1 THEN ‘OPEN AND RUNNING’
WHEN STATE=2 THEN ‘OPEN AND SUSPENDED’
WHEN STATE=3 THEN ‘OPEN AND FAULTED’
WHEN STATE=4 THEN ‘CLOSED AND PENDING’
WHEN STATE=5 THEN ‘CLOSED AND COMPLETED’
WHEN STATE=6 THEN ‘CLOSED AND FAUTED’
wHEN STATE=7 THEN ‘CLOSED…

View original 589 more words

Installing Oracle SOA Suite 12c


 

Hi All,

As you all know that the Oracle 12c is out now… this is the first Major release where oracle has now combined the Oracle Service Bus with the SOA Suite Install… and its apparently only a 30 min single installation…

So firstly download the soa suite  from http://download.oracle.com/otn/nt/middleware/12c/121300/fmw_12.1.3.0.0_soaqs_Disk1_1of1.zip

 

This contains

SOA Suite 12.1.3 Size: 2.97 GB, Check Sum: 1579850769

Note: The generic SOA Suite Quick Start Installer for developers is used on all platforms. It allows you to quickly install a development or evaluation environment on a single host computer. It includes Oracle BPEL Process ManagerOracle Human WorkflowOracle Business Rules, Oracle Mediator, Oracle Service BusTechnology Adapters Oracle Enterprise Scheduler, SOA Spring Component, Enterprise Manager Fusion Middleware Control, Oracle JDeveloper with SOA IDE extensions and an integrated WebLogic Server and Java DB.

 

You can see the official quick start guide at http://docs.oracle.com/middleware/1213/core/SOAQS/integrated.htm#BEIJCGGE

 

Few things to note are

It needs JDK 1.7 so I downloaded (64 Bit) that from http://download.oracle.com/otn-pub/java/jdk/7u60-b19/jdk-7u60-windows-i586.exe

Next Set your JAVA_HOME

 

SET JAVA_HOME=C:\Program Files (x86)\Java\jdk1.7.0_60

 

For Linux

 

JAVA_HOME=$HOME/top_level_folder_jdkversion
export JAVA_HOME

 

Now we are all set to go….Open Command Prompt.

 

 IMPORTANT: It needs you to run that in admin mode.

 

Search for cmd.exe in the Start menu. Right-click the cmd.exe and select Run as Administrator.

 

In the command prompt, use the Java executable from the JDK on your system. Your command may look like this:

 

%JAVA_HOME%\bin\java -jar fmw_12.1.3.0.0_soa_quickstart.jar I did this and got the error in the screenshot… soa8
Note by default windows installs to Program files location which has a space so I had to use “” with “JAVA_HOME” and then it fired just fine. C:\Nitin\SOA\SOA12c>”%JAVA_HOME%”\bin\java -jar fmw_12.1.3.0.0_soa_quickstart.jar

 

soa7

soa6

soa5

soa4

soa3

That’s it now it’s time to sit back and relax….

soa2

soa1

soa11

Once you hit finish it launches Jdeveloper for the first time… Prompts to select the role I chose the studio role and allowed to import preferences from my previous installs which is optional.

soa10

soa9


ALL DONE…. Happy Developing….

 

Please leave your feedback in comments.