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:
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?