Increasing the Connection Pool for odiMasterRepository and odiWorkRepository

After creating and configuring the Oracle Data Integrator (ODI) Java EE Agent, modify the connection pool settings for the odiMasterRepository and odiWorkRepository as follows:

  1. Sign in to the WebLogic Administration Console:

    http://<server>:<port>/console

    where

    <server> is the IP address of the server.

    <port> port is the listening port (by default, 7001).

    /console is the default context for the WebLogic Administration Console.

  2. In the Domain Structure pane, expand the Services node and click Data Sources.
  3. To modify the connection pool settings for odiMasterRepository:
    1. In the Data Sources table, click odiMasterRepository.
    2. Click the Connection Pool tab.
    3. In the Initial Capacity field, enter 100.
    4. In the Maximum Capacity setting, enter 150.
    5. Click Save.
  4. To modify the connection pool settings for odiWorkRepository:
    1. In the Data Sources table, click odiWorkRepository.
    2. Click the Connection Pool tab.
    3. In the Initial Capacity field, enter 100.
    4. In the Maximum Capacity setting, enter 150.
    5. Click Save.

      Note: No restart is required.


Last Published Tuesday, December 20, 2022