6b. Upgrade Oracle EBS R12.2.0 to R12.2.14 on 19c database

 

Step-by-Step Guide: Applying Required Database Patches and Upgrading Oracle E-Business Suite to Release 12.2.14

6.1 Apply Required Database Patches

Download and Run ETCC (EBS Technology Code Level Checker)

1. Download the latest ETCC patch (Patch 17537119)

The ETCC (EBS Technology Code Level Checker) utility helps identify required database patches for your E-Business Suite environment.

2. Source the database environment and run the check script

bash

# Navigate to ETCC directory
cd /u01/patches/etcc/

# Unzip the ETCC patch
unzip p17537119_R12_GENERIC.zip

# Verify extracted files
ls -ltr

# Run the database patch checker
./checkDBpatch.sh

3. Provide the database context file when prompted

When running checkDBpatch.sh, you'll be prompted to enter the full path to the database context file:

text

Enter full path to database context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml

4. Review the ETCC output

The script will:

• Identify your database release (e.g., 19.27.0.0)

• Detect if you're using a Multitenant architecture (CDB/PDB)

• Check for missing bugfixes

• Generate a log file for review

Important Warning: If you see a warning that the Bugfix XML file is more than 30 days old, download the latest version of ETCC (Patch 17537119) to ensure you're checking against the most current patch recommendations.

Apply Recommended Patches

1. Review the ETCC report to identify required patches (e.g., patch 36925840)

2. Before applying patches:

• Ensure database and application services are down

• Take necessary backups

3. Apply all recommended patches

Verify Patches Applied Successfully

1. Start the database

bash

cd $ORACLE_HOME/OPatch
sqlplus / as sysdba

SQL> startup
SQL> exit

2. Re-run ETCC to verify all patches are applied

bash

./checkDBpatch.sh

---

6.2 Set Database Parameters

Set the _disable_actualization_for_grant parameter

sql

SQL> alter system set "_disable_actualization_for_grant"=true;

SQL> show parameter _disable_actualization_for_grant

NAME                                TYPE       VALUE
------------------------------------ ----------- ------------------------------
_disable_actualization_for_grant    boolean   TRUE

---

6.3 Apply Consolidated Seed Table Upgrade Patch

Note: Skip this step if you've already upgraded to Release 12.2.0 using the latest Consolidated Upgrade Patch 34754463 (CUP15) or earlier versions (CUP10, CUP9, or CUP8).

Prerequisites

1. Stop all application tier services on the run file system:

bash

sh $ADMIN_SCRIPTS_HOME/adstpall.sh

2. Start only the Oracle WebLogic Admin Server on the run file system:

bash

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

Apply the Patch

Apply the consolidated seed table upgrade Patch 34754463 using adop hotpatch mode:

bash

adop phase=apply patches=34754463 hotpatch=yes

Validate that the patch was applied successfully before proceeding.

---

6.4 Apply Latest AD and TXK Delta Release Update Packs

Required Patches

• R12.AD.C.Delta.16 (Patch 36119925)

• R12.TXK.C.Delta.16 (Patch 36117775)

Pre-Application Steps

1. Source the run edition environment:

bash

. <EBS_ROOT>/EBSapps.env run

2. Start the Oracle WebLogic Admin Server:

bash

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

3. Execute adgrants (following instructions in Patch 36119925 readme):

Connect to the pluggable database:

bash

export ORACLE_PDB_SID=FBS

Run adgrants:

bash

$ORACLE_HOME/appsutil/admin/adgrants.sql apps

4. Unlock and reset passwords if needed:

sql

ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;
ALTER USER SYSTEM IDENTIFIED BY K0Junga#;
ALTER USER EBS_SYSTEM IDENTIFIED BY K0Junga#;

Apply AD Delta Patch

Apply Patch 36119925 in hotpatch mode (do not merge with other patches):

bash

adop phase=apply patches=36119925 hotpatch=yes

Apply TXK Delta Patch

Apply Patch 36117775 in hotpatch mode:

bash

adop phase=apply patches=36117775 hotpatch=yes

Apply any additional critical patches if required:

bash

adop phase=apply patches=31904550 merge=yes hotpatch=yes

Verify all patches applied successfully.

---

6.5 Apply Other Important Patches

Apply Patch 19259764:R12.FND.C:

bash

adop phase=apply patches=19259764 hotpatch=yes

---

6.6 Run Middle Tier ETCC

1. Source the run file system:

bash

. <EBS_ROOT>/EBSapps.env run

2. Run the MT-ETCC utility:

bash

./checkMTpatch.sh

Note: All reported patches can be applied later for Middle Tier application.

---

6.7 Apply RUP for 12.2.14

Pre-Application Steps

1. Source the run edition applications environment:

bash

. <EBS_ROOT>/EBSapps.env run

2. Stop Oracle WebLogic Server's Admin Server and Node Manager services:

bash

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

Apply Release Update Pack

Apply Oracle E-Business Suite 12.2.14 Release Update Pack Patch 36026788 using downtime mode:

bash

adop phase=apply apply_mode=downtime patches=36026788

Note: This process typically takes several hours (approximately 14 hours in the example provided).

---

6.8 Complete Patching Cycle

Run cleanup to complete the patching cycle:

bash

. /u01/app/FBS/EBSapps.env run
adop phase=cleanup

---

6.9 Apply Online Help Patch

Apply Oracle E-Business Suite Release 12.2.14 Online Help Patch 36026775 using adop hotpatch mode:

Note: A new patching cycle session will be opened. Ensure tablespaces have sufficient free space.

bash

adop phase=apply patches=36026775 hotpatch=yes
adop phase=cleanup

---

6.10 Update Database Tier to Latest Code

On the Application Tier (as applmgr user)

1. Source the run edition environment:

bash

. <EBS_ROOT>/EBSapps.env run

2. Generate appsutil:

bash

perl $AD_TOP/bin/admkappsutil.pl

3. Copy or FTP the appsutil.zip file to the RDBMS ORACLE_HOME directory.

On the Database Tier (as oracle user)

1. Uncompress appsutil.zip:

bash

cd <ORACLE_HOME>
unzip -o appsutil.zip

2. Run AutoConfig on the database tier:

bash

./adautocfg.sh

Enter the APPS user password when prompted.

On the Application Tier (as applmgr user)

Run AutoConfig on the application run file system:

bash

sh <INST_TOP>/admin/scripts/adautocfg.sh

If you encounter the error: "Directory object does not exist for path: run"

Fix by running these commands:

bash

perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl \
  -contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml \
  -oraclehome=/u01/app/FBS/db/tech_st/19c \
  -outdir=/u01/app/FBS/db/tech_st/19c/appsutil/log \
  -mode=addUtlFileDir

perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl \
  -contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml \
  -oraclehome=/u01/app/FBS/db/tech_st/19c \
  -outdir=/u01/app/FBS/db/tech_st/19c/appsutil/log \
  -mode=syncUtlFileDir

Then source the environment and run AutoConfig again:

bash

. /u01/app/FBS/fs1/EBSapps/appl/APPSFBS_fbsebs.env
adautocfg.sh

---

6.11 Synchronize File Systems

Run the fs_clone command to synchronize file systems:

bash

adop phase=fs_clone

---

7.0 Verify Installation

Verify the upgrade was successful:

sql

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
12.2.14

---

Important Notes and Known Issues

Key Considerations

1. Always use the latest ETCC version (Patch 17537119) as new bugfixes are added regularly

2. Verify database services are running properly after each step

3. Ensure sufficient tablespace free space before applying help patches

4. Review all log files generated during patching for errors

Known Issues Reference

For troubleshooting, refer to:

• https://www.funoracleapps.com/2020/12/the-server-is-not-able-to-service-this.html

Documentation References

• Oracle E-Business Suite Release 12.2.10 Readme (Doc ID 2666934.1)

• Document 1617461.1: Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2

---

Summary of Applied Patches

Step	Patch Number	Description
6.1	17537119	ETCC Utility
6.3	34754463	Consolidated Seed Table Upgrade
6.4	36119925	R12.AD.C.Delta.16
6.4	36117775	R12.TXK.C.Delta.16
6.5	19259764	R12.FND.C
6.7	36026788	R12.2.14 Release Update Pack
6.9	36026775	R12.2.14 Online Help Patch