Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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