search

oracle / python-oracledb

Python driver for Oracle Database conforming to the Python DB API 2.0 specification. This is the renamed, new major release of cx_Oracle
https://oracle.github.io/python-oracledb
Other
328 stars 66 forks source link

DPY-3015: password verifier type 09X939 is not supported by python-oracledb in thin mode #67

Closed kintaka0812 closed 2 years ago

kintaka0812 commented 2 years ago

Any clue about how to solve this issue without installing any client as there is no internet connection in the pc?

anthony-tuininga commented 2 years ago

Yes, take a look at issue #26. Specifically, you need to remove the database setting sec_case_sensitive_logon (or set it to the value TRUE). If you cannot do that you will have no choice but to use the thick driver (and you will need to download the instant client on another machine and copy it across using some other means than the Internet).

kintaka0812 commented 2 years ago

Thanks! I guess I need to speak with the Oracle DBA for that right?

Otherwise I can install the suitable packages from here: https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html

Do I have to save it in a specific location? The code I am using is the very basic one, I just enter the username, pw and dns st the connect command.

anthony-tuininga commented 2 years ago

Yes, you would need to talk to the Oracle DBA to remove the sec_case_sensitive_logon setting.

For installation with the instant client, look at the documentation.