Arun Bavera

 

After upgrading your SOA from PS1(11.1.1.2) to PS2(11.1.1.3) you will find that there are no scripts are upgrade schema for the BAM. Refer my earlier post for PS1 to PS2 patch upgrade.

The version of BAM schema still shows as 11.1.1.2 when you check using the query

select version, mr_type from schema_version_registry where MR_TYPE='BAM'

This is expected as PS2 doesn’t have any changes for BAM schema.

PS2  upgrade schema scripts only has changes for these components:

Oracle Portal (PORTAL), Oracle Identity Management (OID), SOA Infrastructure (SOAINFRA), Audit Services(IAU)

 

First check the logs for the issue and find out the class name

Look for Caused by:  <classs name>

Now, search for that class in your product installed home.

Use this utility to find the JAR files which this class file resides

https://jarscan.dev.java.net/servlets/ProjectDocumentList

For eg:

cd $SOA_HOME

java -jar jarscan.jar -class org.quartz.impl.StdSchedulerFactory

Now, if you have source code access you can look into the file or you can use jd-gui (http://java.decompiler.free.fr/)  to look into the class to see what’s really happening

Want to send a kill -3 to Java process like in Unix try this:

http://www.latenighthacking.com/projects/2003/sendSignal/

 

Here are brief steps:

1) Stop Domain/instance

2) Apply WLS 10.3.3 patch update (using wls 10.3.3 upgrade installer)

3) Apply FMW PS2 sparse patch to upgrade the binaries to11.1.1.3

4) Apply RCU Patch Scripts using the PSA to upgrade existing schema to 11.1.1.3

5) Start Domain/instance

6) Download JDEV 11.1.1.3

If you have Metalink Account then Goto support.us.oracle.com->Patches&Updates->Product or Family Advanced Search then follow screenshot to choose the product

Otherwise goto

http://www.oracle.com/technology/products/soa/soasuite/collateral/downloads.html#11.1.1.3.0

Or

You can directly download these 3 required softwares from support.oracle.com

Ø WLS 10.3.3 Patch upgrade BUG number: 9645506

Ø SOA 11gR1_PS2 Sparse Patch BUG number: 9585621

Ø Jdev 11.1.1.3 Studio Edition: http://download.oracle.com/otn/java/jdeveloper/11.1.1.3.0/jdevstudio11113install.bin

http://www.oracle.com/technology/software/products/jdev/htdocs/soft11.html

Oracle SOA Composite Editor

http://www.oracle.com/technology/products/jdev/101/update/fmw_products.xml#oracle.sca.modeler

Here are steps in Detail:

1) Stop Domain/instance

2) Apply WLS 10.3.3 patch update (using wls 10.3.3 upgrade installer)

Use the upgrade installer ->

http://download.oracle.com/docs/cd/E14571_01/doc.1111/e14142/prepare.htm#WLSIG195

http://download.oracle.com/docs/cd/E14571_01/doc.1111/e14142/guimode.htm

You can directly download by providing BUG number: 9645506 for Linux x86

Or

Use the Smart Update tool->

http://download.oracle.com/docs/cd/E14571_01/doc.1111/e14143/service.htm#SUTUG175

I am Using the upgrade installer:

chmod +x wls1033_upgrade_linux32.bin

./wls_1033_upgrade_linux32.bin

Screenshots:

3) Apply FMW PS2 sparse patch

After downloading the SOA PS2, extract 4 disks.

Start the installation like this from Disk1

./runInstaller -jreLoc /oracle/Fusion11g/Middleware/jdk160_18

Follow the screenshots:

4) Apply RCU Patch Scripts using the PSA to upgrade existing schema to 11.1.1.3

Run PSA ( Patch set Assistant). This will be installed in OH/bin folder after completing 3 step that is applying PS2 sparse patch.

First Check pre-requisite:

sqlplus / as sysdba

      show parameter aq_tm_processes;  

       If the outcme is 0 then 

       alter system set aq_tm_processes=1 scope=both;

      PSA will be in your SOA ORACLE_HOME.  $SOA_ORACLE_HOME/bin

     For Eg: /oracle/Fusion11g/Middleware/Oracle_SOA1/bin

           You can run 

 ./psa -dbType Oracle -dbConnectString '//garuda.idc.oracle.com:1521/orcl' -dbaUserName sys -schemaUserName soa11gr2_soainfra

Screenshots:

You can use the SQL command below to verify that the schema version in schema_version_registry has been properly updated:

SELECT version, status FROM schema_version_registry WHERE owner='SOA11GR2_SOAINFRA';

SELECT version, status,owner FROM schema_version_registry;

For Oracle databases, be sure to recompile database objects after running the Patch Set Assistant by connecting to the database as SYS and running the following from SQL*Plus:

SQL> @?/rdbms/admin/utlrp.sql

This will compile the database objects that were updated by Patch Set Assistant.

Then issue to following query to ensure there are no longer any invalid database objects:

SELECT owner, object_name FROM all_objects WHERE status='INVALID';

None of the database objects for the updated schema should be invalid at this point.

Refer: http://download.oracle.com/docs/cd/E14571_01/doc.1111/e16793/patch_set_assistant.htm

5) Start Domain/instance

6) Download JDEV 11.1.1.3

http://www.oracle.com/technology/software/products/jdev/htdocs/soft11.html

Other References from Oracle SOA Suite Product Management team:

SOA Suite 11gR1 Patch Set 2 (PS2) released today!

http://blogs.oracle.com/SOA/2010/04/soa_suite_11gr1_patch_set_2_ps.html

By Demed L'Her,

11gR1 Patchset 2 ~ 11.1.1.3.0 (SOA) features ..

http://blogs.oracle.com/soabpm/2010/03/11gr1_patchset_2_111130_soa_fe.html

By clemens.utschi

Oracle SOA Suite 11g Release 1 Patch Set 2 (11.1.1.3.0) New Features

http://www.oracle.com/technology/products/soa/soasuite/collateral/soa-11gr1-ps2-new-features.html

Oracle SOA Suite

http://www.oracle.com/technology/products/soa/soasuite/index.html

ORACLE SOA SUITE DOCUMENTATION http://download.oracle.com/docs/cd/E15523_01/soa.htm