Wednesday, January 23, 2013

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

Posted by Po@sqlpanda at 1:03 AM
Labels: ,

57 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

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

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

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

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

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

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

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

    ReplyDelete

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


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

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

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

  22. very useful information about SQL Server........

    ReplyDelete

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

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

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

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

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

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

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

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

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

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

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

    sas training in bangalore

    ReplyDelete

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

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

    ReplyDelete

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

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

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

    ReplyDelete

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

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

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

    ReplyDelete

Subscribe to: Post Comments (Atom)
 

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