Why do I get an error about SID when connecting to my Oracle database using Database Toolbox 3.7 (R2010a)?

I am working on a Windows 64-bit machine with 64-bit MATLAB. I am trying to use the JDBC driver to connect to Oracle database that needs a SID. When I try connecting as:

conn= database('datasource','my_user','my_pass','oracle.jdbc.driver.OracleDriver',...     'jdbc:oracle:thin:@709.9224.322220.2222270:1521:datasid')

I get the following error:

>> conn.message  ans =  Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 709.9224.322220.2222270:1521:datasid

Answer 1

[Sanchali Purandare]

Try determining the correct SID for using JDBC. With reference to the URL:

http://www.dbmotive.com/oracle_error_codes.php?errcode=12505

Confirm the SID with your database administrator who has access to tnsnames.ora file. You may change it to something else and see what happens.