Connectivity issues to Oracle Autonomous DataWareh... - Qlik Community

Anonymous · ‎2020-02-10

Hi! We are trying to connect from Talend to Oracle ADW R18. We were able to establish connection (we get the connection was successful message), but unable to load data after creating the flow. This is the following error we get:

Exception in component tDBConnection_1 (unarchive)
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:801)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:782)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at ashfordoci.unarchive_0_1.unarchive.tDBConnection_1Process(unarchive.java:325)
at ashfordoci.unarchive_0_1.unarchive.runJobInTOS(unarchive.java:618)
at ashfordoci.unarchive_0_1.unarchive.main(unarchive.java:468)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:569)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:521)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:660)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:287)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1481)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:540)
... 8 more
Caused by: oracle.net.ns.NetException: Unable to initialize ssl context.
at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:344)
at oracle.net.nt.CustomSSLSocketFactory.getSSLContext(CustomSSLSocketFactory.java:305)
at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketEngine(CustomSSLSocketFactory.java:271)
at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:170)
at oracle.net.nt.ConnOption.connect(ConnOption.java:172)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:508)
... 13 more
Caused by: oracle.net.ns.NetException: Unable to initialize the key store.
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:617)

Here are our connection details provided:

DB Type: Oracle Custom

DB Version: Oracle 18

Login: XXXX

Password: XXXX

String of Connection:

jdbcracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=adb.XXXX.oraclecloud.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=XXXX_XXXX_high.adwc.oraclecloud.com)))

Schema: XXXX

Additional Parameters: javax.net.ssl.trusStoreType=SSO & javax.net.ssl.KeyStoreType=SSO

There is also no option to upload the wallet for Oracle ADW R18 connection, which i think is required. We are able to connect to SQL Developer and DataSync using the same credentials (by uploading the wallet) and it works on both. Anyone has a similar issue?

Thanks,

Prasanna

msdawood · ‎2021-09-15

@Prasanna Thota I'm also facing the same issue....Please let me know if u have the answer

Anonymous · ‎2021-09-15

Hello,

This issue should be fixed in V 7.3.1. Feel free to let me know if there is any issue from your side.

Best regards

Sabrina

tale103108 · ‎2022-06-21

The issue in not fixed in v7.3.1.

Anonymous · ‎2022-06-22

Hello,

Please have a look at this related topic to see if the solution in that thread helps?

https://community.talend.com/s/question/0D55b00006QG7CQCA1/oracle-autonomous-datawarehouse-adw-conne...

Best regards

Sabrina

RVeitch_84 · ‎2022-06-22

The issue in not fixed in v8.0.1 Build id: R2022-05

As I have the same issue.

[FATAL] 10:00:07 talendjobs.square_0_1.square- tDBConnection_1 IO Error: The Network Adapter could not establish the connection

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]

at java.sql.DriverManager.getConnection(DriverManager.java:189) ~[java.sql:?]

at talendjobs.square_0_1.square.tDBConnection_1Process(square.java:886) [classes/:?]

at talendjobs.square_0_1.square.runJobInTOS(square.java:1509) [classes/:?]

at talendjobs.square_0_1.square.main(square.java:1246) [classes/:?]

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:445) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:464) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:594) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:229) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

... 9 more

Caused by: oracle.net.ns.NetException: Unable to initialize ssl context.

at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketFactory(CustomSSLSocketFactory.java:325) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:115) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.nt.ConnOption.connect(ConnOption.java:133) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:411) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:464) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:594) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:229) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

... 9 more

Caused by: oracle.net.ns.NetException: Unable to initialize the trust store.

at oracle.net.nt.CustomSSLSocketFactory.getTrustManagerArray(CustomSSLSocketFactory.java:413) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]

at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketFactory(CustomSSLSocketFactory.java:309) ~[ojdbc7-6.0.0.jar:12.1.0.1.0]