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 FEBRUARY 01, 2022

Applies to:

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


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:




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

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