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.
Joined: Aug 13, 2004
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