How to Resolve ORA-28040: No matching authentication protocol with Docker

1
votes

Good afternoon, I am trying to run an oracle database with docker, but when I try to connect from the sql developer I get the following error:

enter image description here

ORA-28040: No matching authentication protocol

The question is that I am using the parameters that are specified to be necessary to connect to the database, such as the host ip (10.164.7.203) and port 1521:

enter image description here

Try to apply the solution described here:

https://logic.edchen.org/how-to-resolve-ora-28040-no-matching-authentication-protocol/

**enter image description here**

but I haven't managed to solve the problem either

The container is lifting normally and I have even done operations with sqlplus and everything is fine

enter image description here

1
oracledockeroracle12c
What is your jdbc driver version? For 12.2 you need ojdbc8.jar or higher. See What are the Oracle JDBC releases Vs JDK versions? - Marmite Bomber
How do I verify and install this inside a container? - Arturo29
What is the version of your SQL Developer? Maybe you need simple upgrade it. The JDBC Driver is integrated in the SQL Developer. - Marmite Bomber
I managed to resolve by updating the version of SQL Developer.Thanks for your help - Arturo29

1 Answers

0
votes

the container DON'T use $ORACLE_HOME/network/admin/sqlnet.ora

you must modify in 

/app/oracle/product/12.2.0/dbhome_1/admin/ORCLCDB
SQLNET.ALLOWED_LOGON_VERSION=8