Tuesday May 15, 2012

Upgrading Database Schema in FMW Upgrade

During a FMW upgrade one of the most common tasks forgotten is the upgrade of the database schemas as the steps seem to be berried in a mountain of documentation. If you are looking for the actual steps to upgrade FMW look at the following post - Upgrading Fusion Middleware 11.1.1.x to 11.1.1.4 when you get to step 24 refer to this blog entry.

Oracle has made it a bit simpler running the Patch Set Assistant (psa). Before it was a bit of a dark art running a command line script and you had to guess what schemas need to be upgraded. Now there is a wizard driven tool to implement this.

  1. As the middleware owner change directory to $MW_HOME/oracle_common/bin
  2. Run the following command to start the PSA wizard
    ./psa



    Click Next to start entering details

  3. Select the component you want to upgrade, it will include all the prerequisites.



  4. Select the prerequisite check boxes to say you have backed up your environment.



  5. Enter connection details for the MDS schema



  6. Enter connection details for the SOAINFRA schema



  7. Check that all schemas connect successfully. If not go back and correct.



  8. Make sure all the setting are correct and continue



  9. Watch the install run, then complete



  10. Now you can check the version of the schemas to ensure they are correct. In this case I'm looking to have the version come back as 11.1.1.6

    SELECT owner, version, status FROM schema_version_registry
    where owner in ('DEV_MDS', 'DEV_SOAINFRA');


    OWNER                          VERSION                        STATUS
    ------------------------------ ------------------------------ -----------
    DEV_MDS                        11.1.1.6.0                     VALID
    DEV_SOAINFRA                   11.1.1.6.0                     VALID


Monday May 14, 2012

Finding the Right Patchset

I'm always surprised at how hard it is to find the right patchsets when looking to do an upgrade.

So I thought I would make a blog entry that makes it easy to find the right patches starting from 11.1.1.4. The following list are documents that provide the required patches for the associated upgrades:

11.1.1.4
11.1.1.5
11.1.1.6
11.1.1.7

I will update as more patchsets become available.

If you are looking for patch install instructions please refer to the following blog entry:

Upgrading Fusion Middleware

Happy upgrades


Wednesday Jun 15, 2011

Issue Deploying Migrated BPM Processes to 11.1.1.4

I have migrated my BPM processed from 11.1.1.1 to 11.1.1.4. This issue may happen with other versions but I thought I would document anyway.

When deploying my migrated BPM process I get the following error:

java.lang.ClassNotFoundException: oracle.bpel.services.datacontrol.types.Number


This issue is caused by the ADF worklist projects in your BPM process. Therefore for each ADF project in your BPM process you need to modify the weblogic.xml file to add the oracle.soa.worklist.webapp  library which seems to be a requirement in the new release of 11.1.1.4. In JDeveloper 11.1.1.4 it adds it automatically so you don't need to worry about it for new projects.

The weblogic.xml is found in the ADF worklist project:

Web Content > WEB-INF > weblogic.xml

Open the weblogic.xml in source mode and add the following code at the bottom just before the </weblogic-web-app> tag.

   <library-ref>
     <library-name>oracle.soa.worklist.webapp</library-name>
     <specification-version>11.1.1</specification-version>
   </library-ref>

To confirm you have entered it correctly go to the Overview tab and select libraries. You should see the the library added.

Now you can redeploy, and you should get success.

Wednesday Feb 23, 2011

Upgrading Fusion Middleware 11.1.1.x to 11.1.1.4

This is a follow on from my previous post where we upgraded 11.1.1.2 to 11.1.1.3. The instructions I provide here will work for Fusion Middleware 11.1.1.2 and 11.1.1.3 wanting to upgrade to 11.1.1.4.

In this example I’m just upgrading SOA Suite on OEL 64bit but the steps will be the same, some of the downloads may be different based on your environment.

To upgrade to 11.1.1.4 you need to have access to http://support.oracle.com as this is where the downloads reside. Oracle provides 11.1.1.4 as a standalone download so you can do a fresh install if required using OTN downloads (http://www.oracle.com/technetwork/indexes/downloads/index.html).

The high level steps to upgrade are as follows:

  • Download software
  • Shutdown your SOA Environment
  • Upgrade WLS to 11.1.1.4
  • Upgrade SOA Suite to 11.1.1.4
  • Upgrade OSB to 11.1.1.4
  • Upgrade MSD Schemas
  1. Identify the downloads you require for your install. You will need the WebLogic Server Upgrade and the additional product downloads. If you are using 64bit then use the generic version. The downloads are found from the following location - http://download.oracle.com/docs/html/E18749_01/download_readme.htm#BABDDIIC

    For the purpose of this post I downloaded the following patches
    11060985 – WLS Server Generic
    11060960 – SOA Suite
    11061005 – OSB Suite 
  2. Make sure you have set the Java executable in your PATH e.g.

    export PATH=$JAVA_HOME/bin:$PATH
  3. Make sure all your WebLogic environment has been shut down before performing the upgrade.
  4. Extract the WLS patch 11060985 to a temporary directory and start the installer

    java –jar wls1034_upgrade_generic.jar

    Please note if you are not running 64BIT then the upgrade executable will be just a bin file which you can execute directly.

    image
  5. Chose the right Oracle home for your WebLogic Server install.

    image
  6. In the Register for Security Updates you can enter your details or just click Next. If you do not enter details confirm that you don’t want to receive these updates

    image

    image
  7. Select the products you want to upgrade and select next. It is recommended that you accept the defaults.

    image
  8. Confirm the directories that will be upgraded

    image
  9. Upgrade of WLS ahs been completed

    image
  10. Extract your both SOA downloads to a temporary directory and run the installer found in Disk1

    ./runInstaller -jreLoc /java/jdk1.6.0_20/jre

    Please note that the java location and version may be different for your environment

    image
  11. Skip the Software Updates

    image
  12. Ensure your system meets the prerequisites

    image
  13. Set the Oracle home for your SOA install.

    image

    You will be asked to confirm that you want to upgrade, click Yes

    image
  14. Choose your application server. Since you are upgrading from 11.1.1.x you will be on WebLogic

    image
  15. Start the Install

    image
  16. Installation Upgrade of SOA Suite completed accept the default to finish.

    image


    image
  17. In my environment I have OSB installed so I need to upgrade this next. If you don’t have SOA Suite you can go straight to completing the DB Schema updates at Step 24. 
  18. Extract the OSB upgrade files to a temporary directory and execute the installer found in the Disk1 folder.
    ./runInstaller -jreLoc /java/jdk1.6.0_20/jre

    image

  19. Skip the software updates

    image
  20. Select the Oracle home for your environment

    image

    Accept the warning to continue the upgrade

    image
  21. Point to the location of your WebLogic Server installation

    image
  22. Install the OSB upgrade

    image
  23. Upgrade has been completed accept the defaults

    image

    image
  24. Change directory to $MW_HOME/oracle_common/bin where the Patch Set Assistant is installed
  25. Execute the following command to update the MDS schema. Please not for my examples I have the context set to DEV. your may be different. This means that all my schemas are prefixed by DEV.

    ./psa -dbType Oracle -dbConnectString 'localhost:1521:xe' -dbaUserName sys -schemaUserName DEV_MDS

    You will be asked you passwords for sys and the schema

    Enter the database administrator password for "sys":
    Enter the schema password for schema user "DEV_MDS":

  26. Change directory to $MW_HOME/Oracle_SOA1/bin to where the Patch Set Assistant is installed for SOA Suite.
    Execute the following command to update the SOA and BAM schemas

    ./psa -dbType Oracle -dbConnectString 'localhost:1521:xe' -dbaUserName sys -schemaUserName DEV_SOAINFRA
  27. To check that you have the installed correctly run the following SQL as sysdba.

    SELECT owner, version, status FROM schema_version_registry;

    OWNER                          VERSION                        STATUS
    ------------------------------ ------------------------------ -----------
    DEV_MDS                        11.1.1.4.0                     VALID
    DEV_SOAINFRA                   11.1.1.4.0                     VALID

    Don’t stress if the versions are not all sitting at version 11.1.1.4 as not all schemas need to be updated. The key ones are MDS and SOAINFRA

About

Discussions and Examples using Oracle Fusion Middleware. Some image links are broken when using Firefox, Safari, and Chrome. If you want to see the full image please use IE.

Twitter:@james8001

tumblr hit counter vistors, thanks for your support

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today