File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 1141

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
jQuery in Action, 3rd edition