5a. Upgrade Oracle EBS R12.1.3 to R12.2.0 on 12.1.0 database

Oracle E-Business Suite R12.2.0 Upgrade Guide

Overview

This comprehensive guide documents the step-by-step process of upgrading Oracle E-Business Suite from R12.1.3 to R12.2.0 on Linux x86-64. The upgrade includes database preparation, staging area setup, patching, and online patching enablement.

1. Database Preparation

1.1 Download R12.2.0 Software

  • Download the R12.2.0 software zip files and store them on the server

  • Reference: How to Download EBS 12.2.0

1.2 Add Service for EBS Patch

Connect as sysdba and create the ebs_patch service:

sql
sqlplus / as sysdba
show parameter service
alter system set service_names='FBS,ebs_patch' scope=both;
show parameter service

1.3 Run ETCC (EBS Technology Codelevel Checker)

Download Patch 17537119 and execute the database technology codelevel check:

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

Note: If the bugfix XML file is outdated, always use the latest version of ETCC available in patch 17537119.

ETCC Output Summary:

  • Database version identified: 19.27.0.0

  • Multitenant architecture confirmed

  • Database DST version: 44

  • All required one-off bugfixes are present

2. File System Setup and Staging

2.1 Create New File System Layout

As root, navigate to the directory containing R12.2.0 zip files:

bash
[root@ebstest stage1220]# pwd
/mnt/stage1220
[root@ebstest stage1220]# ls
V100052-01_1of3.zip  V100060-01_1of3.zip  V29856-01.zip       V35804-01_1of2.zip
V100052-01_2of3.zip  V100060-01_2of3.zip  V35802-01.zip       V35804-01_2of2.zip
V100052-01_3of3.zip  V100060-01_3of3.zip  V35803-01_1of3.zip  V46095-01_1of2.zip
V100059-01_1of2.zip  V100061-01.zip       V35803-01_2of3.zip  V46095-01_2of2.zip
V100059-01_2of2.zip  V100102-01.zip       V35803-01_3of3.zip  V75792-01.zip

2.2 Build Staging Area

2.2.1 Verify All Required Zip Files

Confirm all required zip files are present in /mnt/stage1220:

Required Files List:

  • V100052-01_1of3.zip, V100052-01_2of3.zip, V100052-01_3of3.zip (StartCD)

  • V100053-01_1of2.zip, V100053-01_2of2.zip

  • V100054-01.zip

  • V100055-01.zip

  • V100056-01.zip

  • V100057-01.zip

  • V100058-01.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.2.2 Extract StartCD Files

bash
unzip 'V100052*.zip'

This creates the startCD directory.

Verify StartCD Version:

bash
cd /mnt/stage1220/startCD/Disk1/rapidwiz/
./RapidWizVersion
# Output: Version 12.2.0.51

2.2.3 Configure Unzip Utility

The startCD provides the correct version of unzip. Configure it properly:

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

2.2.4 Build the Stage

Navigate to the bin directory and run buildStage.sh:

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

During the build process:

  1. Press Enter to continue

  2. Select Option 1 (Create new stage area)

  3. Select Option 2 (Linux x86-64)

  4. Specify the directory containing zip files: /mnt/stage1220

  5. Confirm when prompted

Note: You may see warnings about missing zip files if you didn't download Vision database components.

After successful staging, the directory structure will include:

text
EBSInstallMedia/
TechInstallMedia/
TechPatches/
startCD/

3. Patching the Stage Area

3.1 Apply Consolidated Fixes

Download Patch 32947483 and apply it to the staging area:

bash
cd /mnt/stage1220/32947483
./patchRIStage.sh

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

3.2 Set Permissions

bash
cd /mnt/stage1220
chmod -R 777 software

3.3 Apply Additional Patches to Staging Area

From the build stage menu:

  1. Select Option 2 (Copy patches to existing stage area)

  2. Select Option 2 (Linux x86-64)

  3. The system will stage one-off patches

Patches applied:

  • 21626377 - Database patch

  • 31136426 - Middle Tier patch

  • 31090393 - Middle Tier patch

4. Linux 8 Compatibility Modifications

Important: This workaround is provided by the EBS user community, not Oracle EBS Development. Apply only if using Linux 8.

4.1 Modify filegroup4.jar

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

Extract the jar file:

bash
jar xvf filegroup4.jar

Replace the libc.so.6 stub with the actual system library:

bash
cd lib/stubs
mv libc.so.6 libc.so.6.safe
cp -p /lib64/libc.so.6 .
cd -

Recreate the jar file:

bash
mv filegroup4.jar filegroup4.jar.safe
jar cvf filegroup4.jar lib

5. EBS 12.2.0 Installation

5.1 Launch RapidWiz

As root user:

bash
cd /u01/stage1220/startCD/Disk1/rapidwiz/
./rapidwiz

Important: Run RapidWiz as root. Ensure the unzip utility is correctly configured.

 

Step 1: Welcome Screen

Click Next

Step 2: Select Upgrade Option

Choose the appropriate upgrade option

Step 3: Security Updates

Uncheck security updates, click Next, then confirm

Step 4: Upgrade Action

Select "Create a New Upgrade File System"

Step 5: Port Configuration

Select Port Pool for file system (same as R12.1 configuration)

Step 6: Database Details

  • Provide current R12.1.3 database details

  • Select "Use Existing Oracle Home"




Step 7: Language and Character Set Configuration

  • Selected Languages: American_English-US

  • Default Territory: AMERICA

  • Database Character Set: AL32UTF8

  • APPL_TOP Character Set: AL32UTF8

  • IANA Character Set: UTF-8


Step 8: File System Location

Provide the path for R12.2 file system layout:

Step 9: WebLogic Password

  • Provide WebLogic password

  • Provide applmgr OS user password



 

Step 10: Pre-Validation

The system will perform pre-checks. Ignore Technology CodeCheck warnings - these patches will be applied later.

 





 

Installation Time: Approximately 4 hours





5.3 Verify Installation

bash
[applmgr@fbsebs FBS]$ pwd
/u01/app/FBS
[applmgr@fbsebs FBS]$ ls -ltr
total 0
drwxr-xr-x. 4 oracle  oinstall 36 Dec  6 12:46 db
drwxr-xr-x. 5 applmgr oinstall 49 Dec 13 09:04 fs1
drwxr-xr-x. 5 applmgr oinstall 49 Dec 13 09:04 fs2
drwxr-xr-x. 4 applmgr oinstall 33 Dec 13 09:57 fs_ne

6. Enable Maintenance Mode

6.1 Source the Environment

Source the R12.2 environment file (use fs1 as the run file system):

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

6.2 Run AD Administration

bash
adadmin

Navigate through the menu:

  1. Select Option 5 (Change Maintenance Mode)

  2. Select Option 1 (Enable Maintenance Mode)

Confirmation: "Successfully enabled Maintenance Mode"

7. Apply AD 12.2 Upgrade Driver

7.1 Download Required Patches

  • 10117518

  • 33526872

7.2 Copy adgrants.sql to Database Oracle Home

bash
cd /u01/app/FBS/db/tech_st/12.1.0/appsutil/admin/
sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps

7.3 Merge Patches

Create AD_source and AD_target directories:

bash
mkdir -p /u01/app/FBS/fs_ne/EBSapps/patch/AD_source
mkdir -p /u01/app/FBS/fs_ne/EBSapps/patch/AD_target

Copy both patches to AD_source and merge:

bash
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

Merge Progress:

  • 5% complete: 47 of 925 files

  • 100% complete: 925 of 925 files

7.4 Apply the Merged Patch

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

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

Duration: Approximately 30 minutes

8. Fix Timestamp Mismatch

8.1 Download Patch

Download 17268684

8.2 Copy Script to Database Oracle Home

bash
cp 17268684/admin/ADZDDTFIX.sql $ORACLE_HOME/appsutil/admin

8.3 Execute as System User

sql
sqlplus system/manager
SQL> @ADZDDTFIX.sql

8.4 Verify Fix

Re-execute the script to check for any pending timestamp mismatch issues. No output indicates success.

9. Apply Consolidated Upgrade Patch

9.1 Configure Database Parameters

Connect as sysdba and verify:

sql
show parameter sec_case_sensitive_logon

If set to TRUE, change to FALSE:

sql
alter system set sec_case_sensitive_logon=false;

9.2 Download Patch

Download 34754463 to the application node.

9.3 Source Environment

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

9.4 Apply Preinstall Patch

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

9.5 Merge with the Master Driver

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

9.6 Apply the Upgrade Patch

bash
adpatch options=nocopyportion,nogenerateportion

When prompted, provide the merge driver file: u_merged.drv

Duration: Approximately 3 hours

9.7 Monitor Database Alert Log

Keep monitoring the database alert log and patch log in separate terminal sessions.

10. Troubleshooting Common Issues

Issue: Tablespace Full

Error:

text
ORA-01653: unable to extend table APPLSYS.AD_PROGRAM_RUN_TASK_JOBS by 16 in tablespace APPS_TS_TX_DATA

Solution:
Enable autoextend on the tablespace datafiles:

sql
select file_name, bytes/1024/1024, autoextensible 
from dba_data_files 
where tablespace_name='APPS_TS_TX_DATA';

alter database datafile '/u01/app/VIS/db/apps_st/data/a_txn_data01.dbf' autoextend on;

Then re-run adpatch.

9.8 Verify Patch Application

sql
select bug_number from ad_bugs where bug_number='34754463';

10. Disable Maintenance Mode

bash
adadmin

  1. Select Option 5 (Change Maintenance Mode)

  2. Select Option 2 (Disable Maintenance Mode)

Confirmation: "Successfully disabled Maintenance Mode"

11. Run AutoConfig on Application Tier

11.1 Verify Autoconfig Table

sql
select object_name, object_type, owner, status 
from dba_objects 
where upper(object_name)='ADX_PRE_AUTOCONFIG' 
  and object_type='TABLE' 
  and upper(owner)='APPS';

11.2 Drop Table (if exists)

sql
sqlplus apps/apps
SQL> @$AD_TOP/patch/115/sql/txkDropAdxPreAutoConfig.sql

11.3 Execute AutoConfig

bash
$ADMIN_SCRIPTS_HOME/adautocfg.sh

12. Configure Application Tier Using RapidWiz

12.1 Launch RapidWiz

As root user:

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

 

12.2 Configuration Steps

  1. Welcome Screen: Click Next

 

  1. Select Upgrade Option: Choose the appropriate option

 

  1. Security Updates: Don't provide email, continue


  1. Select Upgrade Action: Select "Configure Upgrade Release 12.2.0 Instance"

  2. Browse Configuration File:

    text
    /u01/app/FBS/fs1/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml


  1. Enter WebLogic Password: Provide the password set earlier


  1. Validate System Configuration: Ensure all checks pass

 

  1. Validate System Configuration: Ensure all checks pass

 

  1. Verify Database and Middle Tier Information: Confirm details

  1. Confirm: Start configuring EBS 12.2.0

Duration: Approximately 1 hour




13. Enable Online Patching

13.1 Create Directory and Source Environment

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

13.2 Run Readiness Reports

13.2.1 ADZDPSUM.sql - Summary Report

sql
sqlplus system/manager
@$AD_TOP/sql/ADZDPSUM.sql

Rename output: mv adzdpsum.txt adzdpsum_pre_dbprep.txt

Purpose: Provides summary of schemas that will be editioned and schemas with dependencies.

13.2.2 ADZDPMAN.sql - Manual Violations Report

sql
sqlplus system/manager
@$AD_TOP/sql/ADZDPMAN.sql

Rename output: mv adzdpman.txt adzdpman_pre_dbprep.txt

Purpose: Lists objects with EBR rule violations requiring manual fixes.

13.2.3 ADZDPAUT.sql - Automatic Violations Report

sql
sqlplus system/manager
@$AD_TOP/sql/ADZDPAUT.sql

Rename output: mv adzdpaut.txt adzdpaut_pre_dbprep.txt

Purpose: Lists objects with EBR violations that will be fixed automatically.

Important: Ensure sufficient TEMP tablespace space before running these reports.

13.3 Review Readiness Reports

Key Points:

  • Review all sections from ADZDPMAN.sql

  • Register custom schemas using commands from ADZDPSUM.sql last section

  • Do NOT register: SYS, SYSTEM, CTXSYS

  • Use $AD_TOP/sql/ADZDPCUST.sql for custom fixes

  • Repeat reports until all violations are addressed

13.4 Verify Tablespace Free Space

bash
perl $AD_TOP/bin/adzdreport.pl apps

Select:

  1. Option 3 - "Other Generic Reports"

  2. Option 3 - "Free Space in Important Tablespaces"

Required Minimum Free Space:

  • SYSTEM: 25 GB

  • APPS_TS_SEED: 5 GB

13.5 Run Status Report (Pre-Enablement)

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

13.6 Apply Online Patching Enablement Patch

Download Patch 13543062 and apply:

bash
cd /u01/app/VIS/fs_ne/EBSapps/patch/
cp /mnt/stage1220/p13543062_R12.AD.C_R12_GENERIC.zip .
unzip p13543062_R12.AD.C_R12_GENERIC.zip
cd 13543062
adpatch options=hotpatch,forceapply

Important: Use hotpatch and forceapply modes. Do NOT enable maintenance mode.

13.7 Troubleshoot Failed Worker

Error:

text
ORA-44303: service name exists
ORA-06512: at "APPS.AD_ZD_PREP", line 392

Solution: Drop the ebs_patch service if it exists:

sql
sqlplus / as sysdba
select SERVICE_ID, NAME from dba_services;

begin
  DBMS_SERVICE.STOP_SERVICE(service_name =>'ebs_patch');
  DBMS_SERVICE.DELETE_SERVICE(service_name =>'ebs_patch');
end;
/

13.8 Restart Failed Worker

bash
adctrl

  1. Select Option 2 (Tell worker to restart a failed job)

  2. Enter the worker number (e.g., 1)

13.9 Monitor DDL Status

bash
sqlplus apps @$AD_TOP/sql/ADZDSHOWDDLS.sql

Expected Output: Zero count in "Not Executed" and "Failed Execution" sections.

Duration: Approximately 7 hours

14. Compile Invalid Objects

sql
sqlplus apps/apps
exec sys.utl_recomp.recomp_parallel

15. Post-Enablement Verification

15.1 Run Status Report

bash
cd $LOG_HOME/appl/op
sqlplus apps @$AD_TOP/sql/ADZDEXRPT.sql

Purpose: Identify and fix any errors from the enablement process.

15.2 Run Readiness Reports

bash
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

Purpose: Ensure all EBR violations are fixed.

15.3 Run Database Compliance Checker

bash
cd $LOG_HOME/appl/op
sqlplus apps @$AD_TOP/sql/ADZDDBCC.sql

Compliance Levels:

  • Minimal: Minimum requirement for correct operation

  • Full: Required for online patching capability

Important System Parameters:

sql
ALTER SYSTEM SET recyclebin = OFF SCOPE = spfile;
ALTER SYSTEM SET "_system_trig_enabled" = TRUE SCOPE = both;

16. Reference Documentation

Document IDTitle
1596433.1R12.2: How To Create the Stage In Preparation For Installation
1320300.1Oracle E-Business Suite Release Notes, Release 12.2
1583092.1Oracle E-Business Suite Release 12.2: Suite-Wide Rollup and AD/TXK Delta Information
1617461.1Applying the Latest AD and TXK Release Update Packs
1531121.1Using the Online Patching Readiness Report
2066607.112.2 E-Business Suite DBA Upgrade Script Issues

Additional Resources:

Summary of Applied Patches

Patch NumberPurpose
17537119ETCC (EBS Technology Codelevel Checker)
32947483Consolidated fixes for StartCD 12.2.0.51
21626377Database one-off patch
31136426Middle Tier one-off patch
31090393Middle Tier one-off patch
10117518AD 12.2 Upgrade Driver
33526872AD 12.2 Upgrade Driver
17268684Timestamp Mismatch Fix
34754463Consolidated Upgrade Patch
13543062Online Patching Enablement

Next Steps

After completing this upgrade to R12.2.0, proceed with applying the latest code level patches to bring the system to the most recent certified release. This will be covered in a subsequent guide.

This document is a guide only. Always refer to official Oracle documentation for the most up-to-date and certified procedures.






No comments:

Post a Comment

Subscribe to: Posts (Atom)