Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Upgrade Oracle Applications from 11i to R12

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Upgrade Oracle Applications from 11i to R12

    Upgrade Oracle Applications from 11.5.10.2 to R12

    Version 11.5.10.2
    Oracle Applications Vision Instance
    OS: Redhat Linux update 5
    Type: Single Node instance
    Applications OS User: applmgrupd
    Installed directory: /d01/oracle/singlenode
    Database 9i OS User : oracleupd
    9i Database Home = /d01/oracle/singlenode/testdb/9.2.0
    10g Database Home = /d01/oracle/singlenode/testdb/10.2.0
    Instance SID: TEST
    Host: linux1

    Task – To Upgrade Oracle Applications 11.5.10.2 to R12



    Upgrade path

    • Applications R11.5.6 and below requires to first upgrade to R11.5.10.2/10gR2

    • Applications R11.5.7 and up can be directly upgraded to R12

    • Database in all releases must have been upgraded to 10gR2 (11.5.9.2 / 11.5.10.2) or should be done during upgrade to R12 (11.5.9.1/11.5.10.1 and below



    Here are steps to upgrade Oracle Application 11.5.10.2 to R12, let’s split the activity into 6 steps

    1> Please do upgrade the database from 9.2.0.6 to 10.2.0.3,

    2> Apply the below patches in your existing 11.5.10.2 environment

    Shut down the entire E-Business Suite environment and perform a full backup
    4712852 - Minipack 11i.AD.I.4
    5753359 - ALPPNR, NO RESPONSE ACTION PROCESSOR CONC PGM ENDS IN ERROR
    5467526 - OATM MIGRATION UTILITY: ORA-22853 IN ERROR LOG
    5120936 - TUMS for R12: TO DELIVER TUMS UTILITY FOR UPGRADES FROM 11I TO R12
    5726010 - AD Preparation Scripts for R12

    4712852 - Minipack 11i.AD.I.4
    5753359 - ALPPNR, NO RESPONSE ACTION PROCESSOR CONC PGM ENDS IN ERROR
    *5467526 - OATM MIGRATION UTILITY: ORA-22853 IN ERROR LOG
    5120936 - TUMS for R12: TO DELIVER TUMS UTILITY FOR UPGRADES FROM 11I TO R12

    sqlplus apps/apps @adtums.sql /usr/tmp

    -- Review TUMS report in /usr/tmp

    5726010 - AD Preparation Scripts for R12

    Enable the maintenance mode

    -- Apply patch 5726010
    unzip p5726010_11i_GENERIC.zip

    cd 5726010/

    sqlplus apps/apps @adgncons.sql apps apps
    # modify the adcrtbsp.sql to specify the path for new tablespaces

    sqlplus system/manager @adcrtbsp.sql

    su - oracleupd

    mkdir -p $ORACLE_HOME/appsutil/admin
    cd $ORACLE_HOME/appsutil/admin
    cp /software/upgrades/11.5.10.2toR12/r12/5726010/adgrants.sql .

    sqlplus '/ as sysdba' @adgrants.sql applsys

    3> Run rapidwiz to create R12 code tree

    The installation will install R12 applications components and the database home
    Select upgrade to Oracle Applications R12
    Select upgrade actions screen
    select create upgrade file system

    enter the parameters required to set up your new environment run rapid install Here are the screen shot




























    The Installation creates APPL_TOP, COMMON_TOP, INST_TOP and 10g Oracle Home
    Move the new environment file into .bash_profile

    su - applmgrupd
    cd /d01/oracle/apps/apps_st/appl
    mv .bash_profile .bash_profile_11.5.10
    cat APPSVIS_linux1.env >> /home/applmgrupd/.bash_profile

    4> Apply the below patches in R12 environment

    4502962 – R12 Minipack

    Now onwards, you are connected to R12 application
    -- Apply patch AD.A 4502962


    -- Apply patch 4440000
    Run the NLS upgrade patch driver (conditional)
    • Download the NLS Release 12 patch (4440000) for each active language in the system.
    • Run each driver (u4440000.drv) with adpatch
    • NLS patch driver has the same name as the American English patch driver.

    Synchronize NLS and American English product patches (conditional)
    • Generate manifest using perl $AD_TOP/bin/adgennls.pl
    • Backup manifest file $APPL_TOP/admin/$TWO_TASK/out/adgennls.txt
    • http://updates.oracle.com/TransSync
    • Don’t check Translation Level Updates
    • Upload manifest
    • Download and apply patch

    -- Configuration Phase
    Disable maintenance mode
    Run autoconfig

    Run rapidwiz to configure and start processes
    Sign on to R12 applications check concurrent managers

    Run autoconfig
    su - applmgrupd
    perl $AD_TOP/bin/admkappsutil.pl
    su - oracleupd
    cd $ORACLE_HOME
    cp /d01/oracle/inst/apps/TEST_linux1/admin/out/appsutil.zip .
    unzip -o appsutil.zip
    cd $ORACLE_HOME/appsutil/scripts/TEST_linux1
    sh adautocfg.sh


    5> Configuration Phase – R12

    Run rapidwiz to configure and start processes
    -----------------------------------------
    rapidwiz - Upgrade to Oracle Applications Release 12 -> Upgrade Action -> Select Configure Upgraded

    Release 12 instance
    $INST_TOP/admin/VIS_linux1.xml
    /d01/oracle/inst/apps/TEST_linux1/appl/admin/TEST_linux1.xml
























    Sign on to R12 applications check concurrent managers





    Connect as sysadmin/sysadmin




    6> Apply the online help

    cd $AU_TOP/patch/115/driver/

    Please enter the name of your AutoPatch driver file : u5051400.drv

    Gather schema statistics for CBO

    Release 12 employs cost-based optimization, which examines FND table statistics to determine the most efficient access paths and join methods for executing SQL statements. These statistics are gathered by the FND_STATS process, which you initiate by running the
    Gather Schema Statistics concurrent program.

    From your Release 11i APPL_TOP, complete the following steps:
    1. Log in to Oracle Applications with the System Administrator responsibility.
    2. Navigate to the Submit Request window (Request > Run).
    3. Submit the Gather Statistics program. (Schema)

+ Reply to Thread

Similar Threads

  1. Oracle Apps 11.5.10.2 DB Upgrade from 10.2.0.4 to 10.2.0.5
    By himsinha in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 01-23-2013, 06:58 PM
  2. RAC Upgrade to 11G2
    By Hemant in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 11-17-2012, 02:21 PM
  3. upgrade application from 12.1.1 to 12.1.3
    By deviilm17 in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 2
    Last Post: 01-27-2012, 04:16 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics