Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-28040 persists after sqlnet revisions

edited Aug 5, 2020 5:00AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered

receive ORA-28040: No matching authentication protocol     when attempting sqlplus connection to new oracle 19c  RAC on AIX .  The client is SunOS 5.10  ( solaris 10, I guess) 

application currently operating on  Oracle 11.2.0.4  -- moving to new instance /hardware/etc.

the client software is 10.2.0.1:

TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Prod succeeds to the new scan address.

we have added the following to sqlnet.ora ,  both server and client

SQLNET.ALLOWED_LOGON_VERSION=10

SQLNET.ALLOWED_LOGON_VERSION_SERVER=10

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10

and restarted listener.    This seems like it should work,.  but no change in behavior.   Question... would  this work of we go to 10.2.0.5 client ?     or is there something else that needs to be configured 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center