Oracle E-Business Suite 12.1.3 Upgrade to Database 12c (12.1.0.2)

Overview

This document provides a comprehensive guide for upgrading an Oracle E-Business Suite (EBS) 12.1.3 environment from Oracle Database 11.1.0.7.0 to Oracle Database 12c Release 1 (12.1.0.2). The upgrade process involves applying prerequisite patches, installing the new database binary, performing pre-upgrade checks, executing the database upgrade, and completing post-upgrade tasks.

Prerequisites

Component	Version
Source Database	11.1.0.7.0
EBS Version	12.1.3
Target Database	12.1.0.2
Operating System	Oracle Enterprise Linux

Phase 1: Application Preparation

1.1 Stop Application Services

Place the application in maintenance mode and stop all application services:

# Stop all application services
# Put application in maintenance mode

1.2 Apply Application Patches

Apply the following patches using the adpatch utility:

Patch Number	Description
8796558	Required patch
12923944	Required patch
13473483	Required patch
16289505	12c Release 1 interoperability patch for Release 12.1
18843706	Apply only if a Recommended Patch Collection (RPC) has been applied
19558309	Required patch

Application Commands:

# Apply each patch sequentially
cd /u01/patches/apps/8796558/
adpatch apply=yes driver=u8796558.drv

cd /u01/patches/apps/12923944/
adpatch apply=yes driver=u12923944.drv

cd /u01/patches/apps/13473483/
adpatch apply=yes driver=u13473483.drv

cd /u01/patches/apps/16289505/
adpatch apply=yes driver=u16289505.drv

cd /u01/patches/apps/18843706/
adpatch apply=yes driver=u18843706.drv

cd /u01/patches/apps/19558309/
adpatch apply=yes driver=u19558309.drv

Phase 2: Install Oracle Database 12c Binary

2.1 Create Oracle Home Directory

cd /u01/app/FBS/db/tech_st
mkdir 12.1.0

2.2 Install Database Software

Run the Oracle Universal Installer in silent mode:

cd /path/to/database_installation_files
./runInstaller

Installation Steps:

Uncheck "Receive Security Updates" and click Next (acknowledge warning)

Select Install Database Software Only

Select Single Instance Database Installation

Choose Enterprise Edition

Specify ORACLE_HOME location: /u01/app/FBS/db/tech_st/12.1.0

Use default groups and set all to dba

Run prerequisite checks and proceed with installation

2.3 Run Root Scripts

After installation completes, run the root scripts as the root user:

/u01/app/FBS/db/tech_st/12.1.0/root.sh

2.4 Create 12c Environment File

Copy and modify the 11g environment file:

cp /u01/app/FBS/db/tech_st/11.1.0/FBS_fbsebs.env /u01/app/FBS/db/tech_st/12.1.0/FBS_fbsebs.env

Update the file to replace all 11.1.0 references with 12.1.0 and update Perl patch from 5.14.1 as needed.

2.5 Source 12c Environment

. /u01/app/FBS/db/tech_st/12.1.0/FBS_fbsebs.env

# Run NLS data script
perl $ORACLE_HOME/nls/data/old/cr9idata.pl

Phase 3: Apply Database Patches

3.1 Update OPatch

Patch 6880880 - Latest OPatch version for 12.1.0

3.2 Apply Database Patches

Apply the following patches using opatch:

Patch Number
19382851
19393542
19591608
19627012
19649152
20204035
22660003
22731026
23645516

Commands:

export PATH=$ORACLE_HOME/OPatch:$PATH

cd 19382851/
opatch apply

# Repeat for each patch
opatch lsinventory  # Verify all patches are applied

Phase 4: Pre-Upgrade Preparation

4.1 Stop Services

Ensure application and database listener services are down:

# Stop application services
# Stop database listener

4.2 Pre-Upgrade Cleanup

Source the 11g home and connect to SQLPlus:

sqlplus "/ as sysdba"

Execute cleanup commands:

-- Drop SYS.ENABLED$INDEXES (conditional)
DROP TABLE sys.enabled$indexes;

-- Remove MGDSYS schema (conditional)
@?/md/admin/catnomgdidcode.sql

-- Gather dictionary statistics
EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

4.3 Run Pre-Upgrade Information Tool

Copy the pre-upgrade scripts from the 12c Oracle Home:

cd /u01/app/FBS/db/tech_st/12.1.0/rdbms/admin
cp preupgrd.sql utluppkg.sql $HOME

Execute in SQLPlus:

@utluppkg.sql
@preupgrd.sql

Review the pre-upgrade log:

/u01/app/FBS/db/tech_st/11.1.0/cfgtoollogs/FBS/preupgrade/preupgrade.log

4.4 Apply Pre-Upgrade Fixes

@/u01/app/FBS/db/tech_st/11.1.0/cfgtoollogs/FBS/preupgrade/preupgrade_fixups.sql

Key Fixes Applied:

Process count adjustment (set to 300)
OCM user removal
Invalid system table data fix
Recycle bin purge
Dictionary statistics gathering

4.5 Extend Tablespaces

Enable autoextend for all datafiles:

-- Example: Enable autoextend for a sample datafile
ALTER DATABASE DATAFILE '/u01/app/FBS/db/apps_st/data/system01.dbf' AUTOEXTEND ON MAXSIZE UNLIMITED;

-- Repeat for all datafiles listed in dba_data_files
SELECT 'ALTER DATABASE DATAFILE ''' || file_name || ''' AUTOEXTEND ON MAXSIZE UNLIMITED;' 
FROM dba_data_files;

-- For tempfiles
ALTER DATABASE TEMPFILE '/u01/app/FBS/db/apps_st/data/temp01.dbf' AUTOEXTEND ON MAXSIZE UNLIMITED;

4.6 Manual Configuration Updates

-- Set parameters in init file
PROCESSES=300
job_queue_processes=65

-- Comment out underscore parameters:
-- _b_tree_bitmap_plans = FALSE
-- _disable_fast_validate = TRUE
-- (etc.)

-- Gather dictionary statistics
EXECUTE dbms_stats.gather_dictionary_stats;

4.7 Copy Network Files

Copy admin directory from 11g to 12c:

cp -r /u01/app/FBS/db/tech_st/11.1.0/network/admin/* /u01/app/FBS/db/tech_st/12.1.0/network/admin/

Update paths in:

listener.ora
sqlnet.ora
tnsnames.ora

Phase 5: Database Upgrade

5.1 Launch Database Upgrade Assistant (DBUA)

# Source 12c environment
. /u01/app/FBS/db/tech_st/12.1.0/FBS_fbsebs.env

# Unset ORA_TZFILE
unset ORA_TZFILE

# Launch DBUA
cd /u01/app/FBS/db/tech_st/12.1.0/bin/
./dbua

DBUA Configuration Steps:

Select database to upgrade (FBS)

Review pre-upgrade checks

Configure recovery options

Set parallel degree

Review summary and execute

Note: Ignore any XML parsing errors encountered during the upgrade.

Phase 6: Post-Upgrade Tasks

6.1 Verify Invalid Objects

SELECT COUNT(*) FROM dba_objects WHERE status='INVALID';

6.2 Run Application Grants Script

Copy adgrants.sql from application server to database server:

cp $APPL_TOP/admin/adgrants.sql /u01/app/FBS/db/tech_st/11.1.0/appsutil/admin/

# Execute on database server
sqlplus "/ as sysdba" @$ORACLE_HOME/appsutil/admin/adgrants.sql apps

6.3 Grant CTXSYS Privileges

@?/rdbms/admin/dbmsxdbschmig.sql
@?/rdbms/admin/prvtxdbschmig.plb

-- Grant create procedure privilege
sqlplus apps/apps @adctxprv.sql manager CTXSYS

6.4 Set CTXSYS Parameters

sqlplus "/ as sysdba"
exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');

6.5 Validate Workflow Ruleset

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfaqupfix.sql APPLSYS APPS

6.6 Gather Statistics for SYS Schema

sqlplus "/ as sysdba"
ALTER SYSTEM ENABLE RESTRICTED SESSION;
@adstats.sql
ALTER SYSTEM DISABLE RESTRICTED SESSION;

6.7 Run FND_CONC Cleanup

sqlplus apps/apps
exec fnd_conc_clone.setup_clean;

6.8 Recreate appsutil

Application Tier:

cd $APPL_TOP
. APPFBS_fbstest.env
perl $AD_TOP/bin/admkappsutil.pl

Copy appsutil.zip to the database server:

cp /u01/app/FBS/inst/apps/FBS_fbstest/admin/out/appsutil.zip $ORACLE_HOME/
unzip -o appsutil.zip

6.9 Recreate Context File (Database Tier)

cd $ORACLE_HOME/appsutil/bin
perl adbldxml.pl appsuser=apps appspasswd=apps jtop=$ORACLE_HOME/jdk

6.10 Run AutoConfig

Database Tier:

perl adconfig.pl contextfile=/u01/app/FBS/db/tech_st/12.1.0/appsutil/FBS_fbstest.xml

Application Tier:

# Clear OC4J caches
rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

# Update httpd.conf
# Set KeepAlive Off and Timeout 600

6.11 Apply Final Application Patch

cd /u01/patches/apps/18039691/
adpatch apply=yes driver=u18039691.drv

6.12 Disable Maintenance Mode

Start all application services and disable maintenance mode.

Verification

Verify application services are running
Confirm database version:
sql
```
SELECT version FROM v$instance;
```
Check for invalid objects
Validate application functionality

Reference Documentation

Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)

Summary of Critical Path

✅ Apply application patches
✅ Install 12c database binary
✅ Apply database patches
✅ Run pre-upgrade checks and fixes
✅ Extend tablespaces
✅ Execute DBUA upgrade
✅ Run post-upgrade scripts
✅ Recreate appsutil and context
✅ Run AutoConfig on both tiers
✅ Apply final application patch
✅ Verify and start services

Important Notes

Always perform these steps in a test environment before production
Ensure adequate backup of the source database
Monitor tablespace usage during the upgrade
Address all pre-upgrade errors before proceeding
Set PROCESSES=300 as recommended for 12c
Remove or comment out underscore parameters from the init file

Pages

3.a Upgrade Oracle Database 11.1.0.7 to 12.1.0.2 on EBS R12.1.3