Hey folks, needed some help while setting up Oracle DB as a source, I have a ATP host on Oracle Cloud Free tier, but the connection is failing, i am guessing its due to certificate issue, but not sure how to proceed I have tried NNE, but it didn't work, i am guessing something needs to be changed on the host side?

Hey @Bhupesh Varshney, thanks for the question. Which OracleDB connector are you using, the strict-encrypt one or the other? Are you able to generate a ssl certificate on Oracle Cloud for your server? What is the error you’re getting when trying to set up the connector with NNE?

Hey so while connecting with NNE, the connection timed out with following error

The connection tests failed.
Could not connect with provided configuration. Error: HikariPool-1 - Connection is not available, request timed out after 60001ms.

Which OracleDB connector are you using, the strict-encrypt one or the other?

not sure which one is it

Are you able to generate a ssl certificate on Oracle Cloud for your server?

couldnt figure this out as well. The docs says to use "wallet" to connect, but not sure how to generate SSL certificate from the wallet Attaching db config from oracle cloud for ref

@Bhupesh Varshney can you start a ticket/chat with our cloud support team? https://airbyte.com/help