Saturday 3 December 2016

Step by Step to apply patches in Oracle Apps R12.2. by using adop utility

Hi DBA-Mates,
As we are knowing that applying patch in ORACLE EBS R12.2 is different than R12.1.
I would like to share here the steps for applying patching in r12.2 with concepts and details.

From R12.2.0 onward oracle has introduced online patching functionality called ADOP.

Oracle EBS 12.2 introduces Online Patching, a new feature that greatly reduces the downtime that was needed in previous releases for application of Release Update Packs (RUPs), Critical Patch Updates (CPUs), and other patches and bug fixes of various kinds.

Note: The classic patching model is designed to minimize downtime by running as fast as possible, using whatever resources are needed. In contrast, the online patching model is designed to minimize downtime by allowing patching operations to be performed while users remain on the system.

As we know in R12.2, There are 3 File System Installed.

1: FS1 – (RUN_EDITION) Production file system that is used by online users when system is being patched.

2: FS2 – (PATCH_EDITION) Exact copy of production(fs1) used by the patching tools. Changes do not affect the running application(RUN_EDITION). 

When patching is completed and we do CUTOVER, then patching tool swaps the FS1 and FS2 file systems. 
It means, FS2  file system will become FS1 , which will be access by the users.

3: FS-NE (Non-Edition) – This is a non-edition file system which stores data that is stored in a file system like log file, report file and patch top files.

There are below 5 Phases of ADOP(online patching):

1) PREPARE
2) APPLY
3) FINALIZE
4) CUTOVER
5) CLEANUP

Steps:-
1. Download the patch and unzip on patch_top.

2. Must go through Readme.html or readme.txt.

3. Prepare the system for patching

     a.  we can run the .env file . or the adop utility sets its own environment.
     b. Then run the below command for prepare the System for patching:

$ adop phase=prepare

4. Wait for the prepare phase to be complete.
Please check the status from below points:

$ adop -status 
Enter the APPS username: apps 
Enter the APPS password: 

5. After completion Prepare phase, go to next phase called Apply phase:

$adop phase=apply patches=1234567
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...


6 . After completion of apply phase, goto next phase called Finalize phase:
i.e like Ready the instance for cutover

$ adop phase=finalize
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...

7. After completion of Finalize phase, goto next phase called Cutover:

$ adop phase=cutover
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...

Note: Keep checking Status after every Phases.

8. After completion of Cutover phase, run next Cleanup Phase
We can do this step after instance is released to Customer.

$adop phase=cleanup
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Note: 
If there are some reason either the prepare or apply phase failed or any problems then you can abort this patching cycle.

$adop phase=abort

But always remember, after running abort, you must always run a full cleanup as: 

$adop phase=cleanup cleanup_mode=full

So, this will remove all columns that were added by the patches but are no longer needed because of the abort. 
And If that columns are not removed, then that may create problems in a later patching cycle.


Some more useful link:
Differences between R12.1 and R12.2
R12.2 Architecture and Concepts
Oracle Database
Important SQL Scripts
Interviews Questions And Answers

Please comment for any more query and suggestions either in comment box or Contact Us at ora-data.blogspot.com

37 comments:

  1. I'm very happy to read this. This is the type of manual that
    needs to be given and not the accidental misinformation that is at the other blogs.
    Appreciate your sharing this best doc.

    ReplyDelete
  2. workd todayyy '

    ReplyDelete
  3. adop phase=prepare
    result:bash:adop: command not found

    ReplyDelete
    Replies

    1. Hi Gopi,

      Its nice to see you here.
      1. Check env. file and run correct env. file. Also Check the $PATH and $LD_LIBRARY_PATH entries and location are fine.

      2.Please check the output of wall? we faced this issue during cutover.
      $ which wall << please check this output
      If no output then add the binary location to PATH and bounce the services and again re run.

      Hope this may useful. And let us know if still issue there.

      Regards,
      ora-data Team.

      Delete

    2. Please also check for syntax correctly without any space or any typo mistakes.
      Also no process should run on Patch file system (by mistake).
      Because it saying as command not found.

      Regards,
      ora-data Team,

      Delete
  4. All Slots has lots and plenty of on-line slots.

    ReplyDelete
  5. excellent notes.Really satisfied and appreciate the work.please help me with some docs on 12.1,12.2 to read as im a fresher DBA. My mail id is vjkumarlokhe5555@gmail.com.

    ReplyDelete
    Replies

    1. Dear User,

      I have a very nice docs for ADOP but that is Hard-copy . I will try to write here in free time.

      Regards,
      ora-data Team

      Delete
  6. I am Buddhika from Sri Lanka and yesterday commence studies about EBS. Pls share me if any foundation document if you all have

    ReplyDelete
    Replies

    1. Dear Buddhika,

      Thank you for your interest and comment. Sure, I would like to share the docs here.
      Please let me know if you need any particular stuff.

      Regards,
      ora-data Team

      Delete
  7. Thanks for helping out, good info.

    ReplyDelete
    Replies

    1. Dear User,

      Thank you for your feedback, always welcome here.
      Recently we have update R12.2 Cloning steps, please check :R12.2 CLONING STEPS

      Regards,
      ora-data Team

      Delete

  8. Dear User,

    Thank you your valuable words. Yes we have updated some important topics, please check...
    You can follow us on FB and bookmark us.

    Regards,
    ora-data Team

    ReplyDelete
  9. Hi,
    Thanks for sharing this doc. this is excellent.
    But I'm looking for more details of every phase(s).

    For example: how prepare phase works?

    Like above question, i'm looking for 5 phase of patching.
    Can you please help me in this issue?

    Thanks again

    ReplyDelete
    Replies
    1. Dear Reyaz,
      Thank you for your interest and feedback.
      Yes, we have all the details. We are some busy with upgrade stuff. Once get time we will try to post asap.
      We are damn sure, that will be very helpful and also we are damn sure nothing is more than that in ADOP.

      Regards,
      ora-data Team

      Delete
  10. Hi exceptional blog! Does running a blog similar to this require a massive amount work?
    I have virtually no understanding of computer programming
    but I was hoping to start my own blog soon. Anyways, if you hsve any ideas or tips for new blog owners
    please share. I understand this iis off topic but I just had to ask.
    Many thanks!

    ReplyDelete
    Replies
    1. Dear User,
      Thank you for your feedback and interest.
      It does not need much programming here. It is very easy but only the thing is it always takes time to write good stuff. I am not sure about others but it takes much time for us to write, verify and post here because we always share only real time scenario experiences.

      Otherwise its all easy.

      Regards,
      ora-datat Team

      Delete
  11. Fantastic site. Plenty of useful info here.
    I am sending it to some pals ans also sharing in delicious.
    And obviously, thanks on your sweat!

    ReplyDelete
    Replies

    1. Dear User,

      Thank you very much for your great feedback.
      Also, please follow us by email.

      Regards,
      ora-data Team

      Delete
  12. Thanks for your personal marvelous posting!

    I definitely enjoyed reading it, you might be a great author.

    I will make sure to bookmark your blog and will come back from now on. I want
    to encourage that you continue your great posts, have a nice afternoon!

    ReplyDelete
    Replies

    1. Dear User,

      Thank you very much for your great feedback. Its really mean for us...
      Also, please follow us by email.

      Regards,
      ora-data Team

      Delete
  13. Wow, amazing blog layout! How long have you been blogging for?
    you made blogging look easy. The overall look of your website is
    fantastic, as well as the content!

    ReplyDelete
    Replies

    1. Dear User,

      Thank you very much for your great feedback. Its really motivate us...
      Also, please follow us by email.

      Regards,
      ora-data Team

      Delete

  14. Dear User,

    Thank you very much for your great feedback.
    Also, please follow us by email.

    Regards,
    ora-data Team

    ReplyDelete
  15. We're a group of volunteers and starting a new scheme in our community.
    Your web site provided us with valuable info to work on. You have done an impressive job and our
    entire community will be grateful to you.

    ReplyDelete
  16. Hi friends, how is everything, and what you would like to
    say concerning this post, in my view its actually remarkable designed for me.

    ReplyDelete
  17. It's wonderful that you are getting thouvhts from this paragraph
    aas well ass from our dialogue made here.

    ReplyDelete
  18. Hi, everything is going fine here and ofcourse every one is sharing information, that's really good,
    keep up writing.

    ReplyDelete
  19. Thank you very much for your great feedback. Its really mean for us...
    Also, please follow us by email.
    apply tools

    ReplyDelete
  20. I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post. Apply Slotxo

    ReplyDelete
  21. Thanks, that was a really cool read! get more info

    ReplyDelete
  22. Wonderfully explained to apply patch using <a href="https://orahow.com/adop-online-patching-in-oracle-apps-ebs-r12-2/" rel="follow'>adop</a>

    ReplyDelete
  23. Great explanation to apply adop patch in R12.2

    ReplyDelete
  24. You share information related to apply patches in Oracle in detail. You define step by step with different tips and techniques. This post is very helpful for students. Moreover, The garage door repair Acworth GA specialists provide a wide range of garage door repair services, from minor repairs to significant system replacement.

    ReplyDelete
  25. Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. website

    ReplyDelete
  26. This post is really magnificent. I really like this post. It is one of the best posts that I ve read in a long time. Thanks a lot for this really good post. I really appreciate it! visit this site

    ReplyDelete

Thank you for your comments and suggestions. It's good to talk you.