Sunday 4 December 2016

ORACLE R12.2 ARCHITECTURE AND CONCEPTS IN DETAILS


R12.2 file system architecture and their concepts

Hi DBA-Mates,
I am working on R12.2 now a days. And as we all are knowing that how much it is important in market now a days. R12.2 is very hot in the market and everyone wants to learn it. Every Oracle customers are moving to R12.2 now a days.
I have learned it and want to share some ideas about it.

I have completed R12.2.0 full installation from scratch, because that time no one was to teach me. But I did it. I have installed R12.2.0 after a very hard work.
I have done Upgrade also to R12.2.5. Its took time for me because I was doing first time without any support. But really I enjoyed it.
I don't want go through all the story, lets move to topic :D.

Below are the some Important points and commands, which will be very useful to you people who started learning R12.2 Oracle applications.

      R12.2.0 have dual filesystem referred as fs1 and fs2 which alternates between ‘run’ and ‘patch’ with every patching cycle at the end, means after cutover.
        Next is fs_ne non-editioned filesystem which is used to store files needed across all filesystems like log files, patch files etc. 
     ex : PATCH_TOP, ADOP_LOG_HOME
        The run and patch file system, here each use a different s_port_pool.
        In which few ports are same for both fs1 & fs2.   
    For example: s_webport, s_rpcport, s_java_object_cache_port
        The OPMN only manages Oracle HTTP Serve.

Below are the Dual file system diagram. which will be helpful to understanding.









Some Important commands are the below: 

$echo $FILE_EDITION 
$echo $RUN_BASE 
$echo $PATCH_BASE 
$echo $NE_BASE 
$echo $TWO_TASK 
$. $HOME/EBSapps.env patch 

This above command will be helping in Switch between File system Editions. 

DB RUN EDITION: 
Run: Online users connect to this edition, which is always the default database edition. The run edition will always exist. 

DB PATCH EDITION: 
Patch: Patching tools connect to this edition. A child of the run edition, the patch edition exists only while a patching cycle is in progress. 
Old: When a patch edition is promoted to be the run edition, the previous run edition is now regarded as an old edition. 
There may be zero or more old editions at a given time. They are discarded when a full cleanup is performed. You cannot connect to an old edition.


This is in short but very useful. Please let us know for any more description. Keep in contact and share knowledge and your suggestions with us @Contact us ora-data.blogspot.com.
Thanks,
source: https://edp.oraclecorp.com

30 comments:


  1. Hi,

    Your welcome. nice to see you here.

    Thanks.

    ReplyDelete
  2. hi can you tell me what is exactly EDITION BASED REDEFINITION IN R12.2.X

    ReplyDelete
    Replies

    1. Hi Yeshwanth,

      This is R12.2.0. Please let me know for any confirmations.

      Thanks,

      Delete

    2. Dear Yeshwanth,

      Above answer is not proper answer. It may be replied in hurry or without reading full query.
      Actually Edition-Based Redefinition (EBR) enable us to make change/upgrade an application’s database objects while the using application, thus it minimize or eliminate the down time.

      IF you ask me in depth as per my understanding, while we do apply patches . it will apply in Patch file system and it will not effect run file system So, in between these time gap the changes are hold in Editions based of database because when run prepare phase, it will create a editioned based database.

      Hope this may clear now.

      Thanks & Regards,
      ora-data Team

      Delete
  3. Very Nice...Thanks for sharing: rayudu.dba@gmail.com

    ReplyDelete
  4. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle DBA TECHNOLOGY , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor-led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ pieces of training in India, USA, UK, Australia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Pratik Shekhar
    MaxMunus
    E-mail: pratik@maxmunus.com
    Ph:(0) +91 9066268701
    http://www.maxmunus.com/

    ReplyDelete
  5. I read this paragraph fully about the difference of newest and preceding technologies, it's remarkable
    article.

    ReplyDelete
  6. u have given some points regarding filesystem was really excellent.it's in understandable format.everyone can easily understand.thank you

    ReplyDelete
    Replies

    1. Dear User,

      Thank you very much for you comment.
      it is value for us.

      Regards,
      ora-data Team

      Delete
  7. magnificent put up, very informative. I'm wondering why the opposite experts of this sector do not realize this.

    You must proceed your writing. I'm sure, you've a great readers' base already!

    ReplyDelete
    Replies

    1. Dear User,

      Thank you for your appreciations. We will try our best.

      Regards,
      ora-data Team

      Delete
  8. This is the right blog for everyone who hopes to understand this topic.

    You know a whole lot its almost tough to argue with
    you (not that I really would want to…HaHa). You certainly put
    a brand new spin on a subject that's been discussed
    for a long time. Excellent stuff, just excellent!

    ReplyDelete
  9. I’m not that much of a online reader to
    be honest but your blogs really nice, keep it up! I'll go ahead and bookmark your site to come back down the road.
    Cheers

    ReplyDelete
    Replies

    1. Dear User,

      Thank you very much for your great feedback.
      Please follow us by email as published in Blog at top.

      Regards,
      ora-data Team

      Delete
  10. Hi there, I log on to your blogs daily. Your writing
    style is witty, keep doing what you're doing!

    ReplyDelete
    Replies

    1. Dear User,

      Thank you very much for your Feedback.
      Please follow us by email for any new updates...

      Regards,
      ora-data Team

      Delete
  11. This piece of writing gives clear idea for the new
    visitors of blogging, that really how to do running a blog.

    ReplyDelete
  12. Hi, the whole thing is going nicely here and ofcourse every
    one is sharing information, that's in fact good, keep up
    writing.

    ReplyDelete
  13. Ridiculous quest there. What occurred after? Good luck!

    ReplyDelete
  14. Howdy! I could have sworn I've visited this blog before but after looking at a few of the posts
    I realized it's new to me. Anyhow, I'm certainly delighted I came across it and I'll be bookmarking it and checking back often!

    ReplyDelete
  15. An impressive share! I've just forwarded this onto a friend who had
    been doing a little homework on this. And he actually
    bought me breakfast simply because I found it for him...
    lol. So allow me to reword this.... Thanks for the meal!!

    But yeah, thanks for spending time to discuss this issue here on your web page.

    ReplyDelete
  16. Hi, the whole thing is going fine here and ofcourse every one is sharing data,
    that's genuinely excellent, keep up writing.

    ReplyDelete
  17. I just like the valuable info you provide on your articles.
    I will bookmark your weblog and test again here regularly.
    I am slightly sure I will learn a lot of new stuff right here!
    Good luck for the next!

    ReplyDelete

  18. Dear User,

    Thank you for your feedback.
    We are here to share knowledge... Please share it as much as possible.

    It is our pleasure...

    Regards,
    ora-data Team

    ReplyDelete

  19. Dear User,

    Thank you for your great feedback.

    Regards,
    ora-data Team

    ReplyDelete

  20. Dear User,

    Thank you for your great feedback.
    You can get listed in yahoo once you submit index in bingo toolbar.

    Regards,
    ora-data Team

    ReplyDelete
  21. Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Fusion Financials . Actually I was looking for the same information on internet for Oracle Fusion Financials and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more aboutOracle Fusion Financials . By attending Oracle Fusion FinancialsTraining .

    ReplyDelete

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