Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Unable to connect to ATP database from OAC
Sourav Dey
Rank 1 - Community Starter
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.
0
Best Answer
-
This is resolved now after adding CIDR block in the ACL for the ATP database.
2
Answers
-
It'll be very helpful information.
Thanks for sharing @Sourav Dey!
0 -
@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.
1
