Oracle Communities

Oracle Analytics and AI

Child Item

Unable to connect to ATP database from OAC

Hi,

We have a requirement to create reports in OAC and the data resides in ATP database.

We have created a connection in OAC to connect to ATP using database wallet. There is a ACL configured in the ATP db, we have included the Gateway IP of the OAC to allowlist the IP.

But the connection is not successful. Can you please throw some light if I am missing something here.

Find more posts tagged with

Accepted answers

Sourav Dey

This is resolved now after adding CIDR block in the ACL for the ATP database.

All comments

Sourav Dey

This is resolved now after adding CIDR block in the ACL for the ATP database.

Bhaskar Konar

It'll be very helpful information.

Thanks for sharing @Sourav Dey!

Clare Murtagh

@Sourav Dey You could try allowing a CIDR block in the ATP ACL instead of a single IP. OAC can use a range of outbound addresses, so opening the whole block helps avoid ATP blocking the connection if the IP shifts.