oracle database problems

[omar bili]

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]

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]

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