Oracle Fusion ERP Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Not able to connect to ADW using SQL developer

Accepted answer
23
Views
3
Comments
Yogesh Yadav
Yogesh Yadav Rank 3 - Community Apprentice

We are trying to connect to ADW with OAX_USER using SQL developer but getting error while doing so. But when we try to create connection using OAC DV with same wallet file and OAX_USER. Its working.

Best Answers

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach
    edited December 6 Answer ✓

    @Yogesh Yadav It looks like a network issue. Is your FDI in private or public endpoint?

    1. Are you trying this SQL Developer connection from inside your company vpn or public internet?
    2. In case your FDI is hosted on public endpoint, I would suggest to try the SQL Developer connection outside your company vpn and give it a try once.
    3. Also, check with your network team if there are any firewall that is blocking the connection to the ADW.

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach
    Answer ✓

    @Yogesh Yadav Yes, you may also need to run some network tests/curl command from your Client system having SQL Developer to the ADW database and ensure there are no connectivity issues between them.

Answers

  • Yogesh Yadav
    Yogesh Yadav Rank 3 - Community Apprentice

    @Ashish-Oracle FDI is in private endpoint. I am using company VPN to connect. I will check with network team for the firewall part