You should ensure the connection string does not have any reserved/escape characters in it. People have had similar issues in the past. If that is the case, there are some recent threads in this group and on the github issues that show how to overcome the issue by building a connection string from components.
Other than that, this could be an Oracle configuration issue? (see http://dba-oracle.com/t_ora_12514_tns_listener_does_not_currently_know_service_requested.htm) Is production configured correctly? On Wednesday, August 4, 2021 at 7:52:42 PM UTC-4 jca...@gmail.com wrote: > I am using sqlalchemy 1.4.22 and cx oracle 8.2.1 to connect to production > and development environments that each host a similar copy of the same > schema. > > The connection string that I use is the same for each excluding the > password: > > oracle+cx_oracle://user:pass@MyTNS > > Dev works without a problem, but prod throws an Oracle error: > > ORA-12514: TNS:listener does not currently know of service requested in > connect descriptor > > We can connect using sqlplus with the same credentials and tns id, any > idea why it may not work for one environment? > > Thanks, > jlc > > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/add2ce16-1470-4b0b-a561-f9549ef4ef48n%40googlegroups.com.