Error ORA-28040: No matching authentication protocol when two different oracle versions

TBenve — Fri, 15 Nov 2024 22:23:50 GMT

Hello everyone,

I'm having an issue with a project I just started working on.

I have a simple job with two subjobs doing the following :

tOracleInput1 -> storing data locally

OnSubjobOk

tOracleInput2 -> storing data locally

When I'm running it, I get the following error on the second tOracleInput : "Exception in component tOracleInput_2 (test)

java.sql.SQLException: ORA-28040: No matching authentication protocol".

tOracleInput1 is fetching data from an Oracle Database 12c and tOracleInput2 is fetching data from an Oracle Database 19c and that seems to be the problem.

If I run each subjob alone one by one, I got no error.

What I've tryied so far :

Downloading every ojdbc in the module tab (ojdbc12, 14-9i, 14, 6, 7, 😎 but I don't know how to "force" the use of one in particular
Constructing the whole project and replacing the ojdbc14.jar with an ojdbc10 and then 8 i found on the oracle website

What I can't do :

Split the job in two : There are 40+ jobs like that in the project...
Change the database settings : I'm not a DBA and those databases are not mine.

I'm working on Talend Open Studio for Data Integration 7.3.1.

Any help would be really appreciated,

Thank you for your time,

TBenve

Re: Error ORA-28040: No matching authentication protocol when two different oracle versions

Anonymous — Fri, 04 Nov 2022 02:45:04 GMT

ORA-28040 error mean your oracle client jdbc driver is not compatible with the backend oracle db.

for your job, please setup DB Version to "Oracle 12-7" for tOracleInput_1(oracle 12 c)

and setup DB version to "Oracle 18 or above" for tOracleInput_2( oracle 19)

I tested, it's working fine in my side

topic Error ORA-28040: No matching authentication protocol when two different oracle versions in Talend Studio

Error ORA-28040: No matching authentication protocol when two different oracle versions

Re: Error ORA-28040: No matching authentication protocol when two different oracle versions