ADB: Connectivity From Python3 cx_oracle To ADB Fails With Error "ORA-29003: SSL transport detected mismatched server certificate"
(Doc ID 2900161.1)
Last updated on OCTOBER 11, 2022
Applies to:
Autonomous Database on Shared Infrastructure - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Connectivity From Python3 cx_oracle To ADB Fails With Error ORA-29003: SSL transport detected mismatched server certificate
python3
Python 3.6.8 (default, Sep 13 2022, 09:40:27)
[GCC 8.5.0 20210514 (Red Hat 8.5.0-10.1.0.1)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> dsn = "tcps://xxxxxxxxxxxxxxxxx.adb.us-ashburn-1.oraclecloud.com:1522/xxxxxxxxxxxxxxxxxxxxxxxxxxx_high.adb.oraclecloud.com?wallet_location=/home/opc/wallet&retry_count=20&retry_delay=3"
>>> cx_Oracle.connect(user="admin", password="<PRIVATE>", dsn=dsn, encoding="UTF-8")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
cx_Oracle.DatabaseError: ORA-29003: SSL transport detected mismatched server certificate.
Python 3.6.8 (default, Sep 13 2022, 09:40:27)
[GCC 8.5.0 20210514 (Red Hat 8.5.0-10.1.0.1)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> dsn = "tcps://xxxxxxxxxxxxxxxxx.adb.us-ashburn-1.oraclecloud.com:1522/xxxxxxxxxxxxxxxxxxxxxxxxxxx_high.adb.oraclecloud.com?wallet_location=/home/opc/wallet&retry_count=20&retry_delay=3"
>>> cx_Oracle.connect(user="admin", password="<PRIVATE>", dsn=dsn, encoding="UTF-8")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
cx_Oracle.DatabaseError: ORA-29003: SSL transport detected mismatched server certificate.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |