Step By Step Upgrade from R12.2.0 to R12.2.4   24 comments

Details:

OS: Oracle Enterprise Linux-x64bit 

CPU’s-4

Memory:16GB

No. Of Nodes:1(Both DBTier and AppsTier on Single Node)

References:

1.Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1)

2.Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

3.Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)

4. Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

Step1: Apply Required Database Patches:

Review Metalink Note 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes, and apply all required patches for your database version.

As I installed my R12.2 with startCD Version 12.2.0.47, I have all the updates (patches) belongs to 12.2.0.47 for my Database 11.2.0.3 and other Application Technology Software. So I need to apply patches belongs to 12.2.0.48 and also 8-26-2014 12-06-19 PM

 

Footnote 6 – This database patch is no longer available. For a more recent version of this fix that also includes additional fixes, refer to Patch 19078951 and its associated footnote.

Footnote 8 – This database patch is required to support the latest AD and TXK release update packs, as described in My Oracle Support Knowledge Document 1617461.1Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2. If Patch 17502060 was installed, you should roll it back before installing Patch 17693770 from My Oracle Support.

Footnote 11 – If Patch 18259911 or Patch 17461865 was installed, you should roll it back before installing Patch 19078951 from My Oracle Support.

Before applying 17693770 patch on 11.2.0.3 DB Home, rollback 17502060, and apply 17693770.

Before applying 18116376 rollback 17047617

For patch 18259911 FOOTNOTE6  says that it is no longer available and we need to refer Patch 1907895. (We will apply this 19078951 after applying all patches)

Before Applying 17875948 rollback 16587934

Before applying 19078951 rollback 14751895, 1825991117461865

DONT FORGET TO PERFORM POST INSTALL STEPS FROM PATCH README’s

Click on this to get abstract for applying DB Patches on 11.2.0.3 Database Patches Applied on 11203

Step2: Let’s Apply Patches for 10.1.2 Oracle_Home(Forms Home)

21012

Step 3:Web Tier and Utilities (OHS) 11.1.1.6 Patches and Bug Numbers

—Only One Patch needs to be applied.

Click on the this link to get Abstract for applying patches on Webtier Utilities1116Patch_Abstract

Step4:Patches  for Oracle Fusion Middleware 11.1.1.6.0

FUnsion

 

Click on the this link to get Abstract for applying patches on Fusion Middleware OH FusionOH1116

Step4: Oracle Weblogic Server 10.3.6.0 Patch

Download and Unzip both the patches in the /d01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir

weblogic

weblogicdirectory

Open VNC and run bsu.sh 

 

bsu1

bsu2

 

In the Below Sceenshot click on Green Arrows pointing upwards doing so will apply patches on weblogic. Do it one after the other

bsu5

bsu3

bsu4

Step5: Apply below patch

If you haven’t already applied Consolidated Seed Table Upgrade Patch 17204589:12.2.0, then you must first apply Patch 17204589:12.2.0 on the run file system.

Note: If you have upgraded to Release 12.2.0 using Consolidated Upgrade Patch 18007406:12.2.0 (CUP5) or Consolidated Upgrade Patch 17197281:12.2.0 (CUP4), then you can skip this step.
Stop all Application tier services on the run file system.
sh $ADMIN_SCRIPTS_HOME/adstpall.sh
Start up only the Weblogic AdminServer service on the run file system.
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Apply the consolidated seed table upgrade Patch 17204589:12.2.0 on the run file system using adop hotpatch mode.
Copy the patch in /d01/oracle/PROD/fs_ne/EBSapps/patch

$ adop phase=apply patches=17204589 hotpatch=yes

firstpatch

 

Step 6:Apply the Latest AD and TXK Delta Release Update Packs

Download and unzip the following patches:

1.Run adgrants.sql first and apply the patch

adgrats

cp adgrants.sql from patch/admin directory to db tier and execute as below, this may take some time depends upon hardware.

adpatch1

adpatch2

 

Before upgrade Version of EBS:

before

Step 7:Apply Patch 19259764:R12.FND.C (conditional).

Note: This step is not applicable for new installation and upgrade customers who are applying the Oracle E-Business Suite Release 12.2.4 Release Update Pack.

$ adop phase=apply patches=19259764 hotpatch=yes

Step 8: Run fs_clone as below

  1. Source the run edition environment file.

    $ . <EBS_ROOT>/EBSapps.env run

  2. Synchronize the file systems (conditional)

    $ adop phase=fs_clone

Step 9:Path A from the metalink note 1617458.1- Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.4 Release Update Pack

Source the run edition applications environment.

$ . <INSTALL_BASE>/EBSapps.env run

Stop Weblogic AdminServer and Node Manager services.

Applying the patch in downtime mode requires all application tier services to be down. Therefore, Weblogic AdminServer and Node Manager that were started previously when applying the latest Release Update Packs for AD and TXK for Release 12.2 need to be shut down.

Stop Weblogic AdminServer service on the run file system.

$sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

Stop Node Manager service on the run file system.

$sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

Apply Oracle E-Business Suite 12.2.4 Release Update Pack Patch 17919161 on the run edition application environment, using downtime mode.

$adop phase=apply apply_mode=downtime patches=17919161

Start all Application tier services on the run file system.

$sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

Perform adop cleanup action.

$adop phase=cleanup

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 ensure that both file systems are in sync before applying patches using the regular adop cycle on the other file system.

$ adop phase=fs_clone

Post-Update Steps

Note: If you are upgrading from Release 11i, 12.0.x or 12.1.x to Release 12.2.4, 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.4 Online Help

Apply Oracle E-Business Suite Release 12.2.4 Online Help Patch 17919162 merged with Patch 19290141 using adop hotpatch mode on the run file system.

$ adop phase=apply patches=17919162,19290141 hotpatch=yes merge=yes

This Finishes the R12.2.4 Upgrade from R12.2.0.

r124

New Feature

 

Let me know if anyone faces any issues in upgrading

 

Posted August 26, 2014 by balaoracledba.com in R12.2

24 responses to “Step By Step Upgrade from R12.2.0 to R12.2.4

Subscribe to comments with RSS.

  1. very useful information..can you please let us know parallel concurrent processing setup on R12.2.4 shared appl_top mode. Thanks.

  2. Hi, I am getting the error below when I apply 17204589 with: adop phase=apply patches=17204589 hotpatch=yes restart=yes

    [UNEXPECTED]adop cannot detect any application tier nodes in FND_NODES table. Ensure ICM is running and run autoconfig on all nodes
    [UNEXPECTED]Error while checking if this is a multi node instance

    Could you tell me what I should do? I ran the autoconfig script but it did not help. Thanks!

  3. Did you run autoconfig on all the nodes?

    • Yes. I found out that the autoconfig on the app tier is getting this error on the adgenjky.sh script: adgenjky.sh INSTE8_SETUP 1 and the corresponding adgenjky log has this error: Error: Unable to execute statement len = 63

      adjkey error:
      ORA-06550: line 3, column 1:
      PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared
      ORA-06550: line 3, column 1:
      PL/SQL: Statement ignored

      The sqlplus query for this shows:
      SQL> select node_name, node_mode, support_cp, support_web, support_admin,support_forms from FND_NODES;

      NODE_NAME N S S S S
      —————————— – – – – –
      DTW-ORCL-EBS1223 O Y Y Y Y
      AUTHENTICATION O N N N N

      I don’t know why the authentication node is disabled, but I am suspicious this is the culprit. I just don’t know how it got to be disabled. The authentication node is added during the autoconfig script run for the app tier (run environment).

      • Hi maria,

        Can you clean up the fnd_nodes

        sqlplus apps/appspwd

        exec fnd_conc_clone.setup_clean;

        commit;

        run the autoconfig on db tier first and then on the appstier.

        Thanks
        Bala

      • Hi Maria,
        Please let me know whow u resolved this error:
        AD code level : [B.3]

        Error: Unable to execute statement len = 63

        AD Administration error:
        ORA-06550: line 3, column 1:
        PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared
        ORA-06550: line 3, column 1:
        PL/SQL: Statement ignored

        AD Administration error:

        Unable to get passwords from Vault

  4. Hi Bala,
    I get the same errors.

  5. It is very use full hanks Bala

  6. Hi Bala,

    It is very useful for us.

  7. Hi Bala,

    Will it possible to post the Application Upgrade from 11.510.2 to R12.2.4

    Thanks in Advance

  8. Hi Bala

    Really, it is very useful document and is very handy. As I am new to this R12, this doc gave me confidence on upgrading to 12.2.4.

    With lot of thanks.

    Anil

  9. Please any one can share Non-Shared Multinode configuration for R12.2.4, I configured it by following 1383621.1 and added 3 more secondary nodes, after successful addition when I fire adop in primary node the prepare phase is failing with ports , conflicts and those port belongs to the managed servers- ANy suggestions ?

  10. Hi Shishir,

    So you have one primary and 3 secondary nodes right? Can you please let me know what are the service you have enabled on all the 4 nodes.

    Thanks
    Bala

  11. Hi Bala,

    I am pretty sure that this is very useful.
    what about the patches in step 1 and step 2 in case of startCD version12.2.0.49 ?

    Thanks

    • if You are going with startCD version12.2.0.49 the you dont need to consider these patches rather go with below metalink note which has information about patches which are not there in any startCD.Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

  12. Hi Bala,

    I have some issues with the upgrade patches.
    For example, in the case of the database patch# p18260550, there are many conflicts, what is the porper solution?
    another conflict case is the Weblogic server patches(ex: P17572726), I have an error message like the following:

    Patch FCX7 is mutually exclusive and can not coexist with patches: VFS8,D33T, LL4G, YIJF.

    could you please tell me the proper solution?

    Thanks
    John

  13. Hi Bala,

    Actually the weblogic server patch issue is resolved.
    But for the database patch(18260550) is in the list of the Not included in any startCD section, but I think you did not apply that patch.
    is there any reason not applying that patch?

    Thanks a lot in advance
    John

  14. Hi,

    Could you please share similar steps for upgrade EBS 12.1.3 to 12.2.4 with DB upgrade from 11.2.0.3 to 11.2.0.4.

  15. Hi,

    Very helpful!

    Could you please share similar steps for upgrade EBS 12.1.3 to 12.2.4 with DB upgrade from 11.2.0.3 to 11.2.0.4.

    Regards,

  16. Hi Bala,

    installed oracle ebs 12.2.0 successfully using startCD Version 12.2.0.49 and then tried to do database patches(p18260550) according to the consolidated list of patches and technology bug fixes(Doc ID: 1594274.1)

    But I have some prerequisite patches (p10831683 and up to the p20760997).
    So I try to apply the patch (20760997) with so many conflicts.
    I rollbacked all of the conflict patches and then applied the patch 20760997.

    but later in the other database patch like 18614015, that patch has the conflict with the patch 20760997 again.

    so what do I have to do in this situation?
    Do I need to rollback the patch 20760997 patch that was applied to apply the patch 18614015?

    Thanks

  17. Hi, I also have installed Oracle EBS 12.2.0 sucessfully, using startCD49 (12.2.0.49). Now the ETCC tool created a list of missing DB and MT patches … However, seems very confuse the last sentence on doc 1594274.1. Which is:

    If ETCC reports a missing bugfix, you need to identify the patch that includes the missing fix by referring to the relevant table for your component version. Locate the relevant bug in the Bug Numbers column, then work leftwards to the Patch column for your platform. If more than one patch mentions the bug number, install the most recent patch listed in the table.

    That means that I can follow all the bug fixes or need to compare what are the coverage of each one to not rollback ? How about the ones on doc tables ?
    Could you help ?
    Thanks,
    Giuliana

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: