iProcess EAIJAVA Plug-in is unable to connect to the Oracle database - ORA-28040: No matching authentication protocol
Article ID: KB0081299
Updated On:
| Products | Versions |
|---|---|
| TIBCO iProcess Technology Plug-ins | 11.6.0 |
Description
iProcess EAIJAVA Plug-in is unable to connect to the Oracle database
Error in iProcess eaijava log file is:
2018-04-13 17:11:44,024 [ERROR] TestServices 20180413127702 - [ERROR] - An Unchecked error occured when invoking Service Could not get JDBC Connection; nested exception is java.sql.SQLException: ORA-28040: No matching authentication protocol
Error in iProcess eaijava log file is:
2018-04-13 17:11:44,024 [ERROR] TestServices 20180413127702 - [ERROR] - An Unchecked error occured when invoking Service Could not get JDBC Connection; nested exception is java.sql.SQLException: ORA-28040: No matching authentication protocol
Issue/Introduction
iProcess EAIJAVA Plug-in is unable to connect to the Oracle database
Error in iProcess eaijava log file is:
2018-04-13 17:11:44,024 [ERROR] TestServices 20180413127702 - [ERROR] - An Unchecked error occured when invoking Service Could not get JDBC Connection; nested exception is java.sql.SQLException: ORA-28040: No matching authentication protocol
Environment
TIBCO iProcess Engine (Oracle) 11.6.0
TIBCO iProcess Technology Plugin 11.6.0
Oracle Database 12.1.x
Resolution
The Oracle Listener process returned the error:
ORA-28040: No matching authentication protocol
In Oracle 12.1.x the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been changed to 11.
Clients using pre Oracle 11g thin drivers cannot authenticate to the Oracle 12.1.x database.
iProcess was configured to use the Oracle ojdbc14.jar JDBC driver and therefore could not connect to the Oracle 12.1.x database.
The recommended resolution is to update the Oracle JDBC driver in iProcess to the version provided with the Oracle 12.1.c database.
To update the Oracle JDBC driver in iProcess:
1. Stop the iProcess Engine
2. Delete the current Oracle JDBC driver under SWDIR/eaijava/libs/repository/database/jdbc
3. Copy the ojdbc8.jar file provided in the Oracle 12.1.x database installation to SWDIR/eaijava/libs/repository/database/jdbc
4. Start iProcess
ORA-28040: No matching authentication protocol
In Oracle 12.1.x the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been changed to 11.
Clients using pre Oracle 11g thin drivers cannot authenticate to the Oracle 12.1.x database.
iProcess was configured to use the Oracle ojdbc14.jar JDBC driver and therefore could not connect to the Oracle 12.1.x database.
The recommended resolution is to update the Oracle JDBC driver in iProcess to the version provided with the Oracle 12.1.c database.
To update the Oracle JDBC driver in iProcess:
1. Stop the iProcess Engine
2. Delete the current Oracle JDBC driver under SWDIR/eaijava/libs/repository/database/jdbc
3. Copy the ojdbc8.jar file provided in the Oracle 12.1.x database installation to SWDIR/eaijava/libs/repository/database/jdbc
4. Start iProcess
Additional Information
TIBCO iProcess Technology Plug-in 11.6.0 Installation Guiode
Feedback
Yes
No
Powered by
