Error DPY-3011 when connecting to python-oracledb to Oracle DB 12.1-CodePudding

I tried to connect to Oracle 12.1 using python-oracledb from airflow environment but I got the following error

DPY-3011: server logon version is not supported

What is this error mean and how I can solve it?

Update: I connect to Oracle 19c and it works fine without issues, so I suspect that python-oracledb is not compatible with Oracle 12.1

CodePudding user response：

The lib python-oracledb works fine with 12.1, but you need to install a supported version. Here are the supported oracle database versions for each lib version.

CodePudding user response：

That error is raised when you are in thin mode and the logon type supported by the server is not supported. I'll adjust the error message to make that clear. Thin mode does support Oracle Database 12.1.0.2 and higher (not 12.1.0.1 if that is the version you are using).

As noted by Hussein, if you enable thick mode then you can connect to older databases, depending on the Oracle Client version you are using.