Upgrade database 11.2.0.3 to 12c(12.1.0) in EBS_suite R12.2.4

DATABASE UPGRADE FROM 11.2.0.3 TO 12.1.0.2 WITH EBS 12.2.4 

http://docs.oracle.com/database/121/UPGRD/intro.htm#UPGRD60103

DATABASE VERSION: 11.2.0.3

APPS VERSION : 12.2.4

This document is follwed by the respective metalik note “ Interoperability Notes Oracle E-Business Suite Release 12.2 with Oracle Database 12c Release 1 (12.1.0) August 2015 Doc id-1926201.1 “

REQUIREMENTS:

PATCHES:

RDBMS PATCHES	APPLICATION PATCHES
18485835	16207672
18689530	19197270
18893947	19330775
18966843 -apply post install	19597008
19291380	20251314
19393542	8796558
19472320	19343134
19627012
19649152
19779059
19835133
19896336
20093776
20181016
20204035 – apply post install
20294666
20476776 – apply post install
20830911
20994102
21091055
21188532

STEP 1:

- Apply the ebs patches

- check the README file before applying patches

(adop phase=apply patches='patch number')

STEP 2:

- Install 12.1.0 oracle home in the base directory

- Download and unzip the stage .

- set display - xhost +

- ./runInstaller

STEP 3:

-Install the oracle 12c Database Examples CD

- Download and unzip the stage.

- set display - xhost +

- install the examples with same base and home location as installed in 12.1.0 home.

STEP 4:

-In the new home set the environment variables as follows

export ORACLE_BASE=/u01/TEST
export ORACLE_SID=TEST
export ORACLE_HOME=/u01/TEST/12.1.0
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PERL5LIB=$ORACLE_HOME/perl/lib/5.14.1:$ORACLE_HOME/perl/lib/site_perl/5.14.1

STEP 5:

-Source the 12.1.0 environment file ( which is set accordingly above)

- apply the required RDBMS patches in the new oracle home ( above given table)

- export the path as

export PATH=$ORACLE_HOME/OPatch:$PATH

-apply all the opatches ( vieew the README file carefully before applying)

STEP 6:

- create the nls/data/9idata directory

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

- update the ORA_NLS10 path in environment file.

STEP 7:

-install JRE 6 0r 7

STEP 8:

- Ensure the apps patching is completed

- complete any existing or not completed phase in adop cycle. (cutover,cleanup).

Check like : adop -status

STEP 9:

- shut down all applcation services and database listener only.

- In the init ora file …….hash the local_listener parameter…..#local_listener = TEST_LOCAL

STEP 10:

- Drop the drop table sys.enabled$indexes;

- remove the MGDSYS schema – sqlplus "/ as sysdba" @?/md/admin/catnomgdidcode.sql

STEP 11:

-prepare to upgrade..

- copy the preupgrd.sql and utluppkg.sql script from 12.1.0 home to any temporary location.

- execute the preupgrd.sql in 11.1.0 home and check for the warnings and issues and clear it.

- run the preupgrade_fixups.sql in $ORACLE_HOME/cfgtoollogs/TEST/preupgrade

- execute @/tmp/utluppkg.sql script

STEP 12:

- create password file fro new home from 11.2.0 home

- copy /dbs contents to 12.1.0 home

- shut down the 11.2.0 database

STEP 13:

- in 12.1.0 home...source the env file

- spool upgrade.log

- startup upgrade;

- execute the script perl $ORACLE_HOME/rdbms/admin/catctl.pl -n 4 catupgrd.sql

-startup database

- alter trigger SYSTEM.EBS_LOGON compile;

STEP 14:

- modify the parameters in pfile coresponding to the metalink Doc id- 396009.1

- perform post install steps in patches.

- execute the script ./$ORACLE_HOME/Opatch/datapatch

- execute the script @?/rdbms/admin/dbmsxdbschmig.sql

- execute the script @?/rdbms/admin/prvtxdbschmig.plb

Step: 14(a) :

Create the listener for new location using netca or copy the listener.ora,tnsname.ora.sqlnet.ora to 11g net location

to 12c net location and chenge the 12c location information in those files.

STEP 15:

- run adgrants.sql -

- copy the adgrants.sql script from $APPL_TOP/admin/adgrants.sql to 12.1.0 RDBMS home.

- execute script as sqlplus / as sysdba @adgrants.sql apps apps

STEP 16

- grant create procedure privilage on CTXSYS

- copy $AD_TOP/patch/115/adctxprv.sql to 12.1.0 RDBMS home

- execute script as sqlplus apps/apps @adctxprv.sql \ manager CTXSYS

STEP 17:

- compile invalid objects

- execute script as sqlplus / as sysdba @$ORACLE_HOME/rdbms/admin/utlrp.sql

STEP 18:

- set CTXSYS parameter by

sqlplus / as sysdba

exec ctxsys.ctx_adm.set_parameter('file_access_role','public');

STEP 19:

- Validate workflow ruleset

- copy the script cp $FND_TOP/patch/115/sql/wfaqupfix.sql to oracle home

- sqlplus apps/apps @wfaqupfix.sql \ APPLSYS APPS

STEP 20:

- Deregister current database server

- sqlplus apps/apps;

- exec fnd_conc_clone.setup_clean;

STEP 21:

-implement autoconfig on both db and apps tier.

- for db tier…...create appsutil folder by executing the perl script perl $AD_TOP/bin/admkappsutil.pl

- copy the geneerated output directory to12.1.0 RDBMS home…..cp -r #INST_TOP/admin/out/appsutil.zip /u01/TEST/12.1.0

- unzip the appsutil.zip in 12.1.0 RDBMS home.

- copy the file cp -r $ORACLE_HOME/jib/orai18n.jar to $ORACLE_HOME/appsutil/jre/lib/ext

- build the contextfile for RDBMS home by executing the perl script adbldxml.pl in appsutin/bin

perl adbldxml.pl

enter the hostname,servicename,port number

- the contextfile is generated in appsutil folder.

- implement autoconfig by executing script adconfig.sh in appsutil/bin

sh adconfig.sh

enter the location of contextfile

for applications:

soure the env file

cd $ADMIN_SCRIPTS_HOME

./adautocfg.sh

STEP 22:

- gather statics for SYS schema

- copy the script from $APPL_TOP/admin/adstats.sql to oracle home

> sqlplus as sysdba

> alter system enable restricted session;

> @adstats.sql

- ensure the temp table space is of size 1.5 gb before running script.

STEP 23:

- shut down and restart database;

- soure applications and run adadmin in downtime

- re-create grants and synonyms for apps achema.

STEP 24:

- start up all application services.

- In OAM.- submit a single request and enter the following details to synchronize workflow views.

Request Name = Workflow Directory Services User/Role Validation

Batch Size = 10000

Fix dangling users = Yes

Add missing user/role assignments = Yes

Update WHO columns in WF tables = No

- click ok and submit.

Thanks:

Kumaresan Nethaji