CODEWITHSUNDEEP
pythonoracle-databaseairflow
Rabei Daraghmeh
Rabei Daraghmeh

Reputation: 3

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

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

Upvotes: 0

Views: 3387

Answers (2)

Anthony Tuininga
Anthony Tuininga

Reputation: 7096

That error is raised when you are in thin mode and the logon type supported by the server is not supported. Looking at it further, however, there is no reason for this error and I have removed it from the code -- which will be released as python-oracledb 1.1.

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.

Upvotes: 1

Hussein Awala
Hussein Awala

Reputation: 5110

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.

Upvotes: 0

Related Questions