Re: Welcome to the Talend Community!

Highlighted
One Star

Re: Welcome to the Talend Community!

Hi Team 

 

I am facing Problem in talend related with database connection. My database is restored on oracle Latest Version 12.2 and Talend open Studio Version is 6.3.1

 

In MetaData Connection is Make Sucessfully, but when Trying to excute job it give error related database connectivity

Capture1.PNG

Below given Error is coming when excute the job

 

xception in component tOracleInput_1 (test2)
java.sql.SQLException: ORA-28040: No matching authentication protocol

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:306)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
at java.sql.DriverManager.getConnection(Unknown Source)
[statistics] disconnected
at java.sql.DriverManager.getConnection(Unknown Source)
at local_project22.test2_0_1.test2.tOracleInput_1Process(test2.java:820)
at local_project22.test2_0_1.test2.runJobInTOS(test2.java:1478)
at local_project22.test2_0_1.test2.main(test2.java:1081)
Job test2 ended at 16:04 17/04/2017. [exit code=1].

 

Please tell me solution of this Problem.

This Issue facing only 12.2 version of Oracle, Its working fine with 12.1 version

Community Manager

Re: Welcome to the Talend Community!

Can you please post your question in a new thread on the correct board? The community will not be likely to find it and help you in the reply here.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads