Streams configuration page returns : A Streams replication setup job from previous run is already in progress

(Doc ID 1320251.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

Setting up streams replication with Oracle Enterprise Manager and if intermediate step fail with an error and on resolving the issue if start setup again ,Streams configuration page returns : " A Streams replication setup job from previous run is already in progress "

- Lets take one case :

Trying to set up Streams with Oracle Enterprise Manager. The setup finished successfully. OEM returns an error when running the import on the destination database. Solved the import problem, but when we try again to run the setup, Streams configuration page returns : "A Streams replication setup job from previous run is already in progress." Setup Streams Replication options are grayed out and shows us a link to Show Jobs. In the job activity page, there are no jobs running with "ALL" status. It seems like there is a mark somewhere that does not allow the new setup.
As a workaround try shutting down and restarting the database , drop and configure database console , all with the same result.

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