Oracle eBusiness 12.1.3 to 12.2.5 upgrade - Part 2 (Upgrade to 12.2 - A)

Using 12.2 startCD 51 which has been latest by the time of upgrade.

Note:- There can be a lots of variation in terms of steps specific to your own environment. Please go through the Upgrade guide, release notes and relevant Oracle Support Notes before finalizing your upgrade steps.

Pre 12.2 Tasks

1. SubTypes Data Corruption Caused by csitxnst.ldt (Doc ID: 1681308.1)

Run scripts pre app upgrade.

- run dbmsxdbschmig.sql, prvtxdbschmig.sql, utlrp.sql scripts:

sqlplus / as sysdba

SQL> alter session set current_schema=SYS;

SQL> @?/rdbms/admin/dbmsxdbschmig.sql

SQL> @?/rdbms/admin/prvtxdbschmig.plb

SQL> @?/rdbms/admin/utlrp.sql

- run adgrants.sql:

sqlplus / as sysdba

SQL> @?/rdbms/admin/adgrants.sql [APPS schema name]

2. Backup the environment

3. Backup CUSTOM.pll

4. Check Guest account for user_id. Should be 6.

SQL> select user_name , user_id from fnd_user where user_name like 'GUEST';

5. Drop Custom Event Triggers.

Run alrdtrig.sql for every custom schema and verify and drop triggers after taking backup.

6. Check for module specific tasks from upgrade guide.

Financial and procurement Tasks, Sub Ledger Accounting, SCM Task, Order Management etc.

Install JRE on database tier.

7. Add SQLNET.ALLOWED_LOGON_VERSION_SERVER to sqlnet.ora Ifile on both the nodes, decide value for conditions given in upgrade guide.

Install 12.2 File-system

Start rapidwiz, go for upgrade and select for create upgrade file system.

Here you will be asked for many details related to ports, servers, paths and passwords.
Enter those and after initial validation it will come to following screen.

Proceeding with next will install the file system for 12.2 in the given path.

Once the installation is successful, following screen will ask to validate and next button will show details.

12.2 Upgrade


1. Shutdown application if anything is running.

2. Set FAILED_LOGIN_ATTEMPTS to UNLIMITED for all eBusiness related schemas.

3. Enable Maintenance Mode

4. Apply AD Patch 10117518
Check for Patch readme and follow instructions for pre tasks, merge and post tasks.Follow Doc: Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Section 3.

5. Download and merge preinstall patches.

Follow Doc: R12.1 and 12.2 Oracle E-Business Suite Preinstall Patches Report [Video] (Doc ID 1448102.2) for downloading patches.

6. Apply Following the Doc 1320300.1, exactly step by step. This will include preinstall, merge and apply steps of merged 12.2 Driver.

7 Disable Maintenance Mode.


Follow Link below for Next Steps of Upgrade

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