DPY-3015: password verifier type 0x939 is not supported by python-oracledb in thin mode

Question

I am trying to connect python and oracle db but I cannot downolad any clients as there is no internet connection.

I am using oracledb for that but I am getting this error. Any clue about how to solve it without downolading anything ?

Thank you!

Answer 1

The problem is that on the server you have the database setting called sec_case_sensitive_logon which, when set to the value FALSE and combined with the sqlnet.ora setting sqlnet.allowed_logon_version_server=10 disables the use of the 11g and 12c verifiers -- which are the only ones that the thin driver supports.

You can see that on this python-oracledb issue raised earler.

You will have to disable the case insensitive logon or use the thick driver (which requires downloading the client libraries).