Pages

Wednesday, 25 September 2019

Oracle E-Business Suite RUP Upgrade from R12.2.x to R12.2.9

In this Blog ,you will see about the  Oracle E-Business Suite 12.2.x to 12.2.9  upgrade steps in detail. Just review , you will get some ideas.
And the same procedure will be applicable to the Ebiz exisiting version 12.2.2 and above RUP. If any queries in the post,feel free to drop comments . So that we will discuss further.

 Ref : 
  • Oracle E-Business Suite 12.2.9 Release Update Pack Patch 28840850 -- download the patch
  • Oracle Ebiz 12.2.9 Readme (Doc ID 2495027.1) 
  • Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
  • Enhancement for WLS BSU (Smart Update): Resolves Very Long Time to Apply Patches - Especially When Checking for Patch Conflicts (Doc ID 2271366.1)
  • ADOP CLEANUP ERRORS AFTER 12.2.8 OR 12.2 HR RUP12 UPGRADE ON PUBLIC.PER_SUITMATCH (Doc ID 2503664.1)
Process has been divided into 3 stage:
  1. Pre-Upgrade Steps
  2. Upgrade Steps
  3. Post-Upgrade Steps
Pre-Upgrade Steps
  • First run ETCC checker in DB tier and apply all required bug fix and then in AppsTier run the ETCC and apply the required bug fix .
  • Minimum FMW (11.1.1.9) AND Weblogic 10.3.6.0.190416 or above required for the upgrade.
  • Set Database Parameter (Conditional)
    1. Optimizer Adaptive Optimization (ONLY FOR DB 12.1.0.2)
      2. If you are using Oracle Database 12.1.0.2, optimizer adaptive features are controlled by the database initialization parameter optimizer_adaptive_features. this parameter should always be set to 'false'. This setting should be completed before proceeding with the next steps and should not be changed thereafter.
      Note: You can skip this step if you have upgraded to Release 12.2.0 using the latest Consolidated Upgrade Patch 28853097:12.2.0 (CUP10) or Consolidated Upgrade Patch 26924710:12.2.0 (CUP9) or Patch 24690520:12.2.0 (CUP8) or Patch 22742071:12.2.0 (CUP7) or Patch 19796566:12.2.0 (CUP6) or Patch 18007406:12.2.0 (CUP5) or Patch 17197281:12.2.0 (CUP4).
      For more information, see My Oracle Support Knowledge Document 396009.1, Database Initialization Parameters for Oracle E-Business Suite Release 12.
      optimizer_adaptive_features=false
      You can verify the parameter was set correctly by running the following command, which should return the value FALSE:
      SQL>show parameter optimizer_adaptive_features
    2. _disable_actualization_for_grant (applicable for Oracle Database 11.2.0.4 and Oracle Database 12.1.0.2)
      3. Set the parameter _disable_actualization_for_grant to true.
      _disable_actualization_for_grant=true
      You can verify the parameter was set correctly by running the following command, which should return the value TRUE:
      SQL>show parameter _disable_actualization_for_grant

  • Apply Consolidated Seed Table Upgrade Patch (Required)

    Note: This step is applicable only for new installation customers and customers upgrading from Oracle E-Business Suite Release 12.2.2 to Release 12.2.9.
    Note: You can skip this step if you have upgraded to Release 12.2.0 using the latest Consolidated Upgrade Patch 28853097:12.2.0 (CUP10) or earlier Consolidated Upgrade Patches:
    1. Stop all application tier services on the run file system.UNIX:
      sh $ADMIN_SCRIPTS_HOME/adstpall.sh
      Windows:
      C:\>%ADMIN_SCRIPTS_HOME%\adstpall.cmd
    2. Start up only the Oracle Weblogic Admin Server on the run file system.
      UNIX:
      $ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
      Windows:
      C:\>%ADMIN_SCRIPTS_HOME%\adadminsrvctl.cmd start
    3. Apply the consolidated seed table upgrade Patch 26787701:12.2.0 on the run file system using adop hotpatch mode.
      $ adop phase=apply patches=26787701 hotpatch=yes
      Note: For existing non-American languages in the system, skip NLS patch application for this. It is not required.
    4. Start up all application tier services.
      Note: This step is applicable only for customers upgrading from Oracle E-Business Suite Release 12.2.2 to Release 12.2.9.
      UNIX:
      $ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
      Windows:
      C:\>%ADMIN_SCRIPTS_HOME%\adstrtal.cmd
  • AD/TXK 11 RUP is conditional , so need to apply this patch (Refer the mentioned doc number above).
  • Once Everthing done, again Run ETCC in both DB and APPS TIER , to apply any missing bug fix.
  • Before proceeding to the upgrade process, there should be no bugs and recommeded patches appear in ETCC report, u should get the status 'ALL REQUIRED BUGS ARE FIXED',  just make sure.
Upgrade Steps

    1. Source the run edition applications environment.
      UNIX:
      $ . <INSTALL_BASE>/EBSapps.env run
    2. Start an online patching cycle.
      $ adop phase=prepare
    3. Apply Oracle E-Business Suite Release 12.2.9 Patch 28840850.
      UNIX:
      $ adop phase=apply patches=28840850
    4. Complete the online patching cycle by running the following commands in the order shown.
      UNIX:
      $ adop phase=finalize
      $ adop phase=cutover
      $ . <INSTALL_BASE>/EBSapps.env run
      $ adop phase=cleanup
    5. Synchronize file systems
      Synchronize the file systems using the command shown below. This action will copy the new run edition code and configuration to the other file system, to help the next online patching cycle complete faster.
      $ adop phase=fs_clone
POST-Upgrade Steps

  • Note: If you are upgrading from Release 11i, 12.0.x or 12.1.x to Release 12.2.9, then you must continue with 12.2.0 post upgrade steps mentioned in the Upgrade guides before performing the below steps.
    • Apply Oracle E-Business Suite Release 12.2.9 Online Help Patch 28840900 using adop hotpatch mode on the run file system.
      $ adop phase=apply patches=28840900 hotpatch=yes
  • Verify security configurations (CONDITIONAL STEP AS WELL AS VERY IMPORTANT)
    • If you have upgraded to Oracle E-Business Suite 12.2.9 Release Update Pack from Oracle E-Business Suite 12.2.6 Release Update Pack (or earlier) and after you apply the Release Update Pack (RUP) or perform an upgrade, your Oracle E-Business Suite system is locked down until the system administrator configures or acknowledges the recommended security configurations in the Secure Configuration Console to unlock the system for normal usage. To access this console, a user must have a responsibility that includes the Applications System (OAM_APP_SYSTEM) function privilege, such as the seeded System Administration or System Administrator responsibilities, and must be registered as a local user with Oracle E-Business Suite. 
  • Perform NLS-related Step (conditional)
    • You may have languages other than American English installed on your Release 12.2.0 system. If so, you must apply the Release 12.2.9 NLS software patch for each of the existing languages in the system. After applying the Release 12.2.9 NLS software patch, apply the Release 12.2.9 Online Help patch for the language, if available
Posted by at No comments:
Subscribe to: Posts (Atom)