DPY-5000: internal error: unknown protocol message type 0 while connecting to oracleDB · Issue #176 · oracle/python-oracledb (original) (raw)

While connecting to oracleDB, i am getting "DPY-5000: internal error: unknown protocol message type 0"

i have upgraded library to the latest version but still getting an error. Through SQL developer, i am able to connect to the DB with the same credentials

import traceback
import oracledb
try:
            # establish a new connection
            with oracledb.connect(user="username",
                                   password="password",
                                   dsn="hostname:port/servicename"
                                   ) as connection:
                # create a cursor
                with connection.cursor() as cursor:
                    cursor.execute("select * from dual")

except:
    traceback.print_exc()

### File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/oracledb/connection.py", line 1008, in connect
    return conn_class(dsn=dsn, pool=pool, params=params, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/oracledb/connection.py", line 130, in __init__
    impl.connect(params_impl)
  File "src/oracledb/impl/thin/connection.pyx", line 314, in oracledb.thin_impl.ThinConnImpl.connect
  File "src/oracledb/impl/thin/connection.pyx", line 202, in oracledb.thin_impl.ThinConnImpl._connect_with_params
  File "src/oracledb/impl/thin/connection.pyx", line 173, in oracledb.thin_impl.ThinConnImpl._connect_with_description
  File "src/oracledb/impl/thin/connection.pyx", line 114, in oracledb.thin_impl.ThinConnImpl._connect_with_address
  File "src/oracledb/impl/thin/protocol.pyx", line 228, in oracledb.thin_impl.Protocol._connect_phase_two
  File "src/oracledb/impl/thin/protocol.pyx", line 343, in oracledb.thin_impl.Protocol._process_message
  File "src/oracledb/impl/thin/protocol.pyx", line 322, in oracledb.thin_impl.Protocol._process_message
  File "src/oracledb/impl/thin/messages.pyx", line 292, in oracledb.thin_impl.Message.process
  File "src/oracledb/impl/thin/messages.pyx", line 179, in oracledb.thin_impl.Message._process_message
  File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/oracledb/errors.py", line 118, in _raise_err
    raise exc_type(_Error(message)) from cause
oracledb.exceptions.InternalError: DPY-5000: internal error: unknown protocol message type 0`