Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

 
Adnan Gondal
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yesterday i was using oracle 9.1 with ojdbc 14 jdbc driver with following code for adding employee, it was working fine but now i am using oracle 10.1.0.2.0 with ojdbc14 but now it is giving following error

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor error

Following is code for adding employee

 
Bijesh Roy
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
did you check if classes12.jar exists in the classpath or not?
 
Bijesh Roy
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Also is the SID is same for Oracle 9 and Oracle 10 database that you are connecting or they are different? This error might be generating due to oracle SID name mismatch and may not be a driver or ojdbc issue.
 
rahul khan
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
solution

this helped me.. check out.. hope it will help you also.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic