Connect to Oracle DB through a vpn

Options
IsaacChavez
IsaacChavez Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 14

Hello everyone

I am trying to connect to an Oracle DB through a VPN, my computer is already connected to the VPN and when I test the connection between my computer and the DB host with ping it works, but when it try in Dataiku it fails:

Failed to reach database: Failed to connect, caused by: SQLException: IO Error: The Network Adapter could not establish the connection, caused by: NetException: The Network Adapter could not establish the connection, caused by: SocketTimeoutException: connect timed out

Is there a way that Dataiku can connect to that VPN? so I can connect to the database

Thank you!

Answers

  • Catalina
    Catalina Dataiker, Dataiku DSS Core Designer, Registered Posts: 135 Dataiker
    Options
    The error indicates that DSS host cannot connect to the Oracle database server.
    Testing the connection between your computer and the DB host would be relevant only in the case if DSS would run locally on your computer. If this is not the case, you need to connect to DSS host and then check if DSS host can connect to the Oracle database server by running a telnet command like below:
    telnet <oracle-db-host> <port>
    Since this issue is network related you should follow up with your network admins for further assistance investigating this.
Setup Info
    Tags
      Help me…