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