Wednesday, January 23, 2013

65 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.

65 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

 

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