The VxWorks based deviceWISE platforms are:
- Mitsubishi MESInterface IT
- Enterprise Gateway for Siemens ERPC
If a VxWorks-based platform with an Oracle database transport fails to connect to the Oracle 12c server with the following error:
java.sql.SQLException: ORA-28040: No matching
authentication protocol
It is due to the fact that Oracle 12c is configured to use a default minimum authentication protocol of 11 and the deviceWISE VxWorks platform uses an older unsupported JDBC driver tied to JDK 1.5. This is equivalent to an Oracle 8 client and consequently uses an Oracle 8 authentication protocol. You need to do the following configuration to fix this issue:
- Configure the sqlnet.ora file with the
following parameters to allow a version 8
authentication protocol.
- SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
- SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
- SEC_CASE_SENSITIVE_LOGON=FALSE
- Restart the server
If you are using an existing login id from the deviceWISE VxWorks Platform, you will need to use PL/SQL and change the password of the user to force the server to rehash passwords with compatible versions. A recommended approach would be to create a new login id and specify those credentials on the Oracle 12c Transport on the deviceWISE VxWorks Platform.
For additional help, refer to the following links:
- https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016 (See the section on SQLNET.ALLOWED_LOGON_VERSION_SERVER. )
- https://developer.ibm.com/answers/questions/177075/after-upgrading-to-oracle-12c-database-i-start-get.html
- https://mikedietrichde.com/2017/04/24/having-some-fun-with-sec_case_sensitive_logon-and-ora-1017/