Requirement for Upgrading Databases that Use Oracle Warehouse Builder (OWB)

Select one of these three procedures to upgrade Oracle Database deployments with OWB release 11.2.0.3 and later.

OWB releases earlier than release 11.2.0.3 do not work with Oracle Database 12c.

OWB is not installed as part of the software for Oracle Database 12c, and OWB components that may exist in earlier releases are not upgraded as part of the Oracle Database upgrade process. However, you can use OWB release 11.2.0.3 with Oracle Database 12c.

Topics:

Add Oracle Database 12c Access to Existing standalone OWB 11.2.0.3 Installation

Use this patch update procedure to enable you to use Oracle Warehouse Builder (OWB) 11.2.0.3 with Oracle Database 12c.

If you have an existing standalone OWB 11.2.0.3 installation, then you can enable Oracle Database 12c to access OWB.

To add Oracle Database 12c access to an existing standalone OWB 11.2.0.3 installation:

  1. Stop all OWB applications from running: the OWB Runtime service, Browser, and Name Address server.

  2. Install Oracle Database 12c software and follow the database upgrade instructions.

  3. Apply OWB Cumulative patch 16568042 to the OWB release 11.2.0.3 installation. (You can patch OWB either before or after installing Oracle Database 12c.)

    To obtain the patch, go to My Oracle Support, , click Patches, and search for patch request number 16568042:

    http://support.oracle.com

  4. Follow in-place migration steps in the patch README.txt file.

  5. Continue to run OWB release 11.2.0.3 from the standalone Oracle home.

Keep Existing OWB 11.2.0.3 Installation In-place with Oracle Database Release 11.2.0.3

Use this procedure to retain Oracle Database Warehouse Builder (OWB) on a platform where a standalone installation is not available.

If OWB release 11.2.0.3 is running on a platform where a standalone installation is not available (for example, Solaris, HP, AIX and other platforms), then you must keep the Oracle Database release 11.2.0.3 software in its existing Oracle home (in-place) after you migrate to Oracle Database 12c.

  1. Stop all OWB applications from running: the OWB Runtime service, Browser, and Name Address server.

  2. Install Oracle Database 12c software and follow database upgrade instructions.

  3. After you have installed Oracle Database 12c, leave the existing Oracle Database release 11.2.0.3 home in place. You run OWB from the Oracle Database release 11.2.0.3 Oracle home.

  4. Apply patch 16568042 to the Oracle Database release 11.2.0.3 Oracle home. This patches the OWB installation. You can patch OWB either before or after you install Oracle Database 12c.

    To obtain the patch, go to My Oracle Support, click Patches, and search for patch request number 16568042:

    http://support.oracle.com

  5. Follow in-place migration steps in the patch README.txt file.

  6. Run OWB from the integrated Oracle Database release 11.2.0.3 Oracle home.

Use the Standalone OWB 11.2.0.3 Installation Where Available

Use this procedure to install the standalone Oracle Warehouse Builder (OWB) software in a separate Oracle home.

If OWB 11.2.0.3 is running on a platform where a standalone installation is available (for example, on Linux and Windows), then you can install the standalone OWB software in a separate Oracle home, and then remove Oracle Database release 11.2.0.3 software and Oracle home.

  1. Stop all OWB applications from running: the OWB Runtime service, Browser, and Name Address server.

  2. Install the OWB standalone client into its own OWB home directory.

  3. Copy the entire owb/bin/admin directory from the old OWB installation to the new OWB installation's owb/bin/admin directory. This step ensures all files and subdirectories are copied to the new OWB location.

  4. Run the following SQL statement as the OWBSYS user to reset the Control Center home value. Enter from the directory location for the new OWB_HOME when prompted:

    sqlplus OWBSYS/OWBSYS_PASSWORD
    % New_OWB_HOME/owb/UnifiedRepos/reset_owbcc_home.sql
    
  5. Install Oracle Database 12c software and follow database upgrade instructions.

  6. Apply OWB Cumulative patch 16568042 to the OWB standalone release 11.2.0.3 installation. (You can patch OWB either before or after installing Oracle Database 12c.)

    To obtain the patch, go to My Oracle Support, click Patches, and search for patch request number 16568042:

    http://support.oracle.com

  7. Follow in-place migration steps in the patch README.txt file.

  8. Run OWB release 11.2.0.3 from the standalone Oracle home location.