This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
Similar Threads
Searching problem
Strange behaviour of ResultSet next method
JSF database interaction
How to use INSERT INTO ALL statement in jdbc prepared statement with beans
A Very little problem in h:dataTable implementation