Test Connection would fail for JDBC Connection resource with "No matching authentication protocol" message
Article ID: KB0094116
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
The driver for Oracle DB is installed correctly using "bwinstall oracle-driver" but the Test Connection would still fail for JDBC Connection resource with "No matching authentication protocol" message
Symptoms:
"No matching authentication protocol" message when attempting to connect to DB
Cause:
Incompatible driver
Issue/Introduction
Resolution
- Database Server version.It can be confirmed by running SQL query shown below
++++++
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 – Production
++++++
- Version by extracting up the ojdbc<x>.jar and looking up the Implementation version in the manifest file (Manifest.mf ).
++++++
++++++
Navigate to below locations in your BW 6.x environment
<TIBCO_HOME>\bw6\bw\6.x\config\drivers\shells\jdbc.oracle.runtime\runtime\plugins\com.tibco.bw.jdbc.datasourcefactory.oracle\lib
<TIBCO_HOME>\bw6\bw\6.x\config\design\thirdparty
- Remove all existing jars from above locations & copy ojdbc7.jar at these locations
- Open a command prompt & go to <TIBCO_HOME>\bw6\bw\6.x\bin and run below command,
bwinstall oracle-driver
Feedback
