R12.1.3 EBS Database 11.2.0.2 Upgrade to 12c 12.1.0.2

Server Configuration:
——————–
RAM:16GB
CPU’s-4
Operating System: OEL 5.5.
Oracle EBS Version: R12.1.3
Oracle EBS Database Version 11.2.0.2(Before Upgrade)

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

Apply Below ApplicationPatches:

If you already on R12.1.3 then non need to apply Patch 9239090 – Oracle E-Business Suite 12.1.3

Apply Patch 12923944
Apply Patch 13473483
Apply Patch 16289505 – 12c Release 1 interoperability patch for Release 12.1
Apply Patch 18843706
Apply Patch 19558309

Step1:Prepare to create the 12.1.0 Oracle home

-Install Oracle Software 12c
mkdir -p /d01/oracle/PROD/db/tech_st/12c

Download below patchsets for 12c database
p17694377_121020_Linux-x86-64_1of8.zip
p17694377_121020_Linux-x86-64_2of8.zip
p17694377_121020_Linux-x86-64_7of8.zip

Unzip and run the runInstaller

Step2: Install Examples CD

Step3:
Create nls/data/9idata directory

On the database server node, as the owner of the Oracle RDBMS file system and database instance, run the following command to create the $ORACLE_HOME/nls/data/9idata directory.

$ perl $ORACLE_HOME/nls/data/old/cr9idata.pl

export ORACLE_HOME=/d01/oracle/PROD/db/tech_st/12c
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/bin:$PATH
export ORA_NLS10=/d01/oracle/PROD/db/tech_st/12c/nls/data/9idata
export PATH=$ORACLE_HOME/OPatch:$PATH

Step4:
Apply additional 12.1.0.2 RDBMS patches
Apply the following patches:
For all UNIX/Linux platforms:
Patch 19382851

Step5:Shut down Applications server processes and database listener

On each application tier server node, shut down all server processes or services. On the database tier server node, shut down the Oracle Net or Net8 database listener in the old Oracle home.

Note: The Applications will be unavailable to users until all remaining tasks in this section are completed.
Attention: Make sure that you do not have the LOCAL_LISTENER initialization parameter set to ensure that the database does not inadvertently point to a non-existent listener during upgrade.

Step6:Drop SYS.ENABLED$INDEXES (conditional)

If the SYS.ENABLED$INDEXES table exists, use SQL*Plus to connect to the database as SYSDBA and running the following command to drop it:

SQL> drop table sys.enabled$indexes;

Step6:
Remove the MGDSYS schema (conditional)

If you are upgrading from an RDBMS version prior to 12c, on the old database server node, use SQL*Plus to connect to the database as SYSDBA and run the $ORACLE_HOME/md/admin/catnomgdidcode.sql script. This drops the MGDSYS schema.
$ sqlplus “/ as sysdba” @?/md/admin/catnomgdidcode.sql

Step7:Prepare to upgrade

Step8:

Step9:run dbua

Run FIX and Check Again…If there are any errors…….

Step10:
Compile the Invalids

Step11:
Run adgrants.sql

Copy $APPL_TOP/admin/adgrants.sql (adgrants_nt.sql for Windows) from the administration server node to the database server node. Use SQL*Plus to connect to the database as SYSDBA and run the script using the following command:

$ sqlplus “/ as sysdba” @adgrants.sql (or adgrants_nt.sql)
[APPS schema name]

Step12:

Step13:

Step14:

Step15:De-register Database and Implement Autconfig

Step16:

Run Autoconfig on the application side as well…..

Start the application tier services…..

This finishes the R12 EBS Database 11.2.0.2 to 12.1.0.2