MATLAB Answers

0

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

Asked by Sanchali Purandare on 16 Jan 2011
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

  0 Comments

Sign in to comment.

1 Answer

Answer by Sanchali Purandare on 16 Jan 2011

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.

  0 Comments

Sign in to comment.