wood burning stoves 2.0*
The moose likes JDBC and the fly likes ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" Watch "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" New topic
Author

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

Adnan Gondal
Ranch Hand

Joined: Apr 30, 2011
Posts: 32
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

Joined: Jun 28, 2011
Posts: 8
did you check if classes12.jar exists in the classpath or not?
Bijesh Roy
Greenhorn

Joined: Jun 28, 2011
Posts: 8
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor