Pages

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.

101 comments:

  1. 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
  2. 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

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

    ReplyDelete
  4. 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
  5. "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
  6. 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
  7. 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
  8. 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
  9. Its very useful article for DBA.
    Keep it up

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

    ReplyDelete
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. Do not wait for luck, catch it by the tail.best internet casino games Then come to us and win.

    ReplyDelete
  22. She came to visit her neighbor and she showed me this site knowingall slots and sat with her all day at the computer, now we argue who will get the money faster. Cool site design a lot of slots and slot machines32) She came to visit her neighbor and she showed me this site knowingall slots and sat with her all day at the computer, now we argue who will get the money faster. Cool site design a lot of slots and slot machines

    ReplyDelete
  23. Whoa! I’m enjoying the template/theme of this website. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between superb usability and visual appeal. I must say you’ve done a very good job with this.
    aws training in bangalore
    RPA Training in bangalore
    Python Training in bangalore
    Selenium Training in bangalore
    Hadoop Training in bangalore

    ReplyDelete
  24. Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's. 
    rpa training in bangalore
    rpa training in pune
    rpa online training
    best rpa training in bangalore

    ReplyDelete
  25. I was curious if you ever considered changing the layout of your site? Its very well written; I love what you’ve got to say. But maybe you could a little more in the way of content so people could connect with it better. You’ve got an awful lot of text for only having one or 2 pictures. Maybe you could space it out better?
    online Python training
    python training in chennai

    ReplyDelete
  26. Few people know this site rorty play casino games online for real money and I know it will not deceive you for sure. Withdraw money whenever you want, play different gambling and slots Cool site and beautiful design.

    ReplyDelete
  27. And indeed, I’m just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective I’ve had.
    SOFTWARE TRAINING IN CHENNAI
    POWERBI TRAINING IN CHENNAI
    CCNA TRAINING IN CHENNAI

    ReplyDelete
  28. Thank you so much for posting this. I really appreciate your work. Keep it up. Great work!Best Placement company in Hyderabad

    ReplyDelete
  29. Nice blog, good post, informative and helpful post and you are obviously very knowledgeable in this field. Very useful and solid content. Thanks for sharing


    ExcelR Data Science Course in Bangalore

    ReplyDelete
  30. i am for the first time here. I found this board and I in finding It truly helpful & it helped me out a lot. I hope to present something back and help others such as you helped me. i am for the first time here. I found this board and I in finding It truly helpful & it helped me out a lot. I hope to present something back and help others such as you helped me.
    data science course malaysia

    ReplyDelete
  31. Attend The Python training in bangalore From ExcelR. Practical Python training in bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Python training in bangalore.
    python training in bangalore

    ReplyDelete
  32. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!





    Big Data Course Malaysia

    ReplyDelete
  33. I am impressed by the information aws course in Bangalore that you have on this blog. It shows how well you understand this subject.

    ReplyDelete
  34. i Digital Academy ensures that each of you gain maximum knowledge based on current web trends, hence we employ trainers who are working in MNC. Making you ready for job and assisting you to get a job in Angularjs is our priority. Our Angularjs trainer focus on each and every detail to make sure you gain the best knowledge in terms of Angularjs . Your trainers with extensive experience in Angularjs and connections will refer you to companies that are looking for fresh talent after successful web development course completion.

    ReplyDelete
  35. Really very happy to say, your post is very interesting to read. I never stop myself to say something about it. You’re doing a great job. Keep it up…

    Get Best SAP HR HCM Training in Bangalore from Real Time Industry Experts with 100% Placement Assistance in MNC Companies. Book your Free Demo with Softgen Infotech.

    ReplyDelete
  36. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
    data analytics courses malaysia
    certified machine learning courses
    big data analytics malaysia
    data science course


    ReplyDelete
  37. Regular visits listed here are the easiest method to appreciate your energy, which is why why I am going to the website everyday, searching for new, interesting info. Many, thank you!
    artificial intelligence in malaysia
    big data course malaysia
    360DigiTMG

    ReplyDelete
  38. Wow what a Great Information about World Day its exceptionally pleasant educational post. a debt of gratitude is in order for the post.
    artificial intelligence in malaysia
    big data course malaysia
    360DigiTMG

    ReplyDelete
  39. Thanks for sharing such a valuable information...
    AngularJS Training in Bangalore | AngularJS Course Fees | AngularJS 6 - i Digital Academy
    - AngularJS Training in Bangalore - Learn AngularJS 6 from Expert Real-time Trainers at i Digital Academy with Live Projects and Placement Assistance. Book a Free Demo Today.

    ReplyDelete
  40. This comment has been removed by the author.

    ReplyDelete
  41. I am overwhelmed by your post with such a nice topic. Usually I visit your blogs and get updated through the information you include but today’s blog would be the most appreciable. Well done!360DigiTMG artificial intelligence course in malaysia
    360DigiTMG

    ReplyDelete
  42. It's very useful blog post with inforamtive and insightful content and i had good experience with this information.I have gone through CRS Info Solutions Home which really nice. Learn more details About Us of CRS info solutions. Here you can see the Courses CRS Info Solutions full list. Find Student Registration page and register now.Find this real time DevOps Training and great teaching. Join now on Selenium Training online course. Upskill career with Tableau training by crs info solutions. Latest trending course is Salesforce Lightning training with excellent jobs.

    ReplyDelete
  43. This comment has been removed by the author.

    ReplyDelete
  44. This comment has been removed by the author.

    ReplyDelete
  45. This comment has been removed by the author.

    ReplyDelete
  46. This comment has been removed by the author.

    ReplyDelete
  47. You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I'm looking forward for your next post, I’ll try to get the hang of it!
    360DigiTMG PMP Certification
    360DigiTMG PMP Course
    360DigiTMG PMP Course in Malaysia
    360DigiTMG PMP Training in Malaysia
    360DigiTMG PMP Training

    ReplyDelete
  48. After completing an Element, the student takes a computerized (javascript) exam. These multiple-choice questions provide immediate feedback, machine learning and artificial intelligence courses in hyderabad

    ReplyDelete
  49. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    search for more info

    ReplyDelete
  50. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Simple Linear Regression
    Correlation vs covariance
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  51. very well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Logistic Regression explained
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm

    ReplyDelete
  52. The purpose of these insights is to help companies make informed data-driven decisions. data science course syllabus

    ReplyDelete
  53. I was speaking to a friend who is a manager of a team of about twenty people. He told me about one of his team who he knows is bright, and intelligent, but is unmotivated and lacks drive. Salesforce training in Hyderabad

    ReplyDelete
  54. I’m happy I located this blog! From time to time, students want to cognitive the keys of productive literary essays composing. Your first-class knowledge about this good post can become a proper basis for such people. nice one
    data science course in India

    ReplyDelete
  55. Our knowledge is truly enhanced after reading th8is. It was quite useful. We are truly glad that you shared this with us. Here is a referred link same as yours   oracle fusion financials training. While browsing, I came across this one, it's useful and will be providing necessary knowledge too.

    ReplyDelete
  56. As the technology progress the artificial intelligence trained system will provide more services like self-driving cars, self-piloted planes, corporate telephone systems etc. data science course in india

    ReplyDelete
  57. Attend The Data Science Courses Bangalore From ExcelR. Practical Data Science Courses Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Science Courses Bangalore.
    Data Science Courses Bangalore

    ReplyDelete
  58. Sharing the same interest, Infycle feels so happy to share our detailed information about all these courses with you all! Do check them out
    oracle plsql training in chennai & get to know everything you want to about software trainings.

    ReplyDelete
  59. Standard visits recorded here are the simplest strategy to value your vitality, which is the reason why I am heading off to the site regularly, looking for new, fascinating information. Many, bless your heart!
    data science course delhi

    ReplyDelete
  60. Your content is very unique and understandable useful for the readers keep update more article like this.
    data scientist training malaysia

    ReplyDelete
  61. Thanks for posting the best information and the blog is very helpful.Data science course in Faridabad

    ReplyDelete
  62. Train yourself in specific software modules to brush up your skills & shine in your career growth with the best software training institute in Chennai, Infycle Technologies. Infycle offers the Best Data Science Training in Chennai to serve the candidate's job profile requirements, including the top job placements in the MNC's. Rather than just teaching the theories, our fundamental aim is to make you a master by giving you live hands-on training. Therefore, individuals will be asked to work on the live tasks & real-time use cases that bring out the definite coder in you! To grab all these, call 7502633633 for a free demo.

    ReplyDelete
  63. I was exceptionally satisfied to discover this site.I needed to thank you for this extraordinary read!! I certainly getting a charge out of each and every piece of it and I have you bookmarked to look at new stuff you post SEO consultant

    ReplyDelete
  64. Title:
    Big Data Hadoop Training in Chennai | Infycle Technologies

    Description:
    Learn Hadoop Training in Chennai for making your career towards a sky-high with Infycle Technologies. Infycle Technologies offers the best Big Data Hadoop training in Chennai, providing courses for Big Data in 200% hands-on practical training with professional trainers in the domain. Apart from the coaching, the placement interviews will be arranged for the students, so that they can set their career without any struggle. Of all that, 100% placement assurance will be given here. To have the best career, call 7502633633 to Infycle Technologies and grab a free demo to know more.

    Best training in Chennai

    ReplyDelete
  65. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.
    artificial intelligence course aurangabad

    ReplyDelete
  66. Title:
    Best Hadoop Training in Chennai | Infycle Technologies

    Description:
    Study Hadoop for making your career as a shining sun with Infycle Technologies. Infycle Technologies offers the best Hadoop Training in Chennai, providing complete hands-on practical training of professional specialists in the field. In addition to that, it also offers numerous programming language tutors in the software industry such as Oracle, Python, Big Dat, Hadoop, etc. Once after the training, interviews will be arranged for the candidates, so that, they can set their career without any struggle. Of all that, 100% placement assurance will be given here. To have the top career in IT industry, dial 7502633633 to Infycle Technologies and grab a free demo to know more.
    best training institute in chennai

    ReplyDelete
  67. Infycle Technologies, the No.1 software training institute in Chennai offers the No.1 Big Data Hadoop Training in Chennai | Infycle Technologies for students, freshers, and tech professionals. Infycle also offers other professional courses such as DevOps, Artificial Intelligence, Cyber Security, Python, Oracle, Java, Power BI, Selenium Testing, Digital Marketing, Data Science, etc., which will be trained with 200% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7502633633 to get more info and a free demo.

    ReplyDelete

  68. This post is so interactive and informative.keep update more information...
    Graphic Design Courses in Bangalore
    Graphic Design Courses in Pune

    ReplyDelete
  69. Read More About The Latest XM REVIEW Review In This Article. Learn How The Broker Operates And If You Should Avoid Trading With It Or Not.

    ReplyDelete
  70. Thanks for posting the best information and the blog is very good and.data science course in kolkata

    ReplyDelete
  71. Thanks for posting the best information and the blog is very good.data science training in ranchi

    ReplyDelete
  72. Nice blog and informative content. Keep up this awesome work in your further blogs. Thank you. If you want to become a data scientist, then follow the below link.
    Data Science Training in Hyderabad

    ReplyDelete
  73. Nice Post!!! thanks for sharing this information with us.
    Why is DevOps so popular?
    What is DevOps?

    ReplyDelete
  74. You completed certain reliable points there. I did a search on the subject and found nearly all people will agree with your blog.
    data science course in hyderabad

    ReplyDelete
  75. I generally check this kind of article and I found your article which is related to my interest.best vlsi training institutes Genuinely it is good and instructive information. Thankful to you for sharing an article like this.

    ReplyDelete
  76. I truly like your style of blogging. I added it to my preferred's blog webpage list and will return soon… 360digitmg bangalore

    ReplyDelete
  77. Python has a remarkable amount of capability and a relatively simple syntax. It may be extended in C or C++ and offers interfaces for many system calls, libraries, and window systems. To learn more about python, join Python Training in Chennai at FITA Academy.
    Python Training in Chennai
    Python Online Course
    Python Training in Bangalore

    ReplyDelete
  78. Python is an object-oriented, analytic programming language. Classes, dynamically typed, high-level volatile data types, exceptions, modules, and exception management are all included. It supports various programming paradigms, including primary and reactive programming and object-oriented programming. Python Training in Chennai
    Python Online Course
    Python Training in Bangalore

    ReplyDelete
  79. Very interesting to read and learn new things to update myself to career, unique content, requesting to update more things
    jewellery erp software
    Jewellery erp software

    ReplyDelete