Wednesday, January 23, 2013

116 Oracle SQL Developer fail to connect to RAC SCAN with ORA 12505 error

When I try to connect to my Oracle RAC test environment via SCAN name with SQL Developer, I got the error “ORA-12505, TNS:listener does not currently know of SID given in connect descriptor” .

RAC1 is my ORACLE_SID name. SQL Developer version is 3.2

 

image

If I use the same string connect from SQLplus, it works fine as screenshot below:

image

After googling, I found the solution in SQL Developer by using the JDBC connection string:

jdbc:oracle:thin:@rac-scan:1521/RAC1 

 

image

Not sure why the SQL developer behavior this way, but at least I have the solution. I will update the post if I found more information.

116 comments:

  1. There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.


    Oracle Course in Chennai
    Oracle Training in Chennai

    ReplyDelete
  2. I am following your blog from the beginning, it was so distinct & I had a chance to collect conglomeration of information that helps me a lot to improvise myself. I hope this will help many readers who are in need of this vital piece of information. Thanks for sharing & keep your blog updated.
    Regards,
    CCNA Training in Chennai | CCNA Training institute in Chennai | CCNA Training

    ReplyDelete
  3. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    SAS Training in Chennai | SAS Course in Chennai

    ReplyDelete
  4. I feel satisfied with your blog, you have been delivering useful & unique information to our vision even you have explained the concept as deep clean without having any uncertainty, keep blogging.
    Best Hadoop Training in Chennai|Best hadoop training institute in chennai

    ReplyDelete
  5. I really enjoyed while reading your article, the information you have delivered in this post was damn good. Keep sharing your post with efficient news.
    Regards,
    cloud computing training chennai|cloud computing training

    ReplyDelete
  6. Big Data is just a thought which empowers dealing with a generous measure of data sets. Hadoop has been just a singular structure out of numerous instruments. Hadoop is on a very basic level used for bunch to get ready.
    Regards,
    Hadoop Training in Chennai | Hadoop course in Chennai | Hadoop Training institutes in Chennai

    ReplyDelete
  7. Thankful to you for requiring noteworthy venture to give us a part of the accommodating and select information with us.
    ccna Training in Chennai | ccna institutes in Velachery | ccna Training institutes in Velachery

    ReplyDelete
  8. Thanks for sharing this informative blog. I have read your blog and I gathered some valuable information from this blog. Keep posting.
    Regards,
    Networking Training | Cisco CCNA Training

    ReplyDelete
  9. I agree with your thoughts!!! As the demand of java programming application keeps on increasing, there is massive demand for java professionals in software development industries. Thus, taking training will assist students to be skilled java developers in leading MNCs.Best Java Training in Chennai | JAVATraining Institutes in Chennai

    ReplyDelete
  10. Nice blog. Thank you for sharing. The information you shared is very effective for learners. erp in chennai | erp for automotive industry chennai

    ReplyDelete
  11. The expansion of internet and intelligence in business process lead the way to huge volume of data. It is important to maintain and process these data to be efficient in data handling. Hadoop Training in Chennai | Big Data Training in Chennai

    ReplyDelete

  12. Excellent post, now a day’s huge demand for the certified java professionals in IT industry. Java gives more career opportunity for the fresher’s as well as experienced experts.
    Regards,
    JAVA Training in Chennai|JAVA Course in Chennai

    ReplyDelete
  13. Thanks for sharing informative article on web design and development. As every business is moving towards online marketing, there is huge demand for trained and skilled web designers and developers. Web designing Training in Chennai

    ReplyDelete
  14. Thanks for sharing informative article!!! Your article helped me a lot to understand the importance of PHP Training in Chennai to secure lucrative job in web design and development industry.

    ReplyDelete
  15. very useful information about SQL Server........

    ReplyDelete
  16. Thank you for this valuable information. I have got some important suggestions from it. Embedded Training Institute in Chennai | Embedded Training Institute in Velachery.

    ReplyDelete
  17. Your website is totally awesome and loaded with various informative posts on web design and development. Keep on updating your blog. Web Design Training | Web designing course in Chennai

    ReplyDelete
  18. Thanks for sharing such informative guide on .Net technology. This post gives me detailed information about the .net technology. I am working as trainer in leading IT training academy offering Dot Net Training in Chennai and i use your guide to educate my students. .Net Training in Chennai

    ReplyDelete
  19. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great Information...Java Training Institute in Chennai | Java Training Institute in Velachery.

    ReplyDelete
  20. I and my friends were going through the nice, helpful tips from the
    blog then the sudden came up with an awful suspicion I never
    expressed respect to the website owner for those secrets."Devops Training in Chennai"

    ReplyDelete
  21. Sap Training Institute in Noida-Webtrackker is the best SAP training institute in noida. SAP is drastically a completely state-of-the-art element ever to analyze and to excel in it. However with the ever-growing price, and being the most accessible organization solution key, agencies are greater involved to have their employees specialized in it. The education courses effectively deliver you with the fundamental recognition of SAP, in a grade by grade way.
    Sas Training Institute in Noida
    PHP Training Institute in Noida
    Hadoop Training Institute in Noida
    Oracle Training Institute in Noida
    Linux Training Institute in Noida
    Dot net Training Institute in Noida

    ReplyDelete
  22. This blog explain everything in detail manner and it was very interesting to read. Thank you for sharing such a nice blog.. Software Testing Training Institute in Chennai | Selenium Training Institute in Chennai | ISTQB Training Institute in Chennai

    ReplyDelete
  23. Nice blog. you increase the tone vlaue of the blog. Thanks for sharing this kind of blog.
    Robotics Project Center in Chennai | Robotics Project Center in Velachery

    ReplyDelete
  24. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging...
    PHP developers in chennai | PHP developers in India

    ReplyDelete
  25. The best thing is that your blog really informative thanks for your great information..IEEE Projects Center in Chennai | IEEE Projects Center in Velachery

    ReplyDelete
  26. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    sas training in bangalore

    ReplyDelete
  27. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.selenium training in bangalore

    ReplyDelete
  28. Awesome Blog, you have provided the right information that will be beneficial to us.keep updating..

    ReplyDelete
  29. I read your post from the most punctual beginning stage, it was so interesting..Mat Lab Projects Center in Chennai | Mat Lab Projects Center in Velachery

    ReplyDelete
  30. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging...
    mobile website builder

    ReplyDelete
  31. Thanks for sharing this niche useful informative post to our knowledge.
    brochure designers in chennai | brochure design company in chennai

    ReplyDelete
  32. Thanks a lot very much for the high quality and results-oriented help.
    I won’t think twice to endorse your blog post to anybody who wants
    and needs support about this area.

    white label website builder

    ReplyDelete
  33. Great job!!! We really appreciate your aspirations and efforts to make ur dreams true. If all of us start thinking about our nation and our people before thinking about ourselves, our country would be leading whole world...
    pest control
    cctv camera
    termite control
    PC Optimization
    windows Installation
    Data Recovery

    ReplyDelete
  34. Nice Blog..I have read your article,its really amazing..Thanks for sharing..Summer Courses in Chennai | Summer Courses in Velachery

    ReplyDelete
  35. Great article, really very helpful content you made. Thank you, keep sharing.Java Summer Courses in Chennai | Summer Courses in Chennai

    ReplyDelete
  36. This Blog Provides Very Useful and Important Information. I just Want to share this blog with my friends and family members. United States Medical Licensing Examination

    ReplyDelete
  37. Great blog.you put Good stuff.All the topics were explained briefly.so quickly understand for me.I am waiting for your next fantastic blog.Thanks for sharing.



    Full Stack Training in Hyderabad

    ReplyDelete
  38. It is really helpful !An opportunity to read a fantastic and imaginary blogs.It gives me lots of pleasure and interest.
    sap abap online courses

    ReplyDelete
  39. Great and useful article.This post makes me to get the required data.The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.

    Hardware and Networking Courses

    ReplyDelete
  40. Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
    Devops Training in Chennai | Devops Training Institute in Chennai

    ReplyDelete
  41. Just found your post by searching on the Google, I am Impressed and Learned Lot of new thing from your post. I am new to blogging and always try to learn new skill as I believe that blogging is the full time job for learning new things day by day.

    Best Spring Classroom Training Institute
    Best Devops Classroom Training Institute
    Best Corejava Classroom Training Institute
    Best Advanced Classroom Training Institute
    Best Hadoop Training Institute

    ReplyDelete
  42. This blog is very much helpful to us. Thanks for your information

    Guest posting sites
    Education

    ReplyDelete
  43. A bewildering web journal I visit this blog, it's unfathomably heavenly. Oddly, in this present blog's substance made purpose of actuality and reasonable. The substance of data is informative
    Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training

    ReplyDelete
  44. Awesome post. Really you are shared very informative concept... Thank you for sharing. Keep on updating...

    Best Graphics Designing Training Academy in Kanchipuram

    ReplyDelete
  45. Thanks for sharing this niche useful informative post to our knowledge...
    Best java Training Academy in Kanchipuram

    ReplyDelete
  46. This information is very useful and innovative..I gained more knowledge from this.Thanks for the nice information its very useful to read your blog...
    Best web designing Training Institute in in Kanchipuram

    ReplyDelete
  47. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site
    Best dotnet Training Institute in Kanchipuram

    ReplyDelete
  48. thank you for such a great article with us. hope it will be much useful for us. please keep on updating..
    Best software testing Training Institute in Kanchipuram

    ReplyDelete
  49. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us.
    Best dally erp 9 Training Institute in Kanchipuram

    ReplyDelete
  50. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.
    Best web designing Training Institute in Kanchipuram

    ReplyDelete
  51. An overwhelming web journal I visit this blog, it's unfathomably amazing. Unusually, in this present blog's substance made inspiration driving truth and reasonable. The substance of data is enlightening
    Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training

    ReplyDelete
  52. Wonderful article.It is to define the concepts very well.Clearly explain the information.It has more valuable information for encourage me to achieve my career goal.
    Best JAVA and J2EE Training Institute in Kanchipuram

    ReplyDelete
  53. Wow!! What a interesting blog..Thanks The information which you provided is very much useful and easy to learn as well...keep rocking and updating... looking further..
    Best CCNA Training Institute in Kanchipuram

    ReplyDelete
  54. Nice post. I study something more challenging on completely different blogs everyday.
    Best JAVA and J2EE Course Training Institute in kanchipuram|

    ReplyDelete
  55. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  56. 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.
    Best Python Course Training Institute in kanchipuram|

    ReplyDelete
  57. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    Best Advanced Amazon Web Services Course Training Institute in kanchipuram|

    ReplyDelete
  58. Very Good Blog. Highly valuable information have been shared. Highly useful blog..Great information has been shared. We expect many more blogs from the author. Special thanks for sharing..
    SAP Training in Chennai | AWS Training in Chennai | Android Training in Chennai | Selenium Training in Chennai | Networking Training in Chennai

    ReplyDelete
  59. I would like to thank you for your nicely written post, its informative and your writing style encouraged me to read it till end. Thanks
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  60. Excellent Blog very imperative good content, this blog is useful to beginners.
    Best Selenium Automation Course Training Institute in kanchipuram|

    ReplyDelete
  61. This blog is great.This information is very useful for me.Thanks for sharing your Ideas.Keep updating.Regards,
    Best Hardware and Networking Course Training Institute in kanchipuram|

    ReplyDelete
  62. I think this is an informative post and it is very useful and knowledgeable. I really enjoyed reading this post. thank you!
    Best Python Course Training Institute in kanchipuram|

    ReplyDelete
  63. Thank you so much for sharing. Keep updating your blog. It will very useful to the many users.
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  64. REALLY VERY EXCELLENT INFORMATION. I AM VERY GLAD TO SEE YOUR BLOG FOR THIS INFORMATION. THANKS FOR SHARING. KEEP UPDATING.
    Best Hardware and Networking Course Training Institute in kanchipuram|

    ReplyDelete
  65. This post was quite awesome and interesting to read. Congrats for your work. Thanks a lot for providing this with us. Keep on updating this with us regularly:
    Best Selenium Automation Course Training Institute in kanchipuram|

    ReplyDelete
  66. The best thing is that your blog really informative thanks for your great information
    Best tally erp 9 Course Training Institute in kanchipuram|

    ReplyDelete
  67. Awesome Blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog...
    Best Linux Certification Course Training Institute in kanchipuram|

    ReplyDelete
  68. Great post.Thanks for one marvelous posting! I enjoyed reading it;The information was very useful.Keep the good work going on!!
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  69. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Best UIPath Robotic Process Automation Course Training Institute in kanchipuram|

    ReplyDelete
  70. Nice and good blog. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating....No:1 Selenium Automation Training Academy in Kanchipuram

    ReplyDelete
  71. The information you have here is really useful to make my knowledge good. It is truly supportive for us and I have accumulated some essential data from this blog.
    Best JAVA and J2EE Course Training Institute in kanchipuram|

    ReplyDelete
  72. Your Blog is really awesome with helpful post..keep updating such an excellent post with us..
    Best CCNA Course Training Institute in kanchipuram|

    ReplyDelete
  73. This is really a great post. Thank you for taking time to provide us some of the useful and exclusive information with us. Keep on blogging!!
    Best CCNA Course Training Institute in kanchipuram|

    ReplyDelete
  74. Great blog.you put Good stuff.All the topics were explained briefly.so quickly understand for me.I am waiting for your next fantastic blog.Thanks for sharing.
    Best Tally erp9 Course Training Institute in kanchipuram|

    ReplyDelete
  75. Nice..You have clearly explained about it ...Its very useful for me to know about new things..Keep on blogging..
    Best JAVA and J2EE Course Training Institute in kanchipuram|

    ReplyDelete
  76. Hi, am a big follower of your blog. 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.
    Best CCNA Course Training Institute in kanchipuram|

    ReplyDelete
  77. Great post.Thanks for one marvelous posting! I enjoyed reading it;The information was very useful.
    Best Best Web Designing and Development Course Training Institute in kanchipuram|

    ReplyDelete
  78. great doing. and i happy to visit your blog to know about this wonderful information. thanks for sharing. keep updating.
    Best Best Web Designing and Development Course Training Institute in kanchipuram|

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates