search

gvenzl / oci-oracle-xe

Build scripts for Oracle Database XE container/docker images
Apache License 2.0
257 stars 77 forks source link

ORA 28040 No matching Authentication Protocol #230

Closed admin-conciergeai closed 8 months ago

admin-conciergeai commented 9 months ago

docker run -d -p 1521:1521 -e ORACLE_PASSWORD=123456 -v oracle-volume:/opt/oracle/oradata -v /Users/jpsl/DosPlayas-backup:/opt/backup gvenzl/oracle-xe \n

Already tried setting env variables to lower version but the error persists: -e SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 -e SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

how do I fix this?

gvenzl commented 8 months ago

Hi @admin-relu,

Thanks for using these images!

Both of these parameters are, as per Oracle documentation, to be set in the sqlnet.ora file, and not as environment variables.

You can find the sqlnet.ora file under <your volume>/dbconfig/XE/sqlnet.ora