The most recent error is that the OP Connector isn't able to connect to your Oracle server.
Error establishing socket to host and port: 18.104.22.168:1521. Reason: Connection timed out: connect
Are other products, such as the DataDirect Oracle JDBC driver, able to connect from the OP Connector machine?
Thanks a lot for your time this morning. Your inputs have been invaluable.
I have been able to establish connectivity between Salesforce.com and an on-premise OracleDB using Lightning Connector and DataDirect Cloud.
Your team has been very helpful and prompt in responding to my questions. I appreciate it!
Our pleasure Ashish! To recap for the community, the solution was to enter "localhost" for the server in the DataDirect Cloud Data Source since Oracle 12c appears to limit connections as coming from "localhost".
Check out my world famous blog on data connectivity
That's correct. Below is a screenshot of the final configuration within the D2C Web UI-