Domain Extension Failed Due to TNS:listener rejected connection based on service ACL filtering (Doc ID 2965610.1)

Last updated on AUGUST 03, 2023

Applies to:

Symptoms

On : 12.2.1.4.0 version, WebCenter Sites

When attempting to extend sites domain to include sitecapture with ATP-S database
the following error occurs.

ERROR
-----------------------
com.oracle.cie.domain.gui.jdbc.ShadowTableConfigurationPanel$BindThread$1 - com.oracle.cie.common.util.PublishedMessage@42929e43
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12506, TNS:listener rejected connection based on service ACL filtering
 
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
  ..................................
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12506, TNS:listener rejected connection based on service ACL filtering
 
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:341)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1601)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)
... 9 more

Cause

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