Thursday, June 11, 2009

Get version Oracle BPEL

It is not so easy to determine the version of the Oracle BPEL application but I found an note on metalink: 419711.1

In order to find the versions, we have multiple ways for some components:

1. BPEL Process Manager:

We can find the version of BPEL Process Manager from front-end as well as back-end:

a) Finding the version from front-end:

Login to BPEL Console and we find the version on the BPEL Console on the right-hand bottom. The version of BPEL Console is same as BPEL version.

b) Finding the version from back-end:

Execute the obversion.sh located at $ORACLE_HOME/bpel/bin directory. ORACLE_HOME is the location where the SOA Suite is installed.

2. BPEL Repository:

During various stages of installation or upgradation of the BPEL Process Manager or in the process of applying patches to BPEL Process Manager, the Metadata repository would also be upgraded. The version of Metadata version is 2.0.2 or 2.0.3 in 10.1.2.x versions of BPEL Process Manager. The SOA Suite 10.1.3.1.0 version of BPEL Process Manager comes with 2.0.4 version of Metadata repository.

However, some patches would be run against the Metadata repository and we might need to know the versions of the Metadata repository. In such cases, we can use the following SQL to know the version:

SQL> conn orabpel/orabpel;

SQL> SELECT guid FROM version_server;

Reference:
metalink note: 419711.1

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

4 comments:

  1. Thanks, Arjan! I couldn't figure out whether the ORABPEL schema in one of my databases had been created under-the-covers by the 10.1.4.2 OID + 10.1.2.3 iAS installation that was using the database or as an unwanted side effect of an 10.1.3.1 OC4J + HTTP Server installation on the same host. I needed to know before I applied the 10.1.3.4 upgrade script to the schema. Using your query I know now that it is part of the OID installation -- I won't try to upgrade it to 10.1.3.4!

    ReplyDelete
  2. Yeah! I do agree with you. During various stages of installation or upgradation of the BPEL Process Manager or in the process of applying patches to BPEL Process Manager, the Metadata repository would also be upgraded.
    sap project management

    ReplyDelete
  3. This is amazing blog,It is very helpful for developer
    Oracle SOA Online Training

    ReplyDelete
  4. This is very helpful. Thanks.

    ReplyDelete

comment