DAC 11g: CONNECTION_ISSUE <schema> Acquiring Semaphore Took X Mins YY Secs ZZZ Millis (Doc ID 2063064.1)

Last updated on AUGUST 09, 2016

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Goal

BI Apps 7.9.6.4 version, in DAC 11.1.1.6.4

Error: "CONNECTION_ISSUE <Datawarehouse_schema> acquiring semaphore took X mins YY secs ZZZ millis "

An execution plan took 23 Hours to complete. It was found from the DAC EP task details that Create and Drop Indexes are running for a very long time. The DBA Team confirmed that its actually not taking that much time at DB level.
The DAC log has lot of connection issue errors, Example: "CONNECTION_ISSUE BI_TGT_EDWH acquiring semaphore took 6 mins 44 secs 397 millis"

What can be the possible reason for this issue?
 

Solution

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