Configuring JDBC Resources for High Availability - Oracle WebLogic Server 12c Advanced Administration - page 88

See also
F Creating a multi data source
Managing JDBC data sources
The WebLogic JDBC subsystem can be controlled when needed. A WebLogic Administrator
can start, stop, shrink, pause, suspend, and reset the data source on demand. The statement
cache can also be cleared if needed.
In this recipe, the ds-nonXA data source will be used as an example.
Getting ready
The JDBC operations use the Administration Console, so make sure the Administration Server
is running.
How to do it...
To control the data source operations, carry out the following steps:
1. Access the Administration Console with your web browser at http://adminhost.
domain.local:7001/console .
2. Click on the plus sign to open the Services tree on the left, and then click on
Data Sources.
3. Click on the ds-nonXA link to open the data source and then click on the
Control tab.
4. Select the checkbox from ds-nonXA and click on the button of the desired operation:
Shrink, Reset, Clear Statement Cache, Suspend, Resume, Shutdown, or Start.
How it works...
The data source control operations are useful in situations such as when an Oracle RAC node
is down or during a database maintenance window.
The Shrink operation closes the idle connections of the pool, freeing the database
connections and resources in use. It reduces the opened connections until the greater value
is between the minimum capacity parameter and the in-use connection.
The Reset operation resets the pool, closing and reopening all the database connections.