Categories
- All Categories
- Oracle Analytics Learning Hub
- 31 Oracle Analytics Sharing Center
- 21 Oracle Analytics Lounge
- 251 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 93 Oracle Analytics Trainings
- 16 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
Answers
-
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 -
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
