Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OAC RDP View output error for ADW ORA-12506, TNS:listener rejected connection based on service ACL f

Received Response
6
Views
2
Comments
Rafi Ahmed
Rafi Ahmed Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

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

Tagged:

Answers

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

    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

  • RVohra
    RVohra Rank 7 - Analytics & AI Coach

    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.