ORA-28040 no matching authentication protocolSolution 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=9or 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.
its not working i have tried doing this but still i am getting the same error
ReplyDeleteIt's working, you can try stop and start listener after adding SQLNET.ALLOWED_LOGON_VERSION=9 in sqlnet.ora file
Delete