About Me

My photo
Pune, Maharashtra, India
Working on Oracle technology for more than 14+ years.Oracle Certified professional. Expertise in Oracle advance technologies like Oracle Real Application Cluster (RAC) , Oracle DataGuard, Oracle ASM, Oracle Golden gate. Experience in Area of migration/Replication of Oracle Database. Expertise in Storage/OS administration,Vertulization, Cloud technology. Activly involed in forum discussion of RAC sig and DBA village.

Thursday, November 22, 2012

Difference between Oracle Single instance and Oracle RAC


Single  InstanceOracle RAC
Single instance accessing databaseMultiple instances accessing same database
Database can be local or sharedDatabase must be on shared.
Minimum one node is RequiredMinimum two node required
Clusterware software is not requiredClusterware Software is required.
Consists of one SGA and one set of background  processesEach instance having own  one SGA and one set of background  processes
One set of redo logsMultiple set redo logs depending on number of instances
No Cache fusion used un Single instanceCache fusion is used to transfer or access block from remote instance
V$ views to monitor and manage instanceFor monitoring at the cluster level Oracle provides GV$ views.
Meeting some of the business requirements (availability, scalability) is limited to a single instance configuration.Modern business requirements of high availability and linear scalability are provided by multiple instances sharing a common physical database





67 comments:

  1. Hello Anand,
    What is the basic difference in the profile of Oracle DBA and Oracle RAC. Is this Oracle RAC professional only can works on multiple instance of server or something else which is out of scope for oracle DBA .

    ReplyDelete
  2. It was really a wonderful article and I was really impressed by reading this blog. Your technical information is very useful for me. Thanks for sharing your ideas.

    Regards...
    Hacking Course in Chennai

    ReplyDelete
  3. hi friend send to me address

    ReplyDelete
  4. Hi,easy way to understand the article so, i would like to share your blog to my circles for getting awesome knowledge, keep your blog as updated.oracle dba training

    ReplyDelete
  5. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    mean-stack-training-institute-in-chennai

    ReplyDelete
  6. Hello. This post couldn’t be written any better! Reading this post reminds me of my previous roommate. He always kept chatting about this. I will forward this page to him. Fairly certain he will have a good read. Thank you for sharing.
    MEAN stack training in Chennai
    MEAN stack training in bangalore

    ReplyDelete
  7. We are a group of volunteers and starting a new initiative in a community. Your blog provided us valuable information to work on.You have done a marvellous job!

    python training in chennai | python training in bangalore

    python online training | python training in pune

    python training in chennai

    ReplyDelete
  8. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    Devops Training in pune

    Devops Training in Chennai

    Devops Training in Bangalore

    AWS Training in chennai

    AWS Training in bangalore

    ReplyDelete
  9. 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 training in Chennai | rpa training in pune

    rpa training in tambaram | rpa training in sholinganallur

    rpa training in Chennai | rpa training in velachery

    rpa online training | rpa training in bangalore

    ReplyDelete
  10. I have never read more interesting articles than yours before. You make me so easy to understand and I will continue to share this site. Thank you very much and more power!
    Selenium Course in Chennai
    Selenium Training in Chennai
    Java Courses in Chennai
    core Java training in chennai
    ios developer course in chennai
    ios classes in chennai
    iOS Training Institutes in Adyar

    ReplyDelete
  11. Hey there! I know this is kind of off-topic, but I’d figured I’d ask. Would you be interested in exchanging links
    nebosh igc courses in chennai

    ReplyDelete
  12. Thank you for this great article which conveyed a good information.keep more updates
    Devops Training in Chennai | Devops Training Institute in Chennai

    ReplyDelete
  13. This is a nice post in an interesting line of content.Thanks for sharing this article, great way of bring this topic to discussion.
    devops online training

    aws online training

    data science with python online training

    data science online training

    rpa online training

    ReplyDelete
  14. Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which I need, thanks to offer such a helpful information here.
    Microsoft Azure online training
    Selenium online training
    Java online training
    uipath online training
    Python online training

    ReplyDelete
  15. 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.
    data analytics certification courses in Bangalore
    ExcelR Data science courses in Bangalore

    ReplyDelete
  16. 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.

    ReplyDelete
  17. I was just browsing through the internet looking for some information 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. Bookmarked this page, will come back for more.
    data science course in singapore

    ReplyDelete
  18. I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.
    www.technewworld.in
    How to Start A blog 2019
    Eid AL ADHA

    ReplyDelete
  19. Really appreciate this wonderful post that you have provided for us.Great site and a great topic as well i really get amazed to read this. Its really good.
    I like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. I truly adored reading your posting. Thank you!
    Data Science Courses

    ReplyDelete
  20. Just saying thanks will not just be sufficient, for the fantasti c lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates.
    pmp certification malaysia

    ReplyDelete
  21. I love the way you write Business Analytics Online Course and share your niche! Very interesting and different! Keep it coming!

    ReplyDelete
  22. 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!
    data analytics course hyderabad

    ReplyDelete
  23. This is really very nice post you shared, i like the post, thanks for sharing..
    Please check ExcelR Data Science Course in Pune

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

    ReplyDelete
  25. I need to to thank you for this very good read!! I definitely loved every little bit of it. I have you bookmarked to check out new things you post… data science course bangalore

    ReplyDelete
  26. 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.… data science courses

    ReplyDelete
  27. This post is very simple to read and appreciate without leaving any details out. Great work! data science courses

    ReplyDelete
  28. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
    data science course in mumbai

    ReplyDelete
  29. I have a mission that I’m just now working on, and I have been at the look out for such information ExcelR Data Scientist Classes In Pune

    ReplyDelete
  30. Thank you for sharing such a nice and interesting blog with us regarding Java. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information. I would like to suggest your blog in my dude circle.
    Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

    ReplyDelete
  31. Great post! I am actually getting ready to across this information, It's very helpful for this blog. oracle training in chennai

    ReplyDelete
  32. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article. thank you for sharing such a great blog with us.

    RAC Training in Bangalore

    ReplyDelete

  33. ExcelR provides Data analyst course. It is a great platform for those who want to learn and become a Data Analyst. Students are tutored by professionals who have a degree in a particular topic. It is a great opportunity to learn and grow.

    Data analyst course

    ReplyDelete
  34. Wonderful blog. I delighted in perusing your articles. This is genuinely an incredible perused for me. I have bookmarked it and I am anticipating perusing new articles. Keep doing awesome!
    data scientist training in hyderabad

    ReplyDelete
  35. This is really very nice post you shared, i like the post, thanks for sharing..
    data science training in malaysia

    ReplyDelete
  36. Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post.
    data scientist course in malaysia

    ReplyDelete
  37. I really enjoyed reading this post, big fan. Keep up the good work and please tell me when can you publish more articles or where can I read more on the subject?
    business analytics course in hyderabad

    ReplyDelete
  38. The blog post effectively highlights Difference between Oracle Single instance and Oracle RAC thanks for sharing informative blog.
    Digital Marketing Courses in Italy

    ReplyDelete
  39. Diving deep into the oracle universe - where cutting-edge technology and limitless possibilities converge. Embracing the power of Oracle for a future defined by innovation and seamless tech experiences!
    a href=https://iimskills.com/digital-marketing-courses-in-dublin/> Digital Marketing Courses In Dublin

    ReplyDelete
  40. Diving deep into the oracle universe - where cutting-edge technology and limitless possibilities converge. Embracing the power of Oracle for a future defined by innovation and seamless tech experiences!
    Digital Marketing Courses In Dublin

    ReplyDelete
  41. Diving deep into the oracle universe - where cutting-edge technology and limitless possibilities converge. Embracing the power of Oracle for a future defined by innovation and seamless tech experiences!
    Obtaining a digital marketing certification holds significant worth in today's rapidly evolving business landscape.
    Digital marketing certification worth

    ReplyDelete
  42. "Fantastic article! It’s great to see the growing availability of data science courses in Kochi. As the demand for data scientists continues to rise, the courses offered in this city provide an excellent opportunity to develop the skills needed for this thriving industry. From machine learning to data visualization, these courses cover all the essential aspects of data science. If you’re considering a career in this field or looking to enhance your current skills, I definitely recommend exploring the Data science courses in Kochi for more information. The hands-on training and real-world applications make them a valuable investment for anyone looking to excel in data science."

    ReplyDelete
  43. "Great job on this post! Your effort really shows!"
    Data science course in mumbai.

    ReplyDelete
  44. I find your blog to be a reliable and enriching resource, always providing a thoughtful examination of the topics discussed
    Data science Courses in London

    ReplyDelete
  45. "Great explanation of the differences between Oracle Single and Multi-Tenant architecture! This is really helpful for understanding the advantages of each approach. Thanks for sharing!"
    Data science Courses in Canada

    ReplyDelete
  46. This post does a great job of explaining the difference between single-row and multi-row fetch in Oracle. Understanding these concepts is essential for optimizing queries and improving performance. Thanks for simplifying these technical details in a way that’s easy to grasp!

    Data science courses in Glasgow

    ReplyDelete