Major Steps in the R12.2 Upgrade

Preparing the Database for the Upgrade

              Back Up the Oracle E-Business Suite Database and Customizations

              Migrate Existing Objects to New Tablespace Model

Upgrade Your Database and Apply Mandatory Oracle E-Business Suite 12.2 Database Patches (required):

Ensure that the required database patches for Oracle E-Business Release 12.2 have been applied

Preparing the Oracle E-Business Suite Release 12.2 File System

Performing Mandatory Preparatory Tasks

Setting Up the Stage Area

Obtaining Installation Software

              Select only the following releases:

• Oracle E-Business Suite 12.2.0 Current

• Oracle WebLogic Server 10.3.6.0.0

• Oracle Web Tier 11.1.1.9.0

• Oracle Database 12.1.0.2.0

Creating the Stage Area

              Run the buildStage Script

              Patch the Stage Area

Creating the Upgrade File System

DB Node Configuration

Preparing the System for Upgrade

              Apply Required Application Tier Patches

                            • FMW WebTier 11.1.1.9

• Oracle WebLogic Server 10.3.6 Smart Update Patch

• Oracle WebLogic Server 10.3.6.0

• FMW oracle_common 11.1.1.9

• Forms and Reports 10.1.2.3

              Validate the GUEST user account

Customer Relationship Management Tasks

Financials and Procurement Tasks

Human Resource Management (HRMS) Tasks

Supply Chain Management Tasks

Database and System Administration Tasks

              Reset init.ora parameters (required)

Gather SYS, Fixed Object and Dictionary Statistics (required)

Gather schema statistics (required)

Install JRE on the database tier (conditional)

Synchronize values of APPLPTMP with Database Directories for PL/SQL File I/O based Concurrent Requests (required)

Perform a system backup

Performing the Upgrade to Release 12.2.0

              Shut down application tier listeners and concurrent managers (required)

Update init.ora with upgrade parameters (required) 

Set FAILED_LOGIN_ATTEMPTS to UNLIMITED for Oracle E-Business Suite schema

Disable custom triggers, constraints, indexes, business events, and VPD (conditional)

Check for data dictionary corruption and time stamp mismatch

Compile invalid objects

Rebuild unusable indices

Refresh materialized view (conditional)

Back up the database (recommended)

Disable database auditing (recommended)

Ensure that Maintenance Mode is enabled (required)

Apply AD 12.2 upgrade driver (required)

Apply the consolidated upgrade patch and run the 12.2.0 Upgrade (required)

Disable maintenance mode (required)

Back up Oracle E-Business Suite

Finishing the 12.2.0 Upgrade

              Configure Release 12.2 Oracle E-Business Suite instance (required)

                            Update the DB ORACLE_HOME file system with AutoConfig and Clone files (conditional)

                            Install JRE on the database tier (conditional)

                            Create the Context Name directory in the DB oracle home

                            Set and export the following environment variables

                            Generate a new database context file

                            Clean up old node information prior to configuring the Oracle E-Business

Synchronize values of APPLPTMP with Database Directories for PL/SQL File I/O based Concurrent Requests (required)

Run AutoConfig on the database tier nodes

Source the Run file system environment file

Drop table ADX_PRE_AUTOCONFIG from APPS schema

Configuring the Oracle E-Business Suite Release 12.2 Application Tier

Enabling Online Patching

              Verify the database version

              Verify that the latest patches have been applied to the database and application tier

              Gather SYS schema statistics

              Apply the latest Oracle E-Business Suite Online Patching Readiness and GSCC Report Patch

              Run the Online Patching Enablement – Readiness Reports

              Fix Violations Listed in the Online Patching Readiness Report that Require Manual Intervention

              Verify database tablespace free space

              Run the Online Patching Enablement – Status Report

              Ensure that all Application Tier Oracle E-Business Suite services are shut down

              Download and apply the Online Patching Enablement patch

              Compile Invalid Objects (if any)

              Re-run the Online Patching Enablement Status Report after the Online Patching

Re-run the Online Patching Enablement Readiness Report after the Online Patching Enablement patch has been applied

Run the Online Patching Database Compliance Checker report to check for coding standards violations

Database Initialization Parameters

Upgrading to the Latest Code Level

              Apply the Latest AD and TXK for Release 12.2

              Execute txkSavePDBState.pl (conditional)

For the custom products that already exist, you must run adsplice on the Run File system to lay down the file system.

Apply the Latest Oracle E-Business Suite Release Update Pack for Release 12.2