EBS Upgrade 12.1.1 to 12.1.3

EBS Upgrade 12.1.1 to 12.1.3 Assumptions: Apps Tier– Oracle EBS R12.1.3 on Oracle Linux EL 6.7 64bit Database Tier– Database 11.1.0.7 on Oracle Linux EL 6.7 64bit Instance Name: VIS Accounts – applmgr (Apps Tier) and oravis (DB tier) Host Names: ebsapps.oracle (Apps tier) and ebsdb.oracle(db tier) Required Patches download: Ø  Patch 9239089 Ø  Patch 9239090 Ø  Patch 9239095 Ø  Patch 9817770 Ø  Patch 9966055 Application Environment set to applmgr user (VIS_ebsapps.env) Database Envinoment set to oravis user(VIS_ebsdb.env)
Pre Upgrade Activities	Ø  Edit the init parameter file in the database(Using 11gR1 follow doc.761570.1) & Stop and Start  Database: $login to DB server with oravis (environment value will be set in .bash_profile) $sqlplus / as sysdba SQL> shutdown immediate SQL> exit Ø  Stop Listeners: $lsntctl stop Ø  Update Parameter value $cd $ORACLE_HOME/dbs/initVIS.ora $vi initVIS.ora Add this value at the end: add (_disable_fast_validate=TRUE) Ø  Start Listeners and database: $lsntctl start $sqlplus / as sysdba SQL> startup SQL>exit Ø  STOP EBS services & enables Maintenance mode using adadmin $cd $ADMIN_SCRIPTS_ALL $adstpall.sh apps/apps $adadmin (Option 5 and 1)
Apply R12.AD.B.DELTA.3 Patch 9239089	Ø  Pre Patch steps: Copy adgrants.sql from this patch directory to $ORACLE_HOME/appsutil/admin  in DB Tier:- Login with oravis account $cp /mnt/software/EBSpatches/9239089/admin/adgrants.sql   $ORACLE_HOME/appsutil/admin $sqlplus / as sysdba SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps Ø  Login in to apps tier with applmgr account $cd /mnt/software/EBSpatches/9239089 $adpatch Ø  Compile APPS schema $adadmin -       (Compile/Reload Applications Database Entities menu >Compile APPS schema) -       Choose "No" at the following prompt:Run Invoker Rights processing in incremental mode [No] -       You May expect Module related issues, based on installed modules
Apply Oracle E-Business Suite Release 12.1.3 Patch 9239090	Note: If relinking fails during below patch ensure that you have performed action plan in above step. Note: While patching follow below when prompted while running adpatch:- Please enter the batchsize [1000] : Enter the number of parallel workers [8] : Ø  Apply the 12.1.3 MP now as below – Main patch and takes some time $cd /mnt/software/EBSpatches/9239090 $adpatch -       When adrelink error chose "Yes" to continue
Post 12.1.3 upgrade
Apply patch 9239095	Apply latest consolidated online help Patch:- $cd /mnt/software/EBSpatches/9239095 $adpatch u9239095.drv
Apply patch 8919491  (Optional)	Apply Oracle Applications Technology 12.1.3 Product Family Release Update Pack  First check if the patch exists or not if not apply using the below steps. Note : this patch comes by default with 12.1.3 patch. $cd /mnt/software/EBSpatches/8919491 $adpatch
Apply patch 12964564 (Optional)	1OFF:12.1.3:11GCS AND FNDCPASS USER EXIT MERGE CONSOLIDATION PATCH :- $cd /mnt/software/EBSpatches/12964564 $adpatch
Apply patch 9817770	R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH]:- $cd /mnt/software/EBSpatches/9817770 $adpatch
Apply patch 9966055	R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED]:- $cd /mnt/software/EBSpatches/9966055 $adpatch
Post Steps	Ø  Remove the parameter: $login to DB server with oravis (environment value will be set in .bash_profile) $sqlplus / as sysdba SQL> shutdown immediate SQL> exit Ø  Stop Listeners: $lsntctl stop Ø  Update Parameter value $cd $ORACLE_HOME/dbs/initVIS.ora $vi initVIS.ora Add this value at the end: add (_disable_fast_validate=TRUE) Ø  Start Listeners and database: $lsntctl start $sqlplus / as sysdba SQL> startup SQL>exit Ø  Remove maintanace mode: $cd $ADMIN_SCRIPTS_ALL $adstpall.sh apps/apps $adadmin (Option 5 and 2)
Auto config	Ø  Run Auto Config on DB tier first Ø  Run Auto config on Apps Tier Ø  Start all EBS Service
Validate Patches	Ø  Validate the all patches ad_applied_patches ad_bugs