Tuesday, 20 June 2017

Datasource java.sql.SQLException ORA-28040 No matching Authentication protocol DRSA0010E

Error:

After upgrading from 11g to 12c when the application datasource trying to connect.We are getting below error

"Datasource java.sql.SQLException ORA-28040 No matching Authentication protocol DRSA0010E"

Solution:
In 12c ORACLE_HOME/network/admin/sqlnet.ora enter the below values and restart the listener.



SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
 
lsnrctl reload
Now try to connect from application.

No comments: