This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes oracle database problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "oracle database problems" Watch "oracle database problems" New topic

oracle database problems

omar bili
Ranch Hand

Joined: Aug 13, 2004
Posts: 177
Hi, i was trying to connect to an Oracle database
but the exception occurs, this is the exception:

Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

my code is:
PreparedStatement selectStmt = null;
PreparedStatement updateOrInsertStmt = null;
String driver = "oracle.jdbc.driver.OracleDriver";
String dbUrl = "jdbc racle:thin:@ RA9iTST";
String user = "stage";
String pass = "stage";

connection = DriverManager.getConnection(dbUrl, user, pass); /*the exception is happening in this line */

please help.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1138

For your information, here are some details regarding the error you are getting:

12505, 00000, "TNS:listener could not resolve SID given in connect descriptor"
// *Cause: The SID in the CONNECT_DATA was not found in the listener's tables.
// *Action: Check to make sure that the SID specified is correct.
// The SIDs that are currently registered with the listener can be obtained by
// typing "LSNRCTL SERVICES <listener name>". These SIDs correspond to
// SID_NAMEs in TNSNAMES.ORA, or db_names in INIT.ORA.
// *Comment: This error will be returned if the database instance has not
// registered with the listener; the instance may need to be started.

Good Luck,
omar bili
Ranch Hand

Joined: Aug 13, 2004
Posts: 177
Avi, you were right
i changed the dbURL to
dbUrl = "jdbc racle:thin:@ RA9i";
and it is now working fine.
thanks for ur time
I agree. Here's the link:
subject: oracle database problems
It's not a secret anymore!