Wednesday, January 23, 2013

68 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: ,

68 comments:

  1. Mathew StephenAugust 27, 2015 at 6:12 AM

    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. Fathima FazalMarch 23, 2016 at 7:04 AM

    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. Nikshitha SJune 23, 2016 at 7:44 AM

    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. Andrew SonAugust 25, 2016 at 3:18 AM

    Fascinating Post. This post makes me to get the required data.
    ccna Training in Chennai | ccna courses in Chennai | ccna institutes in Chennai

    ReplyDelete
  5. Arthur MacAugust 26, 2016 at 6:23 AM

    Great and useful article.Keep sharing more with efficient news like this.
    Hadoop Training in Chennai | Hadoop course in Chennai | Hadoop Training institutes in Chennai

    ReplyDelete
  6. Amirtha raoAugust 28, 2016 at 8:43 AM

    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. Rasool BeviSeptember 15, 2016 at 9:59 AM

    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. Steve HawksOctober 5, 2016 at 4:40 AM

    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. Bay MaxOctober 12, 2016 at 2:51 AM

    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. Anu PriyaNovember 24, 2016 at 12:59 AM

    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
  11. Arjun kumarDecember 1, 2016 at 7:29 AM

    Thanks for taking time to share this post.
    Regards,
    Oracle Training in Chennai | oracle dba training in chennai

    ReplyDelete
  12. kalai haiDecember 7, 2016 at 10:47 PM

    Thanks for sharing this useful article. HP Load Runner Training Institute in Chennai | Best HP Load Runner Training Institute in Chennai

    ReplyDelete
  13. MelisaFebruary 11, 2017 at 8:29 AM

    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
  14. Paul MillerFebruary 13, 2017 at 5:50 AM

    Informative post, It's really useful :)
    Regards,
    Android Training in Chennai|Android Course in Chennai

    ReplyDelete
  15. karumaMarch 2, 2017 at 5:22 AM

    Thanks for posting your wonderful blog..
    Six Sigma Certification Training in Chennai | Six Sigma Green Belt Certification Training in Chennai | Six Sigma Yellow Belt Certification Training in Chennai | Six Sigma Certification Exam Center in Chennai

    ReplyDelete
  16. sivanesanMarch 24, 2017 at 6:05 AM

    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. Rasool BeviApril 17, 2017 at 9:40 AM

    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. Amirtha raoApril 20, 2017 at 10:17 AM


    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. Rasool BeviApril 25, 2017 at 10:30 AM

    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
  20. manjuApril 27, 2017 at 7:44 AM

    Good post. Thank you for sharing... Web Designing Training Institute in Chennai | Web Designing Training Institute in Velachery.

    ReplyDelete
  21. Mathew StephenApril 27, 2017 at 9:48 AM

    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. Vamshi KrishnaApril 28, 2017 at 6:24 AM

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

    ReplyDelete
  23. devoApril 28, 2017 at 8:41 AM

    nice post. Keep updating, Thanks for sharing such a wonderful blog. Software Testing Training Institute in Chennai | Selenium Training Institute in Chennai

    ReplyDelete
  24. navyaApril 29, 2017 at 7:32 AM

    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. Bay MaxMay 8, 2017 at 9:39 AM

    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. Amirtha raoMay 23, 2017 at 10:39 AM

    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. mallikaSeptember 5, 2017 at 7:27 AM

    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. renith harsanOctober 16, 2017 at 9:17 AM

    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
  29. Fuzzy InternationalOctober 30, 2017 at 5:33 AM

    The best thing is that your blog really informative thanks for your great information!
    cashew nuts suppliers and exporters in dubai
    onion suppliers and exporters in dubai
    A4 paper copier suppliers and exporters in dubai
    potato suppliers and exporters in dubai
    spices&grains suppliers and exporters in dubai

    ReplyDelete
  30. Devops Training in BangaloreNovember 13, 2017 at 2:01 AM

    This comment has been removed by the author.

    ReplyDelete
  31. Devops Training in BangaloreNovember 13, 2017 at 2:02 AM

    This comment has been removed by the author.

    ReplyDelete
  32. gopalpadhanNovember 21, 2017 at 6:25 AM

    If you are search any training institute in noida than Webtrackker is the best option for you.
    Salesforce training institute in noida
    Java training institute in noida
    Software Testing Training institute in Noida
    Qtp training institute in noida
    Python Training Institute in Noida
    SEO Training institute in noida
    Amazon Web Services training Institute in Noida

    ReplyDelete
  33. gopalpadhanNovember 21, 2017 at 6:25 AM

    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
  34. Ajay RajNovember 30, 2017 at 11:17 AM

    Vmware Training in Chennai
    CCNA Training in Chennai
    Angularjs Training in Chennai
    Google CLoud Training in Chennai
    Red Hat Training in Chennai
    Linux Training in Chennai
    Rhce Training in Chennai

    ReplyDelete
  35. Aswin KarthickDecember 2, 2017 at 7:28 AM

    thank you java training in chennai
    struts training in chennai
    core java training in chennai

    ReplyDelete
  36. Adlina JessiDecember 23, 2017 at 12:35 AM

    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. srihariparuDecember 23, 2017 at 8:56 AM

    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. JamesWilliamJanuary 27, 2018 at 1:58 AM

    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
  39. roja sunFebruary 1, 2018 at 4:41 AM

    Thanks for posting your interesting article..keep updating..
    No.1 VLSI Project Center in Chennai | No.1 VLSI Project Center in Velachery

    ReplyDelete
  40. Nisha PremrahulFebruary 1, 2018 at 5:28 AM

    Nice informative blog. Most of them encounter this problem. Thanks for sharing.
    BE/B.Tech Project Center in Chennai | ME/M.Tech Project Center in Chennai | Final Year Project Center in Chennai

    ReplyDelete
  41. chandhuFebruary 1, 2018 at 7:52 AM

    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. john kevinFebruary 3, 2018 at 3:19 AM

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

    sas training in bangalore

    ReplyDelete
  43. Renith HarsanFebruary 13, 2018 at 1:38 AM

    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
  44. Vinoth KumarFebruary 15, 2018 at 5:01 AM

    Good Post..Thanks for sharing such a wonderful article....


    PLC Training in Chennai | PLC Training Institute in Chennai | PLC Training Center in Chennai | PLC SCADA Training in Chennai | PLC SCADA DCS Training in Chennai | Best PLC Training in Chennai | Best PLC Training Institute in Chennai | PLC Training Centre in Chennai | Automation Training in Chennai | Automation Training Institute in Chennai

    ReplyDelete
  45. Wiztech Automation Solutions Pvt., Ltd.,February 15, 2018 at 7:33 AM

    Excellent post.Keep sharing.


    PLC Training in Chennai | PLC Training Institute in Chennai | PLC Training Center in Chennai | PLC SCADA Training in Chennai | PLC SCADA DCS Training in Chennai | Best PLC Training in Chennai | Best PLC Training Institute in Chennai | PLC Training Centre in Chennai

    ReplyDelete
  46. srihariparuFebruary 16, 2018 at 6:02 AM

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

    ReplyDelete
  47. srihariparuFebruary 16, 2018 at 6:02 AM

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


    Robotics Project Center in Chennai | Best Robotics Projects in Chennai | IEEE Robotics Project Center in Chennai | No.1 Robotics Project Center in Velachery

    ReplyDelete
  48. Ruban kFebruary 16, 2018 at 6:08 AM

    Worth every sleepless days. It was a real challenge for me and I've learnt a lot.


    Graphic Designing Training Institute in Chennai | Photoshop Training Institute in Chennai | CorelDraw Training Institute in Chennai

    ReplyDelete
  49. dharu dhariFebruary 16, 2018 at 6:21 AM

    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
  50. roja sunFebruary 17, 2018 at 4:06 AM

    You are shared useful post..Thanks for sharing..
    No.1 Electrical Project Center in Chennai | Electrical Project Center in Velachery

    ReplyDelete
  51. devoMarch 20, 2018 at 5:43 AM

    Great information. I have got some important suggestions from it. Thank you for sharing.
    Best Microsoft Azure Training Institute in Chennai | Best Microsoft Azure Training Institute in Velachery

    ReplyDelete
  52. shabaz rMarch 28, 2018 at 9:59 AM

    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. JamesWilliamApril 10, 2018 at 6:00 AM

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

    ReplyDelete
  54. ranasing rajkumarApril 20, 2018 at 3:07 AM

    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
  55. Nicholas deApril 27, 2018 at 1:30 AM

    Good post. Thank you for sharing..

    Oracle Weblogic Server Training

    ReplyDelete
  56. Billy JhonsonMay 1, 2018 at 8:37 AM

    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. ajayMay 2, 2018 at 4:00 AM

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

    ReplyDelete
  58. deepika ranjithMay 25, 2018 at 6:55 AM

    Keep sharing such type of useful information

    Linux Admin Training in Chennai

    ReplyDelete
  59. deeptiMay 27, 2018 at 6:59 AM

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

    ReplyDelete
  60. Nisha PremrahulJune 9, 2018 at 8:49 AM

    Good post..
    VMware Exam Centers in Chennai | VMware Exam Centers in Velachery

    ReplyDelete
  61. Lathika HoneyJuly 13, 2018 at 7:27 AM

    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
  62. Sphinax info systemsJuly 18, 2018 at 1:00 AM

    Nice Blog. Thank you for sharing.
    ERP in Chennai
    ERP Providers in Chennai
    ERP Software in Chennai
    ERP Software Development Company in Chennai

    ReplyDelete
  63. Manasa mittalJuly 19, 2018 at 6:42 AM

    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
  64. svr online TrainingJuly 31, 2018 at 7:00 AM

    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
  65. TechiemillsSeptember 20, 2018 at 6:58 AM

    Nice post keep do posting The Info was too good
    Devops ONline Training
    IT training instiutute
    Thanks for sharing the information

    ReplyDelete
  66. Shivani YuvanjalinNovember 16, 2018 at 1:33 AM

    Nice Post. Thank you for sharing.
    Payroll Software
    Leave Management Software
    HR Payroll Software
    Attendance Management System
    HR Management Software

    ReplyDelete
  67. NagaJanuary 4, 2019 at 6:53 AM

    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

Subscribe to: Post Comments (Atom)
 

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