My Oracle Support Banner

Investigating JDBC MultiPool Issues in WebLogic Server Support Pattern (Doc ID 1148756.1)

Last updated on MARCH 05, 2024

Applies to:

Oracle WebLogic Server - Version 6.1 to 8.1
Information in this document applies to any platform.

Purpose

Problem Description

WebLogic Server MultiPools come in two different flavors: high availability and load balancing MultiPools. These two algorithms are mutually exclusive and intended to achieve different goals. This pattern provides information on both algorithms.

Understanding WebLogic Server MultiPools and their limitations helps to avoid common problems and to find answers to frequently asked questions. This pattern gives you information on some common issues. Enhancements that have been implemented for MultiPools in WebLogic Server versions 8.1 SP3 / 7.0 SP5 and upwards are also summarized. Links to related reading from our documentation are also provided for more details.

Problem Troubleshooting

The following provides background on WebLogic Server MultiPools that will help you investigate issues and problems around MultiPools:

Troubleshooting Steps

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
Purpose
 Problem Description
 Problem Troubleshooting
Troubleshooting Steps
 Understanding WebLogic Server MultiPools
 WebLogic Server MultiPool Algorithms
 High Availability Algorithm
 Load Balancing Algorithm
 Limitations of MultiPools
 Enhancements in WebLogic Server version 8.1 SP3 / 7.0 SP5 and upwards for MultiPools
 Common Problems, FAQs and their Solution
 Should I use WebLogic Server MultiPools or Oracle RAC/TAF?
 How does the high availability algorithm decide from which connection pool in the MultiPool list a connection will be used?
 What happens with a JDBC connection pool in a MultiPool configuration if a database is shut down?
 How can I disable the first (or any) JDBC connection pool so that the Multipool goes directly to the next pool in the list?
 How do I resume a JDBC connection pool (in a Multipool) after the underlying database is back up again?
 How do I enable a JDBC connection pool that was disabled because the underlying database was down?
 Why does failover to the second pool take so long when I test failover scenarios by pulling the network cable?
 Related FAQs in WebLogic Server Documentation regarding MultiPool
 Related Reading
 Known Issues
 Need further help?
References

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