Skip Headers
Oracle® Healthcare Foundation Installation Guide
Release 7.1.1

E79438-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

15 JDBC GridLink Data Source Configuration (optional)

You can optionally configure the WebLogic server GridLink data source to distribute database connections to Oracle RAC instances.

Before you create a multi-data source, edit the existing generic data source, create the generic data sources that the multi-data source will manage, and deploy them to the same targets where you want to deploy the multi-data source. You can create data sources and multi-data sources in a single edit session.

  1. Installing the Middle-Tier on the Primary Node

  2. Installing the Middle-Tier on a Secondary Node

15.1 Edit the Existing Generic Data Source

Checkbox In the Administration Console, in the Change Center, click Lock & Edit.
Checkbox In the Domain Structure tree, expand Services and select Data Sources.
Checkbox Select the desired data source and, under the Configuration tab, select General.
Checkbox Change JNDI Name to a unique value.

Note: You can use a numeric suffix, like -1, to make a value unique. For instance, you can change "jdbc/OHF-ODB" to "jdbc/OHF-ODB-1"..

Checkbox Click Save to save the JDBC data source changes.
Checkbox In the Administration Console, in the Change Center, click Activate Changes.

Note: Not all changes may take effect immediately. Some changes may require a restart.


15.2 Create the JDBC GridLink Data Source

Follow the instructions described in https://mosemp.us.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=1382656.1, using the following parameters:

Checkbox The data source Name and JNDI Name must be unique.
Checkbox Use the JNDI Name used by the application. For OMICS, this is jdbc/OHF-ODB.
Checkbox Use the following default values for OHF Data Source creation:
  • Add the following value to Properties: oracle.jdbc.defaultRowPrefetch=100

  • Initial Capacity: 10

  • Maximum Capacity: 10

  • Minimum Capacity: 10

  • Wrap Data Types: Unchecked for Omics Data Source