'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:

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

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