'Cannot create connection pool. A connection pool named 'jdbc/WorkflowDS_connectionPool' already exists' When Installing Workflow Repository For OWB 11.2
Last updated on MAY 09, 2017
Applies to:Oracle Warehouse Builder - Version 188.8.131.52 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:
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