Connection DPY-4011 exception

[Vethorm]

Hello,

I'm currently working with Apache Airflow and the newer version we are upgrading to is using oracledb over cx_oracle. Previously we had no issue connecting with cx_oracle and still don't. Oracledb however seems to hang and then throw DPY-4011 exceptions. I have't been able to find much information on this aside from 1 or 2 articles mentioning to use disable_oob=True which unfortunately I can't set with Apache Airflow in the current version. I have confirmed this does fix our issue however.

I'm wondering if this is something I can resolve without the connection parameter disable_oob=True.

Happy to provide anymore information if it helps.

Thanks!

[anthony-tuininga]

You can in your application (before it creates a connection) make a call to init_oracle_client() -- this will enable thick mode and behaves the same way as cx_Oracle did.

We would, however, like to resolve the issue for thin mode, too. Can you provide details on the database version and the nature of the network connection between them?

[anthony-tuininga]

It is entirely possible that there is an issue with the thin client. Or it is possible that the thick client simply detects the error and retries with disable_oob = on. The client trace should help to figure out exactly what the thick driver is doing. I've also asked internally and will get back to you if I get an answer on that front.

[anthony-tuininga]

What version of the Oracle Client libraries are you using for the thick driver? You can do this to find out:

oracledb.init_oracle_client()
print(oracledb.clientversion())

[anthony-tuininga]

Also, can you provide details on the host you are using? Is it "localhost" or an actual name? Judging from the amount of spaces I think I can answer that question -- but thought I would make sure!

[Vethorm]

Oracle client library version: 12.2.0.1.0
The host is an actual name to an Oracle AWS RDS instance

[anthony-tuininga]

Ah! That does not have the OOB check included in it. Can you try with a 19c or 21c client which does have that check? You can use an instant client zip file and set LD_LIBRARY_PATH to the unzipped location.