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

[siddharthaweb]

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]

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]

Thank you .. it's working now