oracle/python-cx_Oracle

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

siddharthaweb opened this issue · 2 comments

siddharthaweb commented

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

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

Thank you .. it's working now