Monday, June 29, 2020

Minimizing Oracle EBusiness Suite Release 12.2.n Upgrade Downtime

 Minimizing Oracle EBusiness Suite Release 12.2.n Upgrade Downtime 

Follow the link for upgrade.


Removing Unnecessary Workloads / Overheads
  •   Disable any custom triggers and business events 12 Best Practices for Minimizing E-Business Suite R12.2.n Upgrade Downtime 
  •  Disable all DBMS scheduler (DBMS_SCHEDULER), DBMS Job (DBMS_JOB) and Autotask (DBMS_AUTO_TASK_ADMIN) activities during the upgrade
  •  Review and disable custom VPD policies as needed
  •  Disable auditing if enabled. 
  • Review and disable all debug or logging; do this at all levels (site, responsibility, user level etc.). 
  • If possible run in noarchivelog mode. 
  •  Disable flashback DB. 
  •  Remove TDE (Transparent Data Encryption) from high volume tables.
  •  Consider running AutoConfig in parallel on a multi-node system. 
  • Split any RDBMS Upgrade, Platform Upgrade, Conversion to OATM into a separate downtime period. 
  •  Use TUMS (The Upgrade Manual Script) to avoid running tasks that are not relevant to the installation
  •  Minimize Historical Data To Be Upgraded (Upgrade by Request) (Upgrade from 11i Only) 
  • Parallelize pre and post upgrade technical activities  Define separate concurrent manager queue for post upgrade jobs. 
  • If using RAC then “Parallel Concurrent Processing (PCP)” could be used for post-upgrade concurrent jobs.

No comments: