My Oracle Support Banner

Remote Data gateway Connection To On-Premise Database Fails With "Connection Refused. This Host Is Blocked By Agent Security Policy." Error (Doc ID 2707128.1)

Last updated on SEPTEMBER 07, 2020

Applies to:

Oracle Analytics Cloud - Version 105.6.0 and later
Information in this document applies to any platform.

Symptoms

User trying to create a Dataset from Client Machine using the Remote Data Gateway connection to on-premise database 

The IP address of Client Machine has been set in the option "Allowed hosts" in the Data Gateway window.

Error:
Cause: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 77031] Error occurs while calling remote service DatasourceService. Details: [JDSError : 119] Connection refused. This host is blocked by agent security policy. - Cause: Connection refused. This host is blocked by agent security policy Action: Please contact system administrator for the required access. Action: Please refer to logs for more Details

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.