EDQP Jobs Hung with Error "ERROR : ORA : 02020 too many database links in use" (Doc ID 2044246.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Enterprise Data Quality for Product Data - Version 5.6.2 and later
Information in this document applies to any platform.

Symptoms

Custom EDQP DSA's have a sequence of database procedures that execute the back-end process(es) by using db link. 
Error reported in logs:

 It is working successfully through sql prompt.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms