My Oracle Support Banner

'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 JULY 17, 2019

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:

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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