Oracle EBS R12.1.3 to R12.2.10 upgrade

Upgrade Oracle EBS

Step by Step approach from Oracle EBS R12.1.3 to R12.2, here are the course contents

What you’ll learn

  • Oracle EBS DBA.
  • Upgrade from R12.1.3 to R12.2.10.
  • Cloud DBA’s who are interested in upgrade.
  • Upgrade Students.

Course Content

  • Upgrade from R12.1.3 to R12.2 –> 9 lectures • 1hr 8min.
  • Upgrade from R12.2 to R12.2.10 –> 7 lectures • 45min.

Auto Draft


  • Oracle EBS DBA.

Step by Step approach from Oracle EBS R12.1.3 to R12.2, here are the course contents


Upgrade Oracle EBS from R12.1.3 to R12.2.10. 1

Environment used for the Upgrade. 3

Source – Oracle EBS R12.1.3 with 12c. 5

Database and System Administration Tasks. 7

Oracle EBS R12.2 upgrade preparation steps on OEL 7.x. 8

Install Oracle EBS R12.2 in upgrade mode. 8

Upgrade R12.1.3 to Oracle E-Business R12.2. 24

Preparing the System for Upgrade. 24

Run EBS Technology Codelevel Checker (ETCC) utility on Database node. 24

Upgrade DST Version. 28

Ensure that Maintenance Mode is enabled. 31

Update the profiles. 31

Apply AD 12.2 upgrade driver. 31

Apply all Consolidated Upgrade Patches (CUPs) 34

122 Master Merge. 39

Check Free space in tablespaces. 40

Apply 12.2 American English upgrade patch driver. 40

Disable Maintenance Mode. 42

Compile Invalid Objects. 42

Run Rapid Install to configure. 43

Run autoconfig on apps Tier and db tier. 50

Enable online patching. 55

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

Fix data dictionary or time stamp mismatch. 65

Run the Online Patching Enablement – Readiness Reports. 67

Verify database tablespace free space. 67

Run the Online Patching Enablement – Status Report 69

Apply the Online Patching Enablement patch. 71

Database Initialization Parameter. 74

Upgrade from Oracle EBS R12.2 to R12.2.10. 75

Set Database Parameter (Conditional) 75

Apply Consolidated Seed Table Upgrade Patch (Required) 75

Applying the Latest AD and TXK. 76

Update Database Tier to Latest Code. 78

Apply EBS R12.2.10 patch. 80

Apply help patch. 80

Run Preclone and take a backup. 80

Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1) 82

Issues and solutions. 82

Execute an Empty patching cycle. 85

Solution. 85

Submit Gather Schema Stats. 86

Custom Top Registration. 86

Problems and solutions. 89

Get Tutorial