wood burning stoves 2.0*
The moose likes JDBC 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
Bookmark "oracle database problems" Watch "oracle database problems" New topic
Author

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:@192.168.0.28:1521 RA9iTST";
String user = "stage";
String pass = "stage";

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

please help.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1134

Omar,
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,
Avi.
omar bili
Ranch Hand

Joined: Aug 13, 2004
Posts: 177
Avi, you were right
i changed the dbURL to
dbUrl = "jdbc racle:thin:@192.168.0.28:1521 RA9i";
and it is now working fine.
thanks for ur time
Omar
 
 
subject: oracle database problems