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
24
Views
3
Comments
Rank 4 - Community Specialist

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

  • Rank 7 - Analytics Coach
    edited Dec 6, 2024 4:16PM 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.
  • 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

Welcome!

It looks like you're new here. Sign in or register to get started.