Thursday, April 17, 2014

How can we control a concurrent program to Run In Specific RAC/PCP node?

How can we control a concurrent program to Run In Specific RAC/PCP node?


There is an interesting feature in R12 for this to achieve.


In concurrent program define window , we can define which node and instance a concurrent program should connect and run, That is through concurrent program session control.

Navigation: System Administrator Responsibility > Concurrent > Program > Define > Click 'Session Control' 

You can define in this screen Target Node and Target Instance for that particler concurrent program. 

Irrespective of the managers running on the node and connected to which ever RAC instance, This definition makes sure the program is run in the specified RAC/PCP node.

What is Target Node 
------------------------

If you specify the target node on which requests for this program will run. When requests for this program are submitted, They run on this node if that is node is available, 

If no specification is made for the target node of a concurrent program, a request for it will be picked up by any manager available to run it. 

If a node specification is made for a concurrent program and the node is up, only available managers running on the specified node will pick up the request. 

What is Target Instance 
----------------------------

When requests for this program are submitted, they run on this database instance node If it is available.

If no specification is made for the target instance of a concurrent program, a request for it will be picked up by the first manager available to run it and will be run in the instance where the manager is already connected.

If an instance specification is made for a concurrent program and the instance is up, it will be picked up by the first manager available to run it and the manager will run the request in the specified instance. 

However, if the target RAC instance is down, the manager will run the request in the instance where it is already connected and log an appropriate message.

49 comments:



  1. this is very good nice article. this is very useful for Oracle Apps DBA students.


    ==========================================================
    This is very nice article. This is very use ful for Oracle Apps DBA Learners.
    http://www.bytesonlinetraining.com/oracle-apps-dba-online-training/
    ===========================================================

    hi sir. i want to do Oracle Apps DBA training.
    Oracle Apps DBA ONlINE TRAINING Thanks for providing valuable information.

    ReplyDelete
  2. I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

    Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Financial for Indian Localization, Oracle Apps SCM, Oracle Apps HRMS, SQL, PL/SQL and D2K at training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91 – 9581017828 | http://www.oracleappstechnical.com

    LinkedIn profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/

    ReplyDelete
  3. I used to be able to find good info from your content.
    SAP APO Online Training

    ReplyDelete
  4. Hai,

    Nicely written post. I am just about to start a new blog and there could not have been a better guide than this one for some good pointers. I am looking forward to starting a successful blog after reading this incredibly useful post of yours. Waiting for more such posts like this.

    Keep writing and sharing!

    aamala

    SEO Training in Chennai

    ReplyDelete
  5. Thank you for having taken your time to provide us with your valuable information
    relating to your stay with us.we are sincerely concerned.., Most importantly, you
    Keepit the major... Peridot Systems Consumer Complaints

    ReplyDelete

  6. This is my first time visit on your site and i have bookmark this for again visit.
    SAP GTS Training In Hyderabad

    ReplyDelete
  7. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  8. "If an instance specification is made for a concurrent program and the instance is up, it will be picked up by the first manager available to run it and the manager will run the request in the specified instance."

    In the above case what if i specify s_cp_twotask to SID other than the one requested.

    Appreciate help.

    Thanks,
    Jampani

    ReplyDelete
  9. Hi, I am really happy to found such a helpful and fascinating post that is written in well manner. Thanks for sharing such an informative post. keep update your blog. R Programming Online Training

    ReplyDelete
  10. wonderful information, I had come to know about your blog from my friend nandu , hyderaba.
    i have read atleast 7 posts of yours by now, and let me tell you, your website gives the
    best and the most interesting information. This is just the kind of information that i had
    been looking for, i'm already your rss reader now and i would regularly watch out for the new posts.



    Oracle Fusion Cloud HCM Training

    ReplyDelete
  11. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle Applications DBA, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Oracle Applications DBA . We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us:
    Name : Arunkumar U
    Email : arun@maxmunus.com
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –http://www.maxmunus.com



    ReplyDelete
  12. Nicely written post. I am just about to start a new blog and there could not have been a better guide than this one for some good pointers. I am looking forward to starting a successful blog after reading this incredibly useful post of yours. Waiting for more such posts like this. - happy room online | juegos friv gratis

    ReplyDelete
  13. Its very useful article for DBA.
    Keep it up

    ReplyDelete
  14. power washing services Virginia Very helpful information,thanks a lot for sharing,please keep updating.

    ReplyDelete
  15. Thanks for sharing this in here. You are running a great blog, keep up this good work.

    Check it once :
    AWS Training in chennai | AWS Training institute in velachery

    ReplyDelete
  16. Wow at last I get you. This post can increase my knowledge . I am very glad to know that this is excellent site which is providing you high quality information. Thank you for your amazing post.Oracle Financials Training in Ameerpet

    ReplyDelete
  17. I applaud the publication of your artilce on control-concurrent-program. It's a good reminder to look on the Hadoop Training.

    I have shared some of your stories with my colleagues and we have all found useful information in them. Thank you for sharing with us the post that you have worked so hard to refine.

    hadoop training institutes in chennai |
    Big Data Hadoop Training in Chennai

    ReplyDelete
  18. Wonderful article, very useful and well explanation. Your post is extremely incredible. I will refer this to my candidates...
    Devops training in Chennai
    Devops training in Bangalore
    Devops Online training
    Devops training in Pune

    ReplyDelete
  19. Hello! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done an outstanding job.
    Best AWS Training in Chennai | Amazon Web Services Training in Chennai

    AWS Training in Bangalore | Amazon Web Services Training in Bangalore

    ReplyDelete
  20. http://www.greghoustoncomedy.com/2016/05/steph-tolev-up-close-n-gross.html?showComment=1537624374781#c7986002677319952472

    And that is if Jedrzejczyk reversed the script and asked the reporter to measure to the podium. What happened next will make you cringe.

    See it unfold from the media above.UFC 229 Live

    ReplyDelete
  21. And that is if Jedrzejczyk reversed the script and asked the reporter to quantify to the podium. What happened next will make you cringe.

    Watch it unfold in the video above.UFC 229 Live Stream Online

    ReplyDelete
  22. Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision.
    Selenium Training in Chennai | Selenium Training in Bangalore | Selenium Training in Pune | Selenium online Training

    ReplyDelete
  23. This is very good content you share on this blog. it's very informative and provide me future related information.
    python training in velachery
    python training institute in chennai

    ReplyDelete
  24. Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
    Devops training in sholinganallur
    Devops training in velachery
    Devops training in annanagar
    Devops training in tambaram

    ReplyDelete
  25. Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.

    rpa interview questions and answers
    automation anywhere interview questions and answers
    blueprism interview questions and answers
    uipath interview questions and answers
    rpa training in chennai

    ReplyDelete
  26. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 

    angularjs-Training in velachery

    angularjs Training in bangalore

    angularjs Training in bangalore

    angularjs Training in btm

    angularjs Training in electronic-city

    ReplyDelete
  27. Hello! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done an outstanding job.

    Best AWS Training in Chennai | Amazon Web Services Training in Chennai

    AWS Training in Chennai | AWS Training Institute in Chennai Velachery, Tambaram, OMR


    AWS Training in Chennai |Best Amazon Web Services Training in Chennai


    AWS Interview Questions And Answers

    ReplyDelete
  28. I found this informative and interesting blog so i think so its very useful and knowledge able.I would like to thank you for the efforts you have made in writing this article.
    Data Science Training in Indira nagar
    Data Science Training in btm layout
    Python Training in Kalyan nagar
    Data Science training in Indira nagar
    Data Science Training in Marathahalli | Data Science training in Bangalore

    ReplyDelete
  29. Its really an Excellent post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog. Thanks for sharing....
    python course in pune
    python course in chennai
    python course in Bangalore

    ReplyDelete
  30. Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..
    excel advanced excel training in bangalore | Devops Training in Chennai

    ReplyDelete
  31. Very interesting to read and learn new things to update myself to career, unique content, requesting to update more things
    Java training in chennai | Data Science Training in Chennai | DevOps Training in Chennai

    ReplyDelete
  32. Thank you for benefiting from time to focus on this kind of, I feel firmly about it and also really like comprehending far more with this particular subject matter. In case doable, when you get know-how, is it possible to thoughts modernizing your site together with far more details? It’s extremely useful to me.
    python training in chennai
    python course in chennai
    python training in bangalore

    ReplyDelete
  33. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    Java training in Chennai | Java training in Omr

    Oracle training in Chennai

    Java training in Chennai | Java training in Annanagar

    Java training in Chennai | Java training institute in Chennai | Java course in Chennai

    ReplyDelete
  34. Awesome..You have clearly explained …Its very useful for me to know about new things..Keep on blogging..
    iphone service center | ipad service center | imac service center

    ReplyDelete