Google it ....

Friday, June 23, 2017

ORA-28040 no matching authentication protocol

There is connection problem to Oracle Database 12c with clients below 12c version, When I am trying to connect oracle database 12.2 with PL/SQL Developer appears next error
ORA-28040 no matching authentication protocol
Solution is to create a sqlnet.ora on server where database reside in the $ORACLE_HOME/network/admin location with the following parameter:
SQLNET.ALLOWED_LOGON_VERSION_SERVER=9
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=9
or if sqlnet.ora file exist under $ORACLE_HOME/network/admin
append SQLNET.ALLOWED_LOGON_VERSION_SERVER=9 and SQLNET.ALLOWED_LOGON_VERSION_CLIENT=9 and save it.
it means client with version 9 or later can connect to database, you can use numbers according oracle clients versions which correspondingly means minimum version of client can connect to database
If you have installed Grid infrastructure with different user than oracle, then you need also to do above procedures for GRID_HOME's sqlnet.ora file.

Finally stop and start listener to be useful sqlnet.ora parameters.

2 comments:

  1. its not working i have tried doing this but still i am getting the same error

    ReplyDelete
    Replies
    1. It's working, you can try stop and start listener after adding SQLNET.ALLOWED_LOGON_VERSION=9 in sqlnet.ora file

      Delete