Mihai's Oracle SOA Solutions Blog

Here is an interesting interactive reference for Weblogic 11g

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/wls/Poster/poster.html#

SOA 11g Samples moved to this location

http://java.net/projects/oraclesoasuite11g/pages/Home

First run "setDomainEnv.sh"  to set the environment

. ./setDomainEnv.sh

and start WLST

java weblogic.WLST

next run following commands

connect('weblogic','welcome1','localhost:7001')
domainRuntime()
cd ("AppRuntimeStateRuntime/AppRuntimeStateRuntime")
ls ()

You will see here the available applications
and you can get for example the soa-infra state using

print cmo.getCurrentState("soa-infra", "soa_server1")

or the mediator state using

print cmo.getCurrentState("oracle.soa.mediator#11.1.1@11.1.1", "soa_server1")  

1. In your SOA installation look for "emoms.properties" file
The path should be somewhere in your SOA_HOME under domains folder

SOA_HOME/user_projects/domains/base_domain/servers/AdminServer/tmp/_WL_user/em/hsz5x1/META-INF/emoms.properties

2. Edit the file and add the line

where Value it's in minutes

4. Restart Admin & SOA server.

SOA 11.1.1.3.0 PS2 is now available on OTN .

You can Download it from :
http://www.oracle.com/technology/software/products/middleware/htdocs/fmw_11_download.html

To see the new Features in this Release :
http://www.oracle.com/technology/products/soa/soasuite/collateral/soa-11gr1-ps2-new-features.html

1. In your SOA installation look for "emoms.properties" file
In my env the path is
/home/oracle/product/11g/user_projects/domains/base_domain/servers/AdminServer/tmp/_WL_user/em/hsz5x1/META-INF/emoms.properties

2. Make a backup copy of it

3. Edit the file and add the line
oracle.sysman.eml.maxInactiveTime=< value >
where VALUE it's in MINUTES

4. Restart Admin & SOA server.

If you forgot the password for "admin" account , this is a simple way to reset it  .

Look in your CAMM install folder for file "AccessControl.xml"

This explains how is the TIMESTAMP column from ESB_ACTIVITY table coded, and how to convert it to DATE format if needed.

Structure of ESB_ACTIVITY table is :


SQL> desc ESB_ACTIVITY
Name                                      Null?    Type
----------------------------------------- -------- ---------------------------
ID                                        NOT NULL NUMBER
FLOW_ID                                   NOT NULL VARCHAR2(256)
SUB_FLOW_ID                                        VARCHAR2(48)
SEQ                                                NUMBER
SUB_FLOW_SEQ                                       NUMBER(3)
BATCH_ID                                           VARCHAR2(48)
SOURCE                                             VARCHAR2(48)
OPERATION_GUID                                     VARCHAR2(48)
TIMESTAMP                                 NOT NULL NUMBER
TYPE                                      NOT NULL NUMBER(2)
RR_OUTPUT_STATUS                                   NUMBER(2)
ADDI_INFO                                          VARCHAR2(500)
IS_STALE                                           VARCHAR2(1) 


The values from TIMESTAMP from ESB_ACTIVITY are coded as Unix timestamps.

The Timestamp column is of type NUMBER and it uses the following formula to calculate it (for example to tranform SYSDATE to TIMESTAMP used in ESB_ACTIVITY) :

Timestamp := ((TRUNC(SYSDATE)) - TO_DATE('01/01/1970','MM/DD/YYYY'))*24*60*60*1000;

In order to get the DATE in PL/SQL, you have to make the reverse operation.


Another simpler solution in Linux shell , is to first Divide the TIMESTAMP by 1000 and next use date function , for example :

date -d @1233200000

For more methods how to transform timestamp to readable date see more here

. Login to Weblogic Console ( http://host:7001/console) and go to
Security Realms -> myrealm -> Providers

2. Click on "New" to create a new Provider. Let's assume you will call this provider AD.
You must select ActiveDirectoryAuthenticator as provider type.
Click OK.

3. Now , you should have the following list of providers. At this point we need to reorder the provider
list so that AD will be the first one. This step is needed for Worklist application, otherwise you
will not be able to login with the AD users in worklist.


After reordering you should have the following list of providers


4. Click on AD provider and then open the tab Provider Specific .
NOTE : this is an example, you should set the parameters to match your AD configuration.

The rest you can leave unchanged for now. Click Save.


5. Now edit BOTH the AD and the DefaultAuthenticator provider and set
Control Flag: SUFFICIENT




6. Restart Admin and SOA managed server to activate the changes

7. Create a new User in AD - let's call it 'dummy'

8. Look in Weblogic Console at "Users and Groups" in "myrealm" . You should be able to see the new AD user "dummy"

9. Now try to login to worklist (http://host:8001/integration/worklistapp/)
You should be able to login with "dummy" user .

A couple of additions to the list of SOA samples list

Some new BPEL samples from Clemens on SOA PM blog.

Also the fusion order demo for SOA 11g PS1
http://www.oracle.com/technology/products/jdev/samples/fod/index.html

When you want to test a composite in SOA 11g you will see something similar to this screenshot :

You would want to change the "localhost.localdomain" part of the URL to some other hostname - for example I will use "deskLinux". To do this you need to modify the ServerURL and CallbackServerURL in the SOA configuration. This can be easily done via SOA Enterprise Manager :

1. Right Click on SOA-INFRA component in the left navigation tree. Go to Soa Administration --> Common Properties


2. Set the CallBackServerURL and the ServerURL to  http://deskLinux:8001 and click Save button

3. Restart SOA server to activate the changes . The URL should now be modified for all composites.