search

oracle / python-cx_Oracle

Python interface to Oracle Database now superseded by python-oracledb
https://oracle.github.io/python-cx_Oracle
Other
890 stars 361 forks source link

cx_Oracle.DatabaseError: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor #647

Closed siddharthaweb closed 1 year ago

siddharthaweb commented 1 year ago

I am unable to connect Oracle server from my local, due to this error. Kindly help cx_Oracle.DatabaseError: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

Here are the details of the associated modules and oporating system.

Oracle DB details NLSRTL 12.2.0.1.0 Oracle Database 12c Standard Edition 12.2.0.1.0 PL/SQL 12.2.0.1.0 TNS for Linux: 12.2.0.1.0

Python 3.10.5

instantclient_19_17 Microsoft Visual C++ 2015-2022 Redistributable - VC_redist.x64.exe Name: cx-Oracle (Version: 8.3.0) Oporating System : Windows 11

cjbj commented 1 year ago

What's the code you are using? If you are using makedsn() then use the service_name parameter, see https://cx-oracle.readthedocs.io/en/latest/user_guide/connection_handling.html#oracle-net-connect-descriptor-strings

Also see https://www.thatjeffsmith.com/archive/2014/09/ora-12545-12541-12514-01017/ for some background info.

siddharthaweb commented 1 year ago

Thank you .. it's working now