14 Upgrading Oracle Student Learning from Release 3.1.2 to Release 3.1.3

This chapter describes the steps for upgrading Oracle Student Learning (OSL) 3.1.2 to OSL 3.1.3.

14.1 Prerequisite

OSL 3.1.2 is installed and configured before you perform the upgrade process.

14.2 Updating OSL Learning Tool Database

To update the OSL Learning Tool Database to the current version, use one of these methods:

• Select Yes in the Database Upgrade screen during the installation process.

• Manually update the database by running the DB_Upgrade.sql script in [OSL home directory]/LearningTool/Scripts after the installation. Ensure that your current database schema version is the same as the required version of the DB_Upgrade.sql script.

Notes:

• The required database schema version for the database upgrade script is specified in the line starting with --required_version of DB_Upgrade.sql.

• Your current database schema version is specified in the CURRENT_VERSION column of the OSL_PRODUCTS table.

14.3 Installing WLS 10.3.5 and ADF 11.1.1.5.0

OSL 3.1.3 is certified with WLS 10.3.5 and ADF 11.1.1.5.0. Ensure that you upgrade your environment to these versions.

14.4 Deploying the new OSL .ear file

Customize and deploy the new OSL Learning Tool .ear file as explained in Chapter 9, "Deploying OSL Learning Tool Admin and OSL Learning Tool".

14.5 Redploying OBIEE Catalogs

1. Log in to the Fusion Middleware Enterprise Manager.

2. Navigate to Business Intelligence > Core Application.

3. Select the deployment tab and the repository.

4. Unzip the OSLCatalog.zip file from the [OSL Home directory] > LearningTool > StudentReporting > obiee11g directory.

5. Deploy the configured OSL repository file and catalog files.