Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Unable to create OAC connection to new ADW but connection from SQLDeveloper works fine

Received Response
13
Views
2
Comments
R Stonaker
R Stonaker Rank 6 - Analytics & AI Lead
in Oracle Analytics Forum

I created a new ADW instance to be the target of an OAC Data Flow. ADW creation was successful, and I can connect to the new ADW using SQLDeveloper from my on-prem machine. When I try to create the ADW connection in OAC using those same connection details/wallet file I get "Failed to save the connection. Invalid connection details were supplied."

We have a VCN, and both the OAC env and the ADW are on the same subnet within that VCN. I ran Network Analyzer and the route between the OAC private IP and the ADW private IP is valid. Running Cloud Shell from the OCI console, on the same private subnet, the ADW hostname resolves to the correct private IP. However, when I try to run sql and connect to this ADW from the shell I get "ORA-17002: I/O error: Connection reset by peer, connect lapse 3 ms, Authentication lapse 0 ms ".

I'm obviously missing a step here, we already have another ADW connected to OAC for usage tracking and I've tried to compare all the settings between the two but I don't see anything missing. Any ideas on where I can look next?

Thanks

Rhonda

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    My first random guess would be to check the ACL of your ADW. In the other ADW that is working, do you have access control list enabled and configured? Do you have the same settings in your new one.

  • R Stonaker
    R Stonaker Rank 6 - Analytics & AI Lead

    Both ADWs are on the same subnet, within the same IP range, have public access disabled and neither have a Network security group selected. I'm not well-versed in the network side of OCI so I may not be looking in the right place but from what I read since we're using private endpoints, NSGs should control access instead of ACLs. Thanks for replying @Gianni Ceresa , I'll go ahead and open an SR since I know this is a pretty difficult issue to diagnose on a forum.