SOA PS2 (PatchSet 2) 11.1.1.3.0 Available for Download

Posted in Labels: , , | 0 comments

How to change the timeout of EM console in SOA 11g ?

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.

Posted in Labels: , , , | 0 comments

How to Reset CAMM Admin Account Password

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"


You should see following section regarding the "admin" account:


<user userid="admin" enabled="true">
<first>Default</first>
<last>Administrator</last>
<password> --- encoded password --- </password>

If you want to reset the password you can set it to

<password>0DPiKuNIrrVmD8IUCuw1hQxNqZc=</password>

and next login as user "admin" with password "admin" .

Posted in Labels: , | 0 comments

How to Convert ESB Timestamp Field to Date and Time?

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

Posted in Labels: , , | 1 comments