search

MaksymBilenko / docker-oracle-12c

:whale: Docker image with Oracle Database 12c on board
Apache License 2.0
680 stars 285 forks source link

about "ORA-28040: No matching authentication protocol" when tomcat web connect to docker oracle instance #115

Open 82318179 opened 6 years ago

82318179 commented 6 years ago

thank you MaksymBilenko for creating this docker image! my issue is : i create docker-oracle-12c and impdp data successfully . when my web(tomcat) connect to the docker oracle instance , the logs display the error "ORA-28040: No matching authentication protocol" .
i google this error , 　it is need change sqlnet.ora like below: $ORACLE_HOME/network/admin/sqlnet.ora 　　SQLNET.ALLOWED_LOGON_VERSION=8

but i cannot find $ORACLE_HOME/network/admin/sqlnet.ora file . i just find sqlnet.ora in $ORACLE_HOME/network/admin/sample :)

ps: i can connect to this docker oracle instance using dbeaver. :)

so how to solve this issue , pls help me . thank god !

enschede commented 5 years ago

Same here

drognisep commented 5 years ago

I used docker exec -it my_container_name bash to get a shell in the container, and then echo $ORACLE_HOME to get the following path.

/u01/app/oracle/product/12.1.0/xe

The sqlnet.ora file doesn't already exist at the specified path, but you can copy the sample from $ORACLE_HOME/network/admin/samples/sqlnet.ora to the expected directory and append the sqlnet.allowed_logon_version=8 setting in that file.

I'm not savvy enough with Oracle to say whether that will actually solve your problem, but at least this method will let you test whether the proposed solution works or not.