Hi,
I am trying to connect to my Always Free ADB with Python 3.9.13 (fresh installed today) and OracleDB
without success:
Traceback (most recent call last):
connection = oracledb.connect(user='northwind', password='blahblah', dsn='db21cpresent_medium')
File "C:\Python39\lib\site-packages\oracledb\connection.py", line 995, in wrapped
return conn_class(dsn=dsn, pool=pool, params=params, **kwargs)
File "C:\Python39\lib\site-packages\oracledb\connection.py", line 124, in __init__
impl.connect(params_impl)
File "src\oracledb\impl/thin/connection.pyx", line 309, in oracledb.thin_impl.ThinConnImpl.connect
File "src\oracledb\impl/thin/connection.pyx", line 164, in oracledb.thin_impl.ThinConnImpl._connect_with_params
File "src\oracledb\impl/thin/crypto.pyx", line 125, in oracledb.thin_impl.get_ssl_socket
File "C:\Python39\lib\ssl.py", line 501, in wrap_socket
return self.sslsocket_class._create(
File "C:\Python39\lib\ssl.py", line 1041, in _create
self.do_handshake()
File "C:\Python39\lib\ssl.py", line 1310, in do_handshake
self._sslobj.do_handshake()
ssl.SSLError: [SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:1129)
The same connection works with cx_Oracle fine.
Regards, Friedhold