Oracle E-Business Suite R12.1.3 to R12.2.0 Upgrade Guide

Overview

This comprehensive guide walks through the step-by-step process of upgrading Oracle E-Business Suite from Release 12.1.3 to Release 12.2.0. The upgrade includes database preparation, staging area creation, and the implementation of online patching capabilities.

Prerequisites and Preparation
Database Preparation
Staging Area Setup
File System Configuration
Rapid Install Upgrade
AD and TXK Upgrade
Online Patching Enablement
Post-Upgrade Verification

1. Prerequisites and Preparation

1.1 Download EBS 12.2.0 Software

Download the Oracle E-Business Suite 12.2.0 installation zip files and place them on the server in a staging directory (e.g., `/mnt/stage1220`).
Required Zip Files:
V100052-01_1of3.zip, V100052-01_2of3.zip, V100052-01_3of3.zip
V100059-01_1of2.zip, V100059-01_2of2.zip
V100060-01_1of3.zip, V100060-01_2of3.zip, V100060-01_3of3.zip
V100061-01.zip, V100102-01.zip, V29856-01.zip
V35802-01.zip, V35803-01_1of3.zip, V35803-01_2of3.zip, V35803-01_3of3.zip
V35804-01_1of2.zip, V35804-01_2of2.zip
V46095-01_1of2.zip, V46095-01_2of2.zip, V75792-01.zip

2. Database Preparation

2.1 Add Service for Patching

Add the ebs_patch service to the existing database service list:

sqlplus '/as sysdba'

-- Check current service names
show parameter service

-- Add ebs_patch service
alter system set service_names='FBS,ebs_patch' scope=both;

-- Verify the change
show parameter service

2.2 Download and Run ETCC

Download Patch 17537119 and run the EBS Technology Codelevel Checker (ETCC):

cd /u01/patches/etcc/
./checkDBpatch.sh contextfile=$CONTEXT_FILE

Note: The ETCC will identify missing database patches. Apply the recommended patches before proceeding with the upgrade.

3. Staging Area Setup

3.1 Extract StartCD

Unzip the StartCD zip files to create the staging structure:

unzip V100052-01_1of3.zip
unzip V100052-01_2of3.zip
unzip V100052-01_3of3.zip

Verify the StartCD version:

cd startCD/Disk1/rapidwiz/
./RapidWizVersion
# Should display: Version 12.2.0.51

3.2 Configure Unzip Utility

The StartCD provides a compatible version of unzip. Configure it as follows:

mv /usr/bin/unzip /usr/bin/unzip_orig
ln -s /mnt/stage1220/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip /usr/bin/unzip
unzip -version

3.3 Build the Stage Area

Run the buildStage script to create the installation staging area:

cd /mnt/stage1220/startCD/Disk1/rapidwiz/bin/
./buildStage.sh

During the build process:

Press Enter through the welcome screens
Select Option 1 (Create new stage area)
Select Option 2 (Linux x86 64-bit)
Enter the directory containing the zip files: /mnt/stage1220

3.4 Patch the Stage Area

Download Patch 32947483 and apply it to the staging area:

unzip p32947483_R12_GENERIC.zip
cd 32947483
./patchRIStage.sh

When prompted, enter the Rapid Install Stage area path: /mnt/stage1220

Set appropriate permissions:

chmod -R 777 /mnt/stage1220/software

3.5 Copy Additional Patches

Use the Build Stage Menu to copy additional patches:

cd /mnt/stage1220/startCD/Disk1/rapidwiz/bin/
./buildStage.sh

Menu Selections:

Select Option 2: Copy patches to existing stage area
Select Option 2: Linux x86 (64-bit)

3.6 Linux 8 Compatibility Workaround

If running on Linux 8, apply this workaround for Oracle HTTP Server compatibility:

cd /u01/stage1220/TechInstallMedia/ohs11119/Disk3/stage/Components/oracle.buildtools.rsf/11.1.0.7.0/1/DataFiles/

# Extract and replace libc.so.6
jar xvf filegroup4.jar
cd lib/stubs
mv libc.so.6 libc.so.6.safe
cp -p /lib64/libc.so.6 .
cd -

# Recreate the JAR file
mv filegroup4.jar filegroup4.jar.safe
jar cvf filegroup4.jar lib

4. File System Configuration

4.1 Run Rapid Install Wizard

Launch RapidWiz as the root user to create the new file system layout:

cd /mnt/stage1220/startCD/Disk1/rapidwiz/
./rapidwiz

4.2 RapidWiz Configuration Steps

Welcome Screen: Click Next

Upgrade Options:
- Select "Upgrade Oracle E-Business Suite R12.1.3 to R12.2.0"
- Uncheck security update notifications
- Click Next and confirm

File System Creation:
- Select "Create a new Upgrade File System"
- Use the same port pool as your R12.1 installation

Database Configuration:
- Provide current R12.1 database details
- Select "Use existing Oracle Home"

Character Set Settings:
- Selected Languages: American_English-US
- Default Territory: AMERICA
- Database Character Set: AL32UTF8
- APPL_TOP Character Set: AL32UTF8
- IANA Character Set: UTF-8

File System Path:
- Provide installation path (e.g., /mnt/stage1220)

WebLogic Password:
- Set WebLogic password and confirm applmgr OS user password

4.3 Post-Installation Verification

Verify the new file system layout:

cd /u01/app/FBS
ls -ltr
# Expected output:
# db (oracle home)
# fs1 (run file system)
# fs2 (patch file system)
# fs_ne (non-editioned file system)

5. Rapid Install Upgrade

5.1 Enable Maintenance Mode

Source the run file system environment and enable maintenance mode:

. /u01/app/FBS/fs1/EBSapps/appl/APPSFBS_fbsebs.env
adadmin

ADAdmin Menu:

Select Option 5: Change Maintenance Mode
Select Option 1: Enable Maintenance Mode
Exit ADAdmin

5.2 Apply AD 12.2 Upgrade Driver

Download Required Patches:

Patch 10117518
Patch 33526872

Copy adgrants.sql to DB Home:

sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps

Merge Patches:

admrgpch -s /u01/app/FBS/fs_ne/EBSapps/patch/AD_source \
         -d /u01/app/FBS/fs_ne/EBSapps/patch/AD_target \
         -merge_name ad_cup13_patch -admode

Apply the Merged Patch:

cd /u01/app/FBS/fs_ne/EBSapps/patch/AD_target
adpatch

When prompted, enter the merge driver file: u_ad_cup13_patch.drv

5.3 Fix Timestamp Mismatch

Download and apply Patch 17268684:

cp 17268684/admin/ADZDDTFIX.sql $ORACLE_HOME/appsutil/admin
sqlplus system/manager
SQL> @ADZDDTFIX.sql

Re-execute the script to verify no pending timestamp mismatch issues remain.

5.4 Apply Consolidated Upgrade Patch

Download Patch 34754463 and apply it:

cd /u01/app/FBS/fs_ne/EBSapps/patch/34754463
adpatch preinstall=y

Merge with American English Driver:

cd $AU_TOP/patch/115/driver
admrgpch -d . -preinstall -master u10124646.drv

Apply the Merged Patch:

adpatch options=nocopyportion,nogenerateportion

When prompted, enter: u_merged.drv

Note: This process may take approximately 3 hours.

5.5 Tablespace Autoextend

If you encounter tablespace errors during patching:

-- Check tablespace status
select file_name, bytes/1024/1024, autoextensible 
from dba_data_files 
where tablespace_name='APPS_TS_TX_DATA';

-- Enable autoextend
alter database datafile '/path/to/datafile.dbf' autoextend on;

5.6 Verify Patch Application

select bug_number from ad_bugs where bug_number='34754463';

5.7 Disable Maintenance Mode

adadmin

Select Option 5 (Change Maintenance Mode), then Option 2 (Disable Maintenance Mode).

5.8 Run AutoConfig

cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh

6. Application Tier Configuration

6.1 Configure via Rapid Install

Launch RapidWiz again to configure the application tier:

cd /mnt/stage1220/startCD/Disk1/rapidwiz/
./rapidwiz

Configuration Steps:

Click Next on Welcome Screen

Select Upgrade Option

Don't provide email address (click Next, then Yes)

Select "Configure Upgrade Release 12.2.0 Instance"

Browse and select: /u01/app/FBS/fs1/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml

Enter WebLogic password

Verify all pre-checks pass

Confirm database and middle-tier information

Click Next to start configuration (approximately 1 hour)

7. Online Patching Enablement

7.1 Prerequisite Reports

Source the run file system and create the output directory:

. /u01/app/FBS/fs1/EBSapps/appl/APPSFBS_fbsebs.env
mkdir -p $LOG_HOME/appl/op
cd $LOG_HOME/appl/op

7.2 Run Readiness Reports

Summary Report (ADZDPSUM.sql):

sqlplus system/manager
@$AD_TOP/sql/ADZDPSUM.sql
mv adzdpsum.txt adzdpsum_pre_dbprep.txt

Manual Violations Report (ADZDPMAN.sql):

sqlplus system/manager
@$AD_TOP/sql/ADZDPMAN.sql
mv adzdpman.txt adzdpman_pre_dbprep.txt

Automatic Fixes Report (ADZDPAUT.sql):

sqlplus system/manager
@$AD_TOP/sql/ADZDPAUT.sql
mv adzdpaut.txt adzdpaut_pre_dbprep.txt

7.3 Tablespace Space Validation

Verify tablespace free space:

perl $AD_TOP/bin/adzdreport.pl apps

Select Option 3 (Other Generic Reports), then Option 3 (Free Space in Important Tablespaces).

Minimum Space Requirements:

SYSTEM Tablespace: 25 GB free
APPS_TS_SEED Tablespace: 5 GB free
APPS_TS_TX_DATA Tablespace: Adequate space for growth
APPS_TS_TX_IDX Tablespace: Adequate space for growth

7.4 Database Compatibility Check

sqlplus "/as sysdba"
SQL> show parameter compatible

-- If value is 11.1.0, change to 12.1.0
SQL> alter system set compatible='12.1.0' scope=spfile;
SQL> shutdown immediate
SQL> startup

7.5 Pre-Enablement Status Report

sqlplus apps @$AD_TOP/sql/ADZDEXRPT.sql
mv adzdexrpt.txt adzdexrpt_pre_dbprep.txt

7.6 Apply Online Patching Enablement Patch

Download Patch 13543062 and apply in hotpatch mode:

cd /u01/app/FBS/fs_ne/EBSapps/patch
unzip p13543062_R12.AD.C_R12_GENERIC.zip
cd 13543062
adpatch options=hotpatch,forceapply

7.7 Troubleshooting Common Issues

Issue 1: Service Name Exists

-- Check for existing service
select SERVICE_ID, NAME from dba_services;

-- Remove ebs_patch service if it exists
begin
  DBMS_SERVICE.STOP_SERVICE(service_name => 'ebs_patch');
  DBMS_SERVICE.DELETE_SERVICE(service_name => 'ebs_patch');
end;
/

Issue 2: Missing xdb_migrateschema Package

-- Check if package exists
select owner, object_name from dba_objects 
where object_name like upper('xdb_migrateschema');

-- If missing, create it
conn / as sysdba
@?/rdbms/admin/dbmsxdbschmig.sql
@?/rdbms/admin/prvtxdbschmig.plb

Issue 3: Invalid AD_ZD_PREP Package

-- Recompile the package
alter package apps.AD_ZD_PREP compile body;

-- After compilation, continue with upgrade
adctrl -- to restart failed worker

7.8 Monitor Enablement Progress

Monitor DDL execution status:

sqlplus apps @$AD_TOP/sql/ADZDSHOWDDLS.sql

The report should show all phases completed with:

"Successfully Executed" count
"Not Executed" count: 0
"Failed Execution" count: 0

7.9 Post-Enablement Validation

Re-run Status Report:

sqlplus apps @$AD_TOP/sql/ADZDEXRPT.sql
mv adzdexrpt.txt adzdexrpt_post_dbprep.txt

Re-run Readiness Reports:

sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
mv adzdpsum.txt adzdpsum_post_dbprep.txt

sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
mv adzdpman.txt adzdpman_post_dbprep.txt

sqlplus system @$AD_TOP/sql/ADZDPAUT.sql
mv adzdpaut.txt adzdpaut_post_dbprep.txt

7.10 Database Compliance Checker

Run the compliance checker to verify coding standards:

sqlplus apps @$AD_TOP/sql/ADZDDBCC.sql

Configure Required Parameters:

-- Disable recyclebin
ALTER SYSTEM SET recyclebin = OFF SCOPE = spfile;

-- Enable system triggers
ALTER SYSTEM SET "_system_trig_enabled" = TRUE SCOPE = both;

7.11 Compile Invalid Objects

sqlplus apps/apps
exec sys.utl_recomp.recomp_parallel

8. Post-Upgrade Verification

8.1 Verify File System Layout

cd /u01/app/FBS
ls -ltr
# Should show: db, fs1, fs2, fs_ne

8.2 Verify Services

. /u01/app/FBS/fs1/EBSapps/appl/APPSFBS_fbsebs.env
adop status
adop phase_status

8.3 Verify Patches Applied

select bug_number, patch_name, status 
from ad_applied_patches 
order by apply_date desc;

8.4 Verify Online Patching Enabled

select * from dba_editions;
-- Should show editions including: ORA$BASE, APPS_NE, PATCH

8.5 Start Application Services

$ADMIN_SCRIPTS_HOME/adstrtal.sh

9. References

Oracle Support Documents:

R12.2: How To Create the Stage In Preparation For Installation (Doc ID 1596433.1)
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Oracle E-Business Suite Release 12.2: Suite-Wide Rollup and AD/TXK Delta Information (Doc ID 1583092.1)
Applying the Latest AD and TXK Release Update Packs (Doc ID 1617461.1)
Using the Online Patching Readiness Report (Doc ID 1531121.1)
12.2 E-Business Suite DBA Upgrade Script Fails On Invalid Object (Doc ID 2066607.1)

Oracle Documentation:

Oracle E-Business Suite Installation Guide for Release 12.2

10. Important Notes

Patience Required: The entire upgrade process can take 8-12 hours or more depending on the environment size
Backup First: Always perform a full backup before starting the upgrade
Tablespace Space: Ensure sufficient tablespace space before beginning the online patching enablement
Service Shutdown: All middle-tier services should be shut down during the online patching enablement
Monitoring: Monitor database alert logs and patch logs throughout the process
Invalid Objects: Address any invalid objects immediately when detected

This concludes the upgrade from Oracle E-Business Suite Release 12.1.3 to Release 12.2.0. The system is now ready for subsequent code level upgrades to the latest release.

Pages

5b. Upgrade Oracle EBS R12.1.3 to R12.2.0 on 19c database