DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, January 7, 2016

ORA-28040: No matching authentication protocol when running with Oracle Database 12c

Issue:

ORA-28040: No matching authentication protocol when using the Test connection or full connection in the instance.

Oracle Database 12c is fully supported as an OMR with the vcops adapter. Unless that database is running as ALLOWED_LOGON_VERSION_SERVE=12a

12a is the highest level of security supported by 12c and requires the 12.0.2 db client or jdbc running with JDK 8. See here for reference:



Solution: 

Guide customer in changing ALLOWED_LOGON_VERSION_SERVER to 12 or lower in the sqlnet.ora file:

The sqlnet.ora file is in $ORACLE_HOME/network/admin 

(Note this may not be there by default, if so default settings for the listener are used)

[oracle@]$ pwd

/apps/oracle/db12c/network/admin

[oracle@]$ ls

listener14091810AM2151.bak
listener.ora
shrept.lst
tnsnames14091810AM2151.bak
tnsnames.ora
listener14091811AM3605.bak
samples
sqlnet.ora
 tnsnames14091811AM3605.bak

[oracle@]$ cat sqlnet.ora


SQLNET.ALLOWED_LOGON_VERSION=8
(which means the from db version 8 it allows the jdbc connection to latest version)



Change SQLNET.ALLOWED_LOGON_VERSION_SERVER to 9,10,11,or 12( for particular db version)


Restart the listener:

 lsnrctl start
 lsnrctl stop

No comments: