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

oracle docker oracle12c
10,978

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
Share:
10,978
Arturo29
Author by

Arturo29

Updated on June 04, 2022

Comments

  • Arturo29
    Arturo29 almost 2 years

    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

    • Marmite Bomber
      Marmite Bomber over 4 years
      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?
    • Arturo29
      Arturo29 over 4 years
      How do I verify and install this inside a container?
    • Marmite Bomber
      Marmite Bomber over 4 years
      What is the version of your SQL Developer? Maybe you need simple upgrade it. The JDBC Driver is integrated in the SQL Developer.
    • Arturo29
      Arturo29 over 4 years
      I managed to resolve by updating the version of SQL Developer.Thanks for your help

Recents

Why Is PNG file with Drop Shadow in Flutter Web App Grainy?
How to troubleshoot crashes detected by Google Play Store for Flutter app
Cupertino DateTime picker interfering with scroll behaviour
Why does awk -F work for most letters, but not for the letter "t"?
Flutter change focus color and icon color but not works
How to print and connect to printer using flutter desktop via usb?
Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0
Flutter Dart - get localized country name from country code
navigatorState is null when using pushNamed Navigation onGenerateRoutes of GetMaterialPage
Android Sdk manager not found- Flutter doctor error
Flutter Laravel Push Notification without using any third party like(firebase,onesignal..etc)
How to change the color of ElevatedButton when entering text in TextField

Related

Oracle Database Docker
I cant install oracle 12c R2 [20802]
Oracle on Alpine linux
ORA-01017 invalid username/password logon denied
Change Oracle 12c database characterset to WE8MSWIN1252 from AL32UTF8 without recreating the DB
ORA-65096: invalid common user or role name while installing data miner repository
Supported server versions for Oracle 12c client
ORA-65175: cannot grant SYSDBA privilege locally in the root
UPDATE with JOIN syntax for Oracle Database
Multiple error starting weblogic server