Oracle 12c Authentication Protocol Settings

Oracle 12c Authentication Protocol Settings

book

Article ID: KB0078851

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight -

Description

The Scribe 7.1 Oracle Wire Protocol ODBC DSN connections may fail to Oracle 12c with either of the following errors:
 
  • ORA-28040: No matching authentication protocol
  • ORA-03134: Connections to this server version are no longer supported
 
This is caused by a mismatch between the Client and Server values specified for the authentication protocol version for Oracle.
If upgrading Oracle for a system that did not have a SQLNET.ALLOWED_LOGON_VERSION parameter setting (that is, it was using the default 8), then you might need to set the value of  the SQLNET.ALLOWED_LOGON_VERSION_SERVER to 8 in the upgraded Oracle Database 12c server to maintain compatibility with clients on earlier releases. For example (see in Red)

   $ cat /opt/app/oracle/product/12.1.0.2/network/admin/sqlnet.ora
   # sqlnet.ora Network Configuration File: /opt/app/oracle/product/12.1.0.2/network/admin/sqlnet.ora
   # Generated by Oracle configuration tools.
   NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
   SQLNET.ALLOWED_LOGON_VERSION=8
 

Issue/Introduction

The Scribe 7.1 Oracle Wire Protocol ODBC DSN connections may fail to Oracle 12c with either of the following errors: ORA-28040: No matching authentication protocol ORA-03134: Connections to this server version are no longer supported