Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OAC RDP View output error for ADW ORA-12506, TNS:listener rejected connection based on service ACL f
Error while connecting form OAC to ADW while view the RDP
[JDSError: 22] Exception from datasource. errorcode=116 [JDSError: 116] JDBC Connection Error: Listener refused the connection with the following error:ORA-12506, TNS:listener rejected connection based on service ACL filtering- Cause: Listener refused the connection with the following error:ORA-12506, TNS:listener rejected connection based on service ACL filtering
Best Answer
-
Hi
Not sure what RDP View output means? Are you trying to connect Admintool to private ADW and facing issues?
If yes please check if following KM will help:
OAC : How To Configure OAC RPD to Connect to Private Autonomous Database Using RDG (Doc ID 2679897.1)
Thanks
Gayathri
0
Answers
-
You might need to work with your Oracle Cloud Admin and see if it is because of ACLs. Autonomous Data Warehouse requires that every client IP be explicitly allowed through:
- Network ACLs for public endpoints
- Private Endpoint security rules for private endpoint deployments.
Oracle Analytics Cloud (OAC) connects from a specific public IP (or set of IPs).
If your OAC IP isn’t whitelisted in ADW, the listener rejects the connection → ORA-12506.0 -
Yes, trying to connect Admintool to private ADW and facing issues. I will go through the document and follow the steps. will update the result accordingly.
0 -
Thanks for the Inputs, As of now we are trying to access it from OCI VM, OAC is in Private network, and we have RDG.
0
