Upgrading Warehouse Builder

March 5th, 2007 by Peter Scott

I have mentioned here before that one of our customers has a BI system based on an Oracle 9.2 Data warehouse and uses OWB 9.2.0.8 for the majority (but not all) of the ETL processes. For various reason linked with vendor certifications the system was frozen at Oracle 9. We wanted to upgrade the database but needed to roll-out various other changes first. And as the customer works in a retail environment there are various trading periods (such as Christmas and the New Year, and fiscal year end) where any change to the IT systems running the business, and BI runs a significant part of the stock policy and supply chain side of organisation, is blocked.

We can now start work on the OWB upgrade. This was planned soon after Paris was released as OWB 10.2. Last year we planned a two step upgrade to take us through OWB 10.1 as direct upgrade was not supported. But, being true professionals we always read the latest documentation before starting on a project. What we knew 4 months ago may not be true now. And in this case our caution was vindicated. The OWB 10.2.0.2 patchset allows us to migrate directly from 9.2 to 10.2.

It pays to re-read the release notes!

It’s nice to read Doug’s PX paper

At last, hot off the Hotsos hotel room - just goes to show there is more to Doug than a growing collection of soft toys. Oh, and a jet-set image, and video appearances and appearing at number 6 in Andy C’s list. Still I’m chuffed to be number 11.

Posted in Data Warehousing, Oracle Warehouse Builder |

Comments

  1. Ravi Says:

    June 22nd, 2007 at 6:07 am

    Hi Mr.Peter Scott,

    I was going through this article, wherein you mention
    we can “directly migrate from OWB 9.2 to OWB 10.2
    by applying OWB 10.2.0.2 patchset” ,
    by doing this
    1)my new OWB version will be 10.2.0.2 right ?
    2)and I can move all mappings from OWB 9.2 to this latest version 10.2.0.2
    without having to move it to any intermediate version like 10.1.0.4. is it right?

    Could you give me a feedback on this, I have been assigned this work.

    Thanks in Advance,
    Ravi

  2. Peter Scott Says:

    June 22nd, 2007 at 6:32 am

    Ravi
    Whenever you plan an upgrade it is a good idea to go through metalink and look at any further patches that should be applied (and also look at the published bugs database to see if any issues will cause you problems)
    The 10.2.0.2 patch is applied on top of the 10.2 base product (unless, and I have not checked this recently, the delivered product is now shipped in the 10.2.0.2 version). You will need to carefully read the 10.2.0.2 documentation especially the section that describes the process to follow to migrate from 9.2 to 10.2 and follow the steps carefully.
    But in essence: backup the existing OWB, export the OWB repository from OWB, install OWB 10.2 to a new Oracle home, patch it to 10.2.0.2, then follow the instructions to import and upgrade the repository. You then need to <b>test</b> outmappings, there is a possibility that multiple target mappings may need a slight tweek as OWB 9 did not have a concept of transform order but 10 does.
    And yes the version of OWB will be 10.2.0.2 and you do not need to pass through 10.1 any more