Oracle eBusiness 12.1.3 to 12.2.5 upgrade - Part 3 (Upgrade to 12.2 - B)

Finishing 12.2 Upgrade


1. Back up the binaries and database.

2. Cleanup Nodes info (Optional).

SQL>exec fnd_conc_clone.setup_clean ;

3. Verify env variables on DB

LD_LIBRARY_PATH = $ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
ORACLE_SID = <instance name for current database node>
TNS_ADMIN=$ORACLE_HOME/network/admin/<CONTEXT_NAME>
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/appsutil/jre/bin:$PATH
PERL5LIB=$ORACLE_HOME/perl/lib/5.14.1:$ORACLE_HOME/perl/lib/site_perl/5.14.1:$ORACLE_HOME/appsutil/perl

4. Run autoconfig on database

Make appsutil again from apps using
perl <AD_TOP>/bin/admkappsutil.pl

Unzip on Databzse
unzip -o appsutil.zip

or copy database context file
cd <RDBMS ORACLE_HOME>/appsutil/bin
perl adbldxml.pl

Run Autoconfig
<RDBMS ORACLE_HOME>/appsutil/bin/adconfig.sh contextfile=<context file>


5. Run autoconfig on App.

Drop table ADX_PRE_AUTOCONFIG from APPS schema, will be recreated during autoconfig.
cd <AD_TOP>/patch/115/sql
sqlplus APPS/$APPS_PASS @txkDropAdxPreAutoConfig.sql

Run AutoConfig on all the Application Tier nodes using the following Commands

$ADMIN_SCRIPTS_HOME/adautocfg.sh

6. Start Rapidwiz and run Configuration.

Provide Context File, then in further screens provide inputs as asked.

This will start configuration post confirmation. At the end you will get following screen for validation. 

Here we are done with 12.2 Upgrade. But there is a major step due is ADOP enablement.
ADOP is the new feature introduced with 12.2 making it too much different for earlier version. It is AD Online Patching, and so it needs specific versions of Database to support Edition Based Redefinition.

Following are the steps to enable Adop, which is also a part of Upgrade activity.

Enable ADOP


1. Apply E-Business Suite:Online Patching Readiness and GSCC Report patch 22071026:R12.AD.C.

2. Consider Localization if Any.

3. Run Readiness Scripts. (Doc ID 1531121.1)

sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
sqlplus system @$AD_TOP/sql/ADZDPAUT.sql

Resolve all the issues reported by scripts.

4. Fix Data Dictionary or Time Stamp mismatch.
$AD_TOP/patch/115/sql/adzddtsfix.sql (Following the usage instructions provided in it).

Run the $AD_TOP/sql/ADZDDBCC.sql script to identify whether the data dictionary corruption is still present.

In case yes, follow the doc 1531121.1.

5. Verify the tablespace Freespace.

Set the fs1 env.
Set HOSTNAME env variable without domain name.
Run adzdreport.pl.

Recommended for system to have 25 GB free space and APPS_TS_SEED to have 5 GB

6. Run the Online Patching Enablement - Status Report

sqlplus apps @$AD_TOP/sql/ADZDEXRPT.sql

7. Make sure Application Services are down.

8. Apply ADOP enablement patch. 13543062:R12.AD.C.

adpatch options=hotpatch,forceapply

Monitor the progress using sqlplus apps @$AD_TOP/sql/ADZDSHOWDDLS.sql

9. Check for invalids and compile.

exec sys.utl_recomp.recomp_parallel(n);

10. Re Run the online patching enablement report.

sqlplus <Apps Username> @$AD_TOP/sql/ADZDEXRPT.sql

Re run readiness reports for errors.

sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
sqlplus system @$AD_TOP/sql/ADZDPAUT.sql

Run Compliance Checker again.

sqlplus <Apps Username> @$AD_TOP/sql/ADZDDBCC.sql


11. Resplice Localizations and perform additional activities.

12. Check following DB parameters.

service_names=%s_dbSid%,ebs_patch
recyclebin=off
_SYSTEM_TRIG_ENABLED=true

With this we are done with 12.2 Upgrade. This point onward whatever patches will go to the system will go using adop utility. So will be the 12.2.5 related patches and upgrade driver.

For 12.2.5 Upgrade please click on below link.