python-oracledb thin client returns DPY-6005
Connection to ATP 21c and ADP 19c (free tier, both TLS enabled) using Python thin client fails with DPY-6005!
I'm trying to connect to a 21c ATP and 19c ADP (ACL enabled/configured with "My Address", mTLS set to "Not required", connection string contains "ssl_server_dn_match=yes") using Python's thin client but at the point of making a connection or setting up a connection pool, I get:
OperationalError: DPY-6005: cannot connect to database. Connection failed with "[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1131)"
I've used the following documents as a reference: