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

4 visualizaciones (últimos 30 días)
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

Respuestas (1)

Sanchali Purandare
Sanchali Purandare el 16 de En. de 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.

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by