Sunday, 4 December 2016

Online Patching Questions and Answers R12.2


Hi Friends,

 As we all are knowing that Oracle EBS R12.2 is very hot in market. I am working on R12.2 and I have upgraded also. I would like to share my some experiences with you all which will be very useful and helpful here:


Question: Is Online Patching change the way data fix patches are applied to Oracle E-Business Suite 12.2?
Answer: Yes, of course. Data fix patches (used to fix transactional data) require special type of handling. And the patch readme.txt or readme.html will give full instructions.

Question: Will Online Patching have any performance implications?
Answer: Actually, Online patching in R12.2 is designed to run efficiently alongside the running application.  And while an Online Patching cycle is in progress, there is a small additional processing overhead. The degree of this additional overhead can be managed by controlling the number of parallel workers used by Online Patching.

Question: How does the adop utility will work in a multi-node environment?
Answer: The adop Online Patching utility uses remote APIs and ssh login to execute patching operations on remote nodes in a multi-node environment. Then the node that launches adop will be the ‘master’ node, and the remote nodes are referred to as ‘slaves’.

Question: Will editioning views on top of the data model have an impact on performance?
Answer: No. The editioning views are special views that were specifically designed not to have any type of performance impact on the applications.

Question: Will adadmin and AutoConfig maintenance tasks such as adrelink be performed online?
Answer: Yes, correct. these maintenance tasks will be performing online. The relevant operations will be targeted to the patch file system, and should be performed during a patching cycle. They will not have any impact on the run file system.

Question: Will Online Patching increase the network port requirements on an Oracle E-Business Suite instance?
Answer: Yes, right. Online patching requires an additional set of network ports for the Oracle WebLogic Server managed servers on the second file system. And during the cutover phase, the managed servers run simultaneously on the patch file system and run file system for a brief period, in a rolling transition process.


Some more useful links:

R12.2 Interviews Questions & Answers-2

R12.1 vs R12.2

 Job Tips

 Career Planning

 SQL Scripts



We will be update many more questions very frequently, keep in touch.
Hope above questions will be useful. For any concerns or suggestions, please write to either in comment box or contact us@ora-adata.blogspot.com

Thanks,



Posted by at
Labels: ,

50 comments:

  1. Unknown15 April 2017 at 01:03

    Hi i have one doubt on 12.2 adop can you tell me

    My question is when i am applying patch using ADOP and patch got failed in middle and there is

    no way to we can continue we contacted oracle support

    they updated the patch and gave you how will u start the patch? WHAT DO U DO?

    Could you please ans the above one

    ReplyDelete
  2. ORA-DATA Team15 April 2017 at 12:18

    Hi Charan,
    Your questions is right and thanks for visiting and asking question.

    As you have already contacted oracle support and they have suggested. But as per my experiences it depends on the situation and patching condition.

    Many times we have applied patches and got failed and we again apply it.
    Actually, if you have seen log file, it will store in a session and if you are applying again it will for same session to start.

    I will check for my patch log and show you the details and how it works. So it will be very clear you.

    Thanks,

    ReplyDelete
  3. Unknown20 April 2017 at 10:32

    Hi Sunil,

    During prepare phase patch edition will be created is the patch edition existed throughout the patch or at certain deleted? could you tell me

    ReplyDelete
    Replies
    1. ORA-DATA Team21 April 2017 at 20:27

      Hi Sri charan,

      There is nothing like creation or deletion of patch edition, it will only updated from run file system to patch file system.

      It's good to see you here and your learning effort.

      Thanks,

      Delete
  4. Unknown25 April 2017 at 00:42

    Hi Sunil,

    I have one question for you regarding patching whether it is R12.1 OR R12.2

    If patch is taking 30 mins in non production whereas in prod it is taking one hour then

    What are the possible causes for this issue. Could you please give your valuable answer in

    detail step by step that would help to me and all the viewers.

    ReplyDelete
    Replies
    1. ORA-DATA Team25 April 2017 at 01:16


      Dear Charan,

      Below points may causes differences:
      1. Is the production and test env. are recently cloned?
      2. May be workers differences.
      3. May be S/w and h/w diff.
      4. There may be differences between the file sizes on environments.
      5. Reboot timing differences
      etc. these are points which may varies. Hope this may useful.
      Also let me know what type of patches you are using.
      Also check the alert log, which may clear more.

      Thanks for your question. Let me know for any more concerns.
      Keep it up.

      Delete
  5. Unknown25 April 2017 at 00:48

    What is dualfs option in R12.2 Cloning could you tell me exactly what it does?

    ReplyDelete
    Replies
    1. ORA-DATA Team25 April 2017 at 01:20

      I think I have explained in my other post. please check it.
      https://ora-data.blogspot.in/2016/11/oracle-r122-architecture.html

      if still not clear please let us know.
      Thanks.

      Delete
    2. Unknown27 April 2017 at 00:17

      Hi Sunil,

      I am not clear about my last question dualfs option which i had asked earlier

      What is dualfs? what happens when we run perl adcfgclone.pl appsTier dualfs? What does it do exactly. Could you explain in detail.

      Delete
    3. Unknown27 April 2017 at 00:29

      User says that his forms are running or opening very slow on client machine? What should be your approach and what are the possible causes for this issue as well as how to resolve this issue? Do we need to check anything on server side?

      Delete
    4. Unknown27 April 2017 at 00:35

      1) If one user facing that his forms are running slow what we need to check on client desktop? what should be your approach and how to resolve this issue.

      2) if all the users are facing the same issue with the forms on client desktop? What should be the reason for this issue and how to resolve this issue. Please do reply one of the most imp troubleshooting question.

      Delete
    5. Unknown27 April 2017 at 00:38

      I have done customizations for forms and reports do i need to run adpreclone.pl after that? if not why?

      Delete
    6. ORA-DATA Team27 April 2017 at 02:02

      Hi Charan,

      dualfs, do you mean dual file system? If is it correct then please follow below post:
      R12.2 Architecture and Concepts

      Thanks,

      Delete
    7. ORA-DATA Team28 April 2017 at 13:13


      Hi Charan,

      $perl adcfgclone.pl appsTier dualfs
      This command will make ready both run fs and patch fs for cloning.
      So, there is no need to run again and again for cloning.
      And it is started from R12.2.5.

      Thanks,

      Delete
  6. Unknown28 April 2017 at 01:07

    Hello Sunil,

    i asked perl adcfgclone.pl appsTier dualfs not dual file system in cloning we have this option.Could please tell me and please give reply to my previous day question issues answers

    ReplyDelete
    Replies
    1. ORA-DATA Team28 April 2017 at 13:20


      Hi Charan,

      $perl adcfgclone.pl appsTier dualfs
      This command will make ready both run fs and patch fs for cloning.
      So, there is no need to run again and again for cloning.
      And it is started from R12.2.5.

      Delete
    2. ORA-DATA Team28 April 2017 at 13:22


      You: I have done customizations for forms and reports do i need to run adpreclone.pl after that? if not why?

      Answer:
      As there is no need to run adpreclone , we usually copy that customization forms and reports.

      Thanks,

      Delete
  7. Unknown28 April 2017 at 23:19

    user says that his forms are running very slow?
    (or)
    At client side forms are very slow how u will troubleshoot?

    Could you please help me out its one of the frequent questions asked in interview point of view

    ReplyDelete
    Replies
    1. ORA-DATA Team29 April 2017 at 20:27


      Hi Charan,

      Can you please give some version details?
      Is it always or some times?
      Is it for everyone or for some people?

      Thanks,

      Delete
    2. ORA-DATA Team29 April 2017 at 20:34

      Also have applied any patches?
      Its behavior like this from starting or after any alteration?

      Thanks,

      Delete
    3. Unknown1 May 2017 at 00:02

      Hello Sunil,

      The version is 11i and R12.1.3
      There are two cases actually this issue comes

      case I: For a single user

      case II: Multiple users

      For the above cases what do i need to check on client desktop as well as on serverside how to resolve the issue.

      Give me what are the possible causes occuring for the above issue and solution.Whichever you know

      Thanks in advance

      Delete
    4. ORA-DATA Team1 May 2017 at 05:03


      Hi Charan,

      There may be a reason of after increasing the number of application users.
      Below things need to be check:
      1. Verify that the user has only one active session.
      2. It can be related to the size of the frmweb processes when executing RUN_REPORT_OBJECT() from Forms or running Forms that contain imported java.
      3. And also Users closing the browser instead of gracefully exiting the Form.

      There may many more reason. Which I will post in my next post.

      And also check the general thing as:
      Login to front-end -> Help -> Diagnostics -> Trace -> "Trace with Binds and waits"
      Check trace file.
      Then run either tkprof or Trace Analyzer.
      Note: After enable Trace, disable it asap, because it dec. the performance. We use it for checking the error and details for performance related issue.

      Will post you more details very soon.

      Thanks,

      Delete
  8. Unknown5 May 2017 at 00:09

    I would like to ask you few questions regarding cloning and patching issues and could you please let me know the answers and the response which we got from your blog is really appreciable and helpful to all the appsdba job seekers and i will be very thankful to you if you could give the same response in future also


    1) Suppose i have done cloning from prod to dev and post steps also done successfully after that when i up the services concurrent managers are not coming up
    what could be the reason where do i need to check exactly? There are so many
    scenarios for the cause of this issue. Could you please give me few scenarios which you know?


    ReplyDelete
    Replies
    1. ORA-DATA Team5 May 2017 at 20:39


      Dear Charan,

      First. We need to check the adstrtal.sh log file.
      Secondly, check the ICM log file or concurrent log file that which process is awaiting for.

      There are many 100 of scenario depends on situations.
      Thanks,

      Delete
  9. Unknown5 May 2017 at 00:11

    2) I have applied adpatch it got completed successfully and when i started the services concurrent managers are not coming up where do i need to check what could be the reason can you give me few scenarios for the cause of this kind of issue.


    In the above two questions we can check concmgr logfiles but i need to know some scenarious and where we need to check exactly

    ReplyDelete
  10. Unknown18 May 2017 at 22:55

    After cloning from prod to dev my dbase is slow? What are the possible causes and how can we troubleshoot? Could you please provide steps

    ReplyDelete
  11. ORA-DATA Team19 May 2017 at 19:29

    Dear Charan,

    We can check alert log, we can check top commands if any process are consuming high process, need to check timings and all.
    Check for
    https://ora-data.blogspot.in/2016/11/query-session-details.html "Session information"
    and https://ora-data.blogspot.in/2017/04/deadlock-in-oracle.html "Deadlock details" etc.
    Also very important, check the DB links, is it pointing to production?

    Regards,
    ORA-DATA Team.

    ReplyDelete
  12. Unknown29 May 2017 at 12:11

    Hi Sunil,

    I have one question which is related to OS related (i,e)

    if load on the server is high if it is linux os then how to debug it as an AppsDBA what could be the reason can
    you provide the steps and using top command we can know the load on the server but if it is high how to resolve this issue?

    ReplyDelete
    Replies
    1. ORA-DATA Team1 June 2017 at 21:48


      Hi Charan,

      Load on server, do you mean CPU usage is high?
      Please clear this point. Will update you the work-around.

      If the CPU usage is high, we need to check which PID is using high CPU. And then find out the details of that PID. Check what doing it, what query is running what action is going on.
      After finding all the details, check with concerns team if that is important or not?

      According to that , we can take action either we kill that or leave it. If that is running any SQL command, then check and ask for sql tuning.
      Like that we need to take action.

      This is not enough but hope this may useful. There are lots of things like this.

      Regards,
      ora-data Team.

      Delete
  13. Unknown2 June 2017 at 22:13

    Hi Sunil,

    Yes, the cpu usage is high what we need to check please give in detail steps.

    ReplyDelete
    Replies
    1. ORA-DATA Team5 June 2017 at 05:22


      Hi Charan,

      Nice to see your effort in learning.
      Please go through the above comments which we have given the work-around in my comments, if any doubt, please let us know. Thanks.

      Regards,
      ora-data Team.

      Delete
  14. Unknown2 June 2017 at 23:34

    Hello,
    I have a question Could you tell me

    If my patch(adpatch) got failed with some priviliege what will you do? How will you give privilege to it?

    ReplyDelete
  15. Unknown2 June 2017 at 23:40

    I have applied a patch it created some invalids how do i know whether it is created before applying patch or after applying patch? give me the command

    ReplyDelete
  16. Unknown2 June 2017 at 23:42

    *** Suppose I am applying a patch without mmode and patch says that mmode is not enabled so can you enable mmode using adadmin? Does it allow us or any alternative way to enable mmode?

    ReplyDelete
  17. Unknown2 June 2017 at 23:49

    When we apply adpatch while patch is going on does patch touch custom top or not? Do we have any patches for custom top? Can you give me some information about it it's very important faq in interview point of view?

    ReplyDelete
    Replies
    1. ORA-DATA Team5 June 2017 at 05:20


      Hi Charan,

      Its all about Patching questions and scenario. For all you question, I have a doc. which we will share on our next post, that clear you doubt. We will keep in mind to clear there you all your adpatch doubts...

      Regards,
      ora-data Team.

      Delete
  18. Unknown5 June 2017 at 10:46

    Hello Sunil,

    Please try to give reply as early as possible for my previous all patching questions. I would be
    thankful to you if you could provide the docs for my questions especially patching

    ReplyDelete
  19. Unknown12 June 2017 at 23:57

    Hi Sunil,

    If i have created db user and i want to change his password can we change his password using fndcpass? Could you please tell me

    ReplyDelete
    Replies
    1. ORA-DATA Team14 June 2017 at 02:17


      Dear Charan,

      Nice to see you here.
      FNDCPASS is used for changing apps password, not for changing the DB user password.

      For db password change you can use below command:
      sql> alter user username identified by password;

      Regards,
      ora-data Team.

      Delete
  20. Unknown12 June 2017 at 23:58

    Can we login to frontend using apps? If not why

    ReplyDelete
    Replies
    1. ORA-DATA Team14 June 2017 at 02:20

      Hi Charan,
      Goto front end and check, is there apps user existing? Hope you know how to check front end user existing or not?

      apps is not EBS user.

      Regards,
      ora-data Team.

      Delete
  21. Unknown13 June 2017 at 00:06

    How do you know how many users are connected to appln at 2pm? Could you give me the command and details?

    ReplyDelete
  22. Anonymous13 June 2017 at 13:51

    It's a pity you don't have a donate button! I'd
    without a doubt donate to this fantastic blog! I suppose for now i'll
    settle for book-marking and adding your
    RSS feed to my Google account. I look forward to brand
    new updates and will share this blog with my Facebook group.
    Chat soon!

    Here is my web page :: Sonix Garcinia Scam

    ReplyDelete
  23. Unknown18 June 2017 at 11:38

    Hi Sunil,

    I asked you few adpatch related questions on june 2nd and please reply me with your answers and you said
    that you would have shared a patching scenarios document could you please share the document reply to my previous questions?

    ReplyDelete
    Replies
    1. ORA-DATA Team18 June 2017 at 21:32


      Hi Charan,

      Sorry for delay, actually some upgrade is going on in which was busy a lots, One of my friend has update adpatch scenario in blog. Please find the below link:

      https://ora-data.blogspot.in/2017/06/oracle-r12-patch-failed-how-to-restart.html

      Some more Question and Answers posting very soon.

      Regards,
      ora-data Team.

      Delete
  24. Unknown27 June 2017 at 23:14

    Hi Sunil,
    My concurrent request is running longtime this is the most imp and one of the faq's in interview point of view for exp candidates?
    Could you please tell me how to resolve this issue give me in detail explanation it's very important and what we need to check exactly give reply ASAP?

    ReplyDelete
    Replies
    1. ORA-DATA Team1 July 2017 at 03:24


      Hi Charan,

      Actually, in such cases, we need to check the sql/program which is running.
      2nd- We need to check that last time how much it took time.
      3rd- We need to check if any blocking/locking is there.
      4th- We need to check for any deadlock.
      5th- We may need to Tune the sql.

      These are the basic and important, which we need to check.
      Hope this may helpful. Please let us know for any concerns.

      Note: This post is long now, can you please ask your question on other relevant posts.

      Regards,
      ora-data Team.

      Delete
    2. Unknown3 July 2017 at 23:35

      In my last question you have provided few imp points like 1st to 5th can you provide how to check

      1st: which sql/program is running long through command

      2nd: how to find out last time how much it took time through comd

      3rd: how to find out if any blocking/locking using query

      4th: how to check any deadlock is there or not

      and do we need to check any information related to that program like as below

      * Any incompatiable requests/programs are running for that program

      * check any invalid objects related to that program

      * Do we need to enable any trace for that program

      Could please correct me if i am wrong and provide if there is any other information related to long running concurrent request.

      Delete
    3. Unknown3 July 2017 at 23:40

      Hi,

      I asked you 4 questions regarding patching on june 2nd Could you please provide answers for those questions It would be helpful to all the viewers Could you please check and reply ASAP and i will post my upcoming questions in other post as you said

      Delete
    4. ORA-DATA Team9 July 2017 at 15:54


      Dear Charan,

      Comments are going more only on this post.
      Please use other related posts for your comments.

      Regards,
      ora-data Team.

      Delete

New comments are not allowed.

Subscribe to: Post Comments (Atom)