ORACLE E-BUSINESS SUITE

                  ORACLE E-BUSINESS SUITE

Upgrade Prompts & Execution Guide

Release 12.1.3  →  Release 12.2.11  |  Database 11g/12c  →  19c

Source Version	Target Version
EBS 12.1.3	EBS 12.2.11
Database 11g or 12c	Oracle Database 19c

 

Prepared by: DBA / Applications Team

Classification: Internal — Restricted

 

1. Upgrade Overview & Architecture

This document provides the complete set of prompts, commands, and procedures for upgrading Oracle E-Business Suite (EBS) from Release 12.1.3 to Release 12.2.11 and the underlying Oracle Database from 11g/12c to Oracle Database 19c.

 

1.1 Upgrade Path Summary

Component	From Version	To Version	Method
Oracle EBS Application	12.1.3	12.2.11	Multi-step via R12.2.x
Oracle Database	11.2.0.4 / 12.1 / 12.2	19c (19.x)	DBUA or Manual
Oracle Application Server	Included (OC4J)	WebLogic 12.2.1.4+	Replaced by upgrade
Oracle Forms/Reports	10g	12c	Included in EBS upgrade
JDK	6/7	8 (min) or 11	Replaced during upgrade
RDBMS OS	Linux x86-64 / AIX / HP-UX	Linux x86-64 (recommended)	Verify compatibility

 

1.2 High-Level Upgrade Sequence

1.    Pre-upgrade assessment and preparation

2.    Upgrade Oracle Database to 19c (can run in parallel with EBS prep)

3.    Apply EBS 12.2 base installation prerequisites

4.    Upgrade EBS from 12.1.3 to 12.2.0 (R12.AD.C.Delta.9 required)

5.    Apply EBS 12.2 online patching enablement

6.    Upgrade EBS from 12.2.0 to 12.2.11 (using RUP - Release Update Pack)

7.    Apply recommended one-off patches and product patches

8.    Post-upgrade validation and testing

 

⚠ CRITICAL NOTE:  EBS 12.2 requires Online Patching (adop). The upgrade to 12.2 fundamentally changes how patching works. There is no direct upgrade path from 12.1.3 to 12.2.11 in a single step. You must first upgrade to 12.2.0, enable online patching, then apply the 12.2.11 Release Update Pack.

 

2. Pre-Upgrade Assessment Prompts

2.1 Environment Inventory Check

Execute the following SQL and OS prompts to capture the current environment baseline.

 

2.1.1 EBS Application Version

▶  SQL — EBS Release Information

SELECT RELEASE_NAME, BASELINE_NAME

FROM   FND_PRODUCT_GROUPS;

SELECT APPLICATION_SHORT_NAME, PATCH_LEVEL

FROM   FND_PRODUCT_INSTALLATIONS

ORDER  BY APPLICATION_SHORT_NAME;

 

2.1.2 Database Version & Parameters

▶  SQL — Database Version

SELECT * FROM V$VERSION;

SELECT NAME, VALUE

FROM   V$PARAMETER

WHERE  NAME IN (

'db_name','db_unique_name','compatible',

'db_block_size','character_set','nls_characterset',

'sga_target','pga_aggregate_target',

'undo_management','undo_tablespace',

'open_cursors','session_cached_cursors'

);

 

2.1.3 Installed Products Check

▶  SQL — Licensed & Installed Products

SELECT A.APPLICATION_SHORT_NAME,

A.APPLICATION_NAME,

I.STATUS, I.PATCH_LEVEL,

I.LAST_UPDATE_DATE

FROM   FND_APPLICATION_TL A,

FND_PRODUCT_INSTALLATIONS I

WHERE  A.APPLICATION_ID = I.APPLICATION_ID

AND    I.STATUS IN ('I','S')

ORDER  BY A.APPLICATION_SHORT_NAME;

 

2.1.4 AD/TXK Version Check

▶  SQL — AD and TXK Patch Levels

SELECT BUG_NUMBER, CREATION_DATE, LAST_UPDATE_DATE

FROM   AD_BUGS

WHERE  BUG_NUMBER IN (

SELECT MAX(BUG_NUMBER)

FROM   AD_BUGS

WHERE  BUG_NUMBER LIKE '12%'

);

-- Check AD minipack

SELECT PATCH_LEVEL FROM FND_PRODUCT_INSTALLATIONS

WHERE  APPLICATION_ID = 50;

 

2.1.5 Concurrent Managers Status

▶  SQL — Check Active Concurrent Managers

SELECT CQ.CONCURRENT_QUEUE_NAME,

CQ.ENABLED_FLAG,

CQ.RUNNING_PROCESSES,

CQ.MAX_PROCESSES

FROM   FND_CONCURRENT_QUEUES CQ

WHERE  CQ.ENABLED_FLAG = 'Y'

ORDER  BY CQ.CONCURRENT_QUEUE_NAME;

 

2.2 System Requirements Validation

2.2.1 OS & Kernel Parameters

▶  BASH — OS Pre-check Script

#!/bin/bash

echo '=== OS Version ==='

cat /etc/os-release

echo '=== Kernel ==='

uname -r

echo '=== CPU / Memory ==='

nproc && free -g

echo '=== Disk Space ==='

df -h /u01 /tmp /var/tmp

echo '=== Swap ==='

swapon -s

echo '=== /etc/hosts ==='

cat /etc/hosts | grep -v '^#'

echo '=== ulimits ==='

ulimit -a

 

2.2.2 ORACLE_HOME Environment

▶  BASH — Validate Environment Variables

echo "ORACLE_HOME  : $ORACLE_HOME"

echo "ORACLE_SID   : $ORACLE_SID"

echo "TWO_TASK     : $TWO_TASK"

echo "APPS_BASE    : $APPS_BASE"

echo "EBS_BASE     : $EBS_BASE"

echo "PATH         : $PATH"

echo "LD_LIBRARY_PATH: $LD_LIBRARY_PATH"

# Verify Oracle software owner

id oracle

id applmgr

 

📋 CHECKLIST:  Before proceeding: verify minimum 150GB free on APPS filesystem, 50GB on DB filesystem, swap = 2x RAM (up to 32GB), Oracle Inventory writable.

 

3. Oracle Database 19c Upgrade Prompts

3.1 Pre-Upgrade — Database Side

3.1.1 Run Oracle Pre-Upgrade Tool

Oracle provides the preupgrade.jar utility with Database 19c. Copy it to the source database server and execute:

▶  BASH — Run Pre-Upgrade Information Tool

# Copy from 19c ORACLE_HOME to a temp location

cp $ORACLE_HOME_19C/rdbms/admin/preupgrade.jar /tmp/

# Run as SYSDBA on source database

java -jar /tmp/preupgrade.jar TERMINAL TEXT

# Review the output file

cat /u01/app/oracle/cfgtoollogs/db/preupgrade/preupgrade.log

cat /u01/app/oracle/cfgtoollogs/db/preupgrade/preupgrade_fixups.sql

 

3.1.2 Run Pre-Upgrade Fixups

▶  SQL — Execute Pre-Upgrade Fixups

-- Connect to source database as SYS

sqlplus / as sysdba

-- Run the fixup script generated by preupgrade.jar

@/u01/app/oracle/cfgtoollogs/db/preupgrade/preupgrade_fixups.sql

-- Gather fixed objects statistics

EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

-- Gather dictionary statistics

EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

 

3.1.3 Check and Purge Recyclebin

▶  SQL — Purge and Check DBA Recyclebin

-- Check recyclebin size

SELECT OWNER, COUNT(*)

FROM   DBA_RECYCLEBIN

GROUP  BY OWNER ORDER BY 2 DESC;

-- Purge recyclebin

PURGE DBA_RECYCLEBIN;

-- Validate invalid objects

SELECT OWNER, OBJECT_TYPE, COUNT(*)

FROM   DBA_OBJECTS WHERE STATUS = 'INVALID'

GROUP  BY OWNER, OBJECT_TYPE

ORDER  BY 1, 2;

 

3.1.4 Backup Before DB Upgrade

▶  RMAN — Full Cold Backup

rman target /

RMAN> SHUTDOWN IMMEDIATE;

RMAN> STARTUP MOUNT;

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

RMAN> ALTER DATABASE OPEN;

RMAN> LIST BACKUP SUMMARY;

 

3.2 Oracle Database 19c Installation

3.2.1 Install Oracle DB 19c Software (Silent Mode)

▶  BASH — Silent Installation

# Extract 19c software

unzip LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.0.0/db_1

# Run installer in silent mode

cd /u01/app/oracle/product/19.0.0/db_1

./runInstaller -silent -ignorePrereqFailure \

-responseFile /tmp/db_install.rsp \

oracle.install.option=INSTALL_DB_SWONLY \

ORACLE_BASE=/u01/app/oracle \

ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1 \

oracle.install.db.InstallEdition=EE \

DECLINE_SECURITY_UPDATES=true

 

3.2.2 Apply Latest 19c RU (Release Update)

▶  BASH — Apply 19c RU via OPatch

# Stop DB, set new ORACLE_HOME

export ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

# Verify OPatch version (must be >= 12.2.0.1.22)

$ORACLE_HOME/OPatch/opatch version

# Apply RU patch

cd /tmp/RU_PATCH_DIR

$ORACLE_HOME/OPatch/opatch apply

# Verify patch applied

$ORACLE_HOME/OPatch/opatch lspatches

 

3.3 Database Upgrade Execution

3.3.1 Upgrade via DBUA (Recommended)

▶  BASH — Launch Database Upgrade Assistant

# Set 19c ORACLE_HOME

export ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

# Launch DBUA (GUI or silent mode)

$ORACLE_HOME/bin/dbua

# Silent DBUA for non-GUI environments

$ORACLE_HOME/bin/dbua -silent \

-sid EBSDB \

-oracleHome $ORACLE_HOME \

-sysDBAUserName sys \

-sysDBAPassword <SYS_PASSWORD>

 

3.3.2 Manual Upgrade (Alternative)

▶  SQL — Manual DB Upgrade Steps

-- Startup upgrade mode in 19c ORACLE_HOME

STARTUP UPGRADE;

-- Run upgrade script

SPOOL /tmp/upgrade.log

@$ORACLE_HOME/rdbms/admin/catupgrd.sql

SPOOL OFF

-- Restart and compile invalid objects

SHUTDOWN IMMEDIATE;

STARTUP;

@$ORACLE_HOME/rdbms/admin/utlrp.sql

 

3.3.3 Post-Upgrade Validation

▶  SQL — Post-Upgrade Database Checks

-- Check DB version

SELECT BANNER FROM V$VERSION;

-- Run post-upgrade fixups

@$ORACLE_HOME/rdbms/admin/postupgrade_fixups.sql

-- Check for invalid objects

SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS='INVALID';

-- Check DB registry (all components VALID)

SELECT COMP_ID, VERSION, STATUS

FROM   DBA_REGISTRY

ORDER  BY COMP_ID;

-- Upgrade timezone file

EXEC DBMS_DST.BEGIN_UPGRADE(32);

 

🔑 KEY:  After DB upgrade to 19c, set COMPATIBLE parameter: ALTER SYSTEM SET COMPATIBLE='19.0.0' SCOPE=SPFILE; and restart. Do NOT do this until EBS compatibility is verified.

 

4. EBS 12.1.3 to 12.2 Upgrade Prompts

4.1 EBS Pre-Upgrade Preparation

4.1.1 Download Required Patches

Download the following patches from My Oracle Support (MOS) before starting the upgrade:

Patch / RUP	Description	MOS Doc
Patch 17076514	R12.AD.C.Delta.9 (required for 12.2 upgrade)	Doc 1617461.1
Patch 17076512	R12.TXK.C.Delta.9 (required for 12.2 upgrade)	Doc 1617461.1
Patch 19271775	EBS 12.2.0 Upgrade Driver	Doc 1983399.1
Patch 22063141	EBS 12.2.4 Release Update Pack	Doc 1999069.1
Patch 33733014	EBS 12.2.11 Release Update Pack	Doc 2853939.1
Patch 30484052	Interoperability patch for DB 19c	Doc 2594718.1

 

4.1.2 Apply R12.AD.C.Delta.9 Prerequisites

▶  BASH — Apply AD/TXK Delta Patches

# Source environment

. /u01/app/applmgr/apps/apps_st/appl/APPS<SID>_<HOST>.env

# Apply R12.AD.C.Delta.9

cd /tmp/17076514

adpatch options=nocopypatchedfiles

# Apply R12.TXK.C.Delta.9

cd /tmp/17076512

adpatch options=nocopypatchedfiles

# Run adadmin to compile invalid objects

adadmin

 

4.1.3 Disable All Customizations & Concurrent Requests

▶  SQL — Stop Scheduled Requests & Lock Users

-- Disable all scheduled concurrent requests

UPDATE FND_CONCURRENT_REQUESTS

SET    PHASE_CODE = 'C', STATUS_CODE = 'X'

WHERE  PHASE_CODE IN ('P','I') AND STATUS_CODE = 'S';

COMMIT;

-- Disable all users except SYSADMIN

UPDATE FND_USER

SET    END_DATE = SYSDATE - 1

WHERE  USER_NAME NOT IN ('SYSADMIN','GUEST','APPLSYS')

AND    (END_DATE IS NULL OR END_DATE > SYSDATE);

COMMIT;

 

4.2 EBS 12.2.0 Upgrade Execution

4.2.1 Stop All EBS Services

▶  BASH — Shutdown EBS Application Tier

# Source EBS environment

. /u01/app/applmgr/apps/apps_st/appl/APPS<SID>_<HOST>.env

# Stop all application tier services

perl $FND_TOP/bin/adstpall.sh apps/<APPS_PWD>

# Stop Apache/WebLogic (if applicable)

adopmnctl.sh stop

adstopws.sh

# Verify all services stopped

adopmnctl.sh status

 

4.2.2 Run 12.2 Upgrade Utility (adcfgclone / autoconfig)

▶  BASH — Run AutoConfig Before Upgrade

# Run autoconfig on DB node

cd $ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>

perl adautocfg.sh appspass=<APPS_PWD>

# Run autoconfig on Apps node

cd $ADMIN_SCRIPTS_HOME

perl adautocfg.sh appspass=<APPS_PWD>

# Verify autoconfig completed without errors

grep -i error /u01/app/applmgr/inst/apps/<CTX>/logs/appl/admin/log/adconfig.log

 

4.2.3 Execute the 12.2 Upgrade Driver

▶  BASH — Apply EBS 12.2 Upgrade Patch

# Apply the main 12.2 upgrade patch

cd /tmp/19271775

adpatch patchtop=/tmp/19271775 \

driver=u19271775.drv \

logfile=ebs1220_upgrade.log \

workers=<NUM_WORKERS> \

options=nocompiledb,nohtmlmsg

# Monitor the upgrade log

tail -f /u01/app/applmgr/apps/apps_st/appl/admin/<SID>/log/ebs1220_upgrade.log

 

4.3 Enable Online Patching (EBS 12.2 Key Step)

Online Patching (adop) is the foundational feature of EBS 12.2. It uses a dual filesystem to allow patching without downtime. This step is mandatory.

 

4.3.1 Verify Online Patching Readiness

▶  SQL — Check Online Patching Status

-- Check if online patching is enabled

SELECT PATCH_MODE FROM AD_PATCH_RUN

WHERE ROWNUM = 1 ORDER BY START_DATE DESC;

-- Check editions

SELECT EDITION_NAME, EDITION_TYPE, STATUS

FROM   DBA_EDITIONS;

-- Check editioning views

SELECT COUNT(*) AS EDITIONING_VIEW_COUNT

FROM   DBA_VIEWS

WHERE  VIEW_NAME LIKE '%#';

 

4.3.2 Enable adop Online Patching

▶  BASH — Initialize adop Patching Framework

# Source EBS 12.2 environment

. /u01/app/applmgr/EBSapps.env run

# Verify adop is in PATH

which adop

adop -version

# Run adop prepare phase to create patch edition

adop phase=prepare

# Apply patch (example with patch 33733014 for 12.2.11 RUP)

adop phase=apply patches=33733014

# Finalize and cutover

adop phase=finalize

adop phase=cutover

adop phase=cleanup

 

ℹ ADOP PHASES:  prepare → apply → finalize → cutover → cleanup. Never skip phases. If an error occurs, run: adop phase=abort to safely roll back.

 

5. Applying EBS 12.2.11 Release Update Pack

5.1 Pre-RUP Checks

▶  SQL — Verify Current EBS 12.2 Patch Level

SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS;

SELECT BUG_NUMBER, CREATION_DATE

FROM   AD_BUGS

WHERE  BUG_NUMBER = '33733014';  -- 12.2.11 RUP

-- Confirm no patch edition open

SELECT COUNT(*) FROM DBA_EDITIONS

WHERE  EDITION_NAME LIKE 'PATCH%';

 

5.2 Apply 12.2.11 RUP via adop

▶  BASH — Full adop Cycle for 12.2.11 RUP

# Source EBS environment (Run Edition)

. /u01/app/applmgr/EBSapps.env run

# Check environment

adop phase=diagnose

# STEP 1: Prepare (creates patch edition)

adop phase=prepare

# STEP 2: Apply 12.2.11 RUP

adop phase=apply patches=33733014 \

workers=<NUM_WORKERS> \

merge=yes

# STEP 3: Finalize

adop phase=finalize

# STEP 4: Cutover (brief downtime ~10-20 min)

adop phase=cutover

# STEP 5: Cleanup (remove old editions)

adop phase=cleanup abandon=yes

 

5.3 Post-RUP Validation

▶  SQL — Validate 12.2.11 RUP Applied

-- Confirm EBS version

SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS;

-- Expected: 12.2.11

-- Check AD patch level

SELECT PATCH_LEVEL FROM FND_PRODUCT_INSTALLATIONS

WHERE  APPLICATION_ID = 50;

-- Verify patch in applied list

SELECT BUG_NUMBER, LAST_UPDATE_DATE

FROM   AD_APPLIED_PATCHES

WHERE  BUG_NUMBER = '33733014';

 

▶  BASH — Compile Invalid Objects Post-RUP

# Run adadmin to compile invalid objects

adadmin

> Compile/Reload Utilities > Compile Invalid Objects

# Or directly:

sqlplus apps/<APPS_PWD> @$AD_TOP/sql/adcompsc.pls apps apps

# Regenerate JAR files

adadmin

> Maintain Applications Files > Regenerate Product JAR Files

 

6. EBS – Oracle Database 19c Interoperability

6.1 Apply DB 19c Interoperability Patch

Apply the EBS-DB 19c interoperability patch on the EBS application tier to ensure compatibility with Database 19c.

▶  BASH — Apply Interoperability Patch 30484052

# Source EBS run environment

. /u01/app/applmgr/EBSapps.env run

# Start adop prepare

adop phase=prepare

# Apply interoperability patch

adop phase=apply patches=30484052

# Complete patching cycle

adop phase=finalize

adop phase=cutover

adop phase=cleanup abandon=yes

 

6.2 Validate DB Connection from EBS

▶  SQL — EBS Connection Test via DB Link

-- Test APPS schema connection

sqlplus apps/<APPS_PWD>

SQL> SELECT SYSDATE FROM DUAL;

-- Verify DB version seen from EBS

SELECT * FROM V$VERSION;

-- Check NLS settings critical for EBS

SELECT PARAMETER, VALUE FROM NLS_DATABASE_PARAMETERS

WHERE  PARAMETER IN (

'NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET',

'NLS_LANGUAGE','NLS_TERRITORY','NLS_DATE_FORMAT'

);

 

6.3 Oracle Database 19c Parameters for EBS 12.2

Parameter	Recommended Value	Notes
compatible	19.0.0	Set after upgrade confirmed
cursor_sharing	EXACT	Required for EBS
db_block_size	8192	Standard for EBS
enable_ddl_logging	FALSE	Reduces overhead
event	10946 trace name context forever	For EBS only
max_string_size	STANDARD	Do NOT change to EXTENDED
nls_length_semantics	BYTE	Critical — do NOT change
open_cursors	600	Minimum for EBS
optimizer_adaptive_plans	FALSE	Recommended for EBS 12.2
optimizer_adaptive_statistics	FALSE	Recommended for EBS 12.2
parallel_max_servers	8	Adjust per workload
pga_aggregate_target	4G	Adjust per environment
sga_target	16G+	Adjust per environment
undo_retention	900	Minimum 900 seconds
use_large_pages	ONLY	If HugePages configured on OS

 

▶  SQL — Apply Key Parameters for EBS on DB 19c

ALTER SYSTEM SET cursor_sharing=EXACT SCOPE=BOTH;

ALTER SYSTEM SET optimizer_adaptive_plans=FALSE SCOPE=BOTH;

ALTER SYSTEM SET optimizer_adaptive_statistics=FALSE SCOPE=BOTH;

ALTER SYSTEM SET open_cursors=600 SCOPE=BOTH;

ALTER SYSTEM SET undo_retention=900 SCOPE=BOTH;

ALTER SYSTEM SET nls_length_semantics=BYTE SCOPE=SPFILE;

-- Restart for SPFILE-only parameters

SHUTDOWN IMMEDIATE;

STARTUP;

 

7. Post-Upgrade Validation Prompts

7.1 Application Tier Validation

7.1.1 Start EBS Services

▶  BASH — Start All EBS Services

# Source EBS run environment

. /u01/app/applmgr/EBSapps.env run

# Start all services

perl $FND_TOP/bin/adstrtal.sh apps/<APPS_PWD>

# Verify services status

adopmnctl.sh status

# Check WebLogic managed servers

admanagedsrvctl.sh status oacore_server1

admanagedsrvctl.sh status oafm_server1

admanagedsrvctl.sh status forms_server1

 

7.1.2 Check EBS Login Page

▶  BASH — URL Connectivity Test

# Test EBS URL responds (replace with actual hostname/port)

curl -sk https://<HOSTNAME>:<PORT>/OA_HTML/AppsLogin | grep -i 'oracle'

# Check WebLogic admin console

curl -sk http://<HOSTNAME>:7001/console/

# Check HTTP Server

curl -I http://<HOSTNAME>:<PORT>/OA_HTML/

 

7.2 Database Post-Upgrade Checks

▶  SQL — Complete Post-Upgrade Validation

-- 1. DB Version

SELECT BANNER FROM V$VERSION;

-- 2. Registry Components

SELECT COMP_ID, COMP_NAME, VERSION, STATUS

FROM   DBA_REGISTRY ORDER BY COMP_ID;

-- 3. Invalid Objects Count

SELECT OWNER, COUNT(*) FROM DBA_OBJECTS

WHERE  STATUS = 'INVALID' GROUP BY OWNER ORDER BY 2 DESC;

-- 4. Tablespace Usage

SELECT TABLESPACE_NAME,

ROUND((BYTES-FREE_SPACE)/1024/1024/1024,2) USED_GB,

ROUND(FREE_SPACE/1024/1024/1024,2) FREE_GB

FROM DBA_FREE_SPACE_COALESCED

ORDER BY 1;

-- 5. Alert log errors (last 24h)

SELECT ORIGINATING_TIMESTAMP, MESSAGE_TEXT

FROM   V$DIAG_ALERT_EXT

WHERE  ORIGINATING_TIMESTAMP > SYSDATE - 1

AND    MESSAGE_TEXT LIKE '%ORA-%'

ORDER  BY 1 DESC;

 

7.3 Functional Smoke Tests

Area	Test Action	Expected Result
Login	Login as SYSADMIN to EBS	Home page loads without errors
Concurrent Processing	Submit a standard concurrent request	Request completes with Normal status
Financials — GL	Open General Ledger responsibility	Journal entry screen accessible
Order Management	Query an existing order	Order details display correctly
Purchasing	Open iProcurement or PO module	PO creation screen accessible
HR/Payroll	Open HRMS responsibility	Employee query returns results
Workflow	Check Workflow Background Process	No stuck workflows; process runs
Forms	Open any Forms-based screen	Forms JInitiator/Java loads correctly
OAF Pages	Open any OAF-based page	Page loads without Java errors
Reports	Run a standard FSG report	Report generates successfully

 

8. Common Issues & Troubleshooting Prompts

8.1 adop Failures

▶  BASH — Diagnose adop Errors

# Check adop session status

adop phase=status

# Review adop log files

ls -lt $APPL_TOP_NE/../log/adop*/

tail -200 $APPL_TOP_NE/../log/adop*/adop_*.log

# Check for worker failures

grep -i 'error\|failed\|ora-' \

$APPL_TOP_NE/../log/adop*/adworker*.log | head -50

# Abort failed session if needed

adop phase=abort

 

8.2 Database Upgrade Failures

▶  SQL — Check Upgrade Status After Failure

-- Check catupgrd status

SELECT COMP_ID, VERSION, STATUS

FROM   DBA_REGISTRY

WHERE  STATUS != 'VALID';

-- Recompile invalid objects

@$ORACLE_HOME/rdbms/admin/utlrp.sql

-- If upgrade failed, check alert log

-- (replace path with actual ADR location)

tail -500 /u01/app/oracle/diag/rdbms/<DB>/<SID>/trace/alert_<SID>.log

 

8.3 ORA-Errors Common in EBS 12.2 on DB 19c

Error	Cause	Resolution
ORA-04031	Shared pool memory insufficient	Increase SGA; check memory_target
ORA-01555	Snapshot too old (undo)	Increase undo_retention and undo tablespace
ORA-04020	Deadlock during library cache load	Bounce application services; check cursor_sharing=EXACT
ORA-00600 [qerltcCtxGet]	Adaptive cursor sharing	Set optimizer_adaptive_plans=FALSE
APP-FND-01542	EBS login error — profile not set	Run autoconfig; check server URL profile options
FRM-40010	Forms cannot find module	Check $FND_TOP/forms paths; relink forms
WF-0002	Workflow schema error	Run wfinstall.sh; check WF_SCHEMA profile

 

9. Rollback / Abort Procedures

⚠ WARNING:  A full rollback from EBS 12.2 to 12.1.3 is NOT supported by Oracle. The only rollback option is restoring from a full cold backup taken before the upgrade. Ensure backups are verified before starting.

 

9.1 EBS adop Abort (Within Patch Cycle)

▶  BASH — Abort Current adop Patch Session

# Abort the current patching session

adop phase=abort

# If abort fails, manually drop patch edition

sqlplus / as sysdba

SQL> DROP EDITION PATCH_EDITION CASCADE;

# Reset adop state

sqlplus apps/<APPS_PWD>

SQL> EXEC AD_ZD.RESET_PATCH_SESSION;

 

9.2 Restore from RMAN Backup

▶  RMAN — Restore Full Database Backup

# Connect to RMAN

rman target /

# Restore from backup

RMAN> SHUTDOWN ABORT;

RMAN> STARTUP MOUNT;

RMAN> RESTORE DATABASE;

RMAN> RECOVER DATABASE;

RMAN> ALTER DATABASE OPEN RESETLOGS;

# Validate restored database

RMAN> VALIDATE DATABASE;

 

10. Upgrade Completion Checklist

#	Task	Owner	Status
1	Pre-upgrade backups (DB + FS) verified	DBA
2	Pre-upgrade tool (preupgrade.jar) executed and fixups applied	DBA
3	Oracle DB 19c software installed and patched	DBA
4	Database upgraded to 19c via DBUA or manual	DBA
5	DB 19c post-upgrade fixups applied; no invalid objects	DBA
6	EBS 19c interoperability patch 30484052 applied	Apps DBA
7	AD/TXK Delta.9 patches applied (12.1.3 side)	Apps DBA
8	EBS 12.2.0 upgrade driver applied	Apps DBA
9	Online patching (adop) framework enabled and tested	Apps DBA
10	EBS 12.2.11 RUP applied via adop	Apps DBA
11	EBS services started; login page accessible	Apps DBA
12	All concurrent managers running	Apps DBA
13	Functional smoke tests passed (GL, OM, PO, HR)	Functional Team
14	Performance baseline compared	DBA
15	End-users re-enabled and notified	Apps DBA
16	Post-upgrade documentation updated	All

 

 

— End of Oracle EBS 12.1.3 → 12.2.11 + DB 19c Upgrade Guide —