'Cannot create connection pool. A connection pool named 'jdbc/WorkflowDS_connectionPool' already exists' When Installing Workflow Repository For OWB 11.2 (Doc ID 1936084.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

The Workflow repository (OWF_MGR schema) has been created using wfinstall.csh in one database (database_A). Some time later, a second repository is created using the same wfinstall.csh (so started from the same home), but this time in a different database (database_B). The installation proceeds, but at the end displays Workflow Configuration has completed with error.

Analyzing the Workflow installation logfile shows that the Workflow Installer is connecting to the correct database (database B) in the beginning. But at the end, having reached the section WF Management (Workflow Management), the Workflow Installer is trying to connect to the database A where the first repository was installed, while it should connected to database_B. Following error is showed:

Cannot create connection pool.  A connection pool named 'jdbc/WorkflowDS_connectionPool' already exists. 

Last part of the workflow installation logfile:

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