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

1 次查看（过去 30 天）
Sanchali Purandare
Sanchali Purandare 2011-1-16
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

请先登录，再回答此问题。

回答（1 个）

Sanchali Purandare
Sanchali Purandare 2011-1-16
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.

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by