ORA- 28040: No matching Authentication protocol after 12c Upgrade


Web application was not working, when connecting through ODBC application team is getting error ORA-28040 .

What Was changed:

Oracle database upgraded from oracle to


SQLNET.ALLOWED_LOGON_VERSION default is changed to 11 from 8 in earlier versions.  We need to modify the parameter to value 9 or less. SQLNET.ALLOWED_LOGON_VERSION is depreciated in 12c, SQLNET.ALLOWED_LOGON_VERSION_SERVER and SQLNET.ALLOWED_LOGON_VERSION_CLIENT replaced this parameter.

Ref: https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s