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
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