Create a Grid Link Data Source on Dept1_Cluster1
Create a grid link data source for each of the Oracle database instances
during the process of setting up the multidata source, both for these data
sources and the global leasing multidata source.
-
Prepare to create the data source.
-
Ensure that this is a non-xa
data source.
-
Target these data sources to the Dept1_Cluster1
cluster.
-
Set the data sources connection pool initial capacity to 0.
-
In the Oracle WebLogic Server Administration Console,
select Services, JDBC, and then Datasources.
-
In the Datasources screen, click the Datasource Name, then
click the Connection Pool tab, and enter 0 in the Initial
capacity field.
-
Ensure that an ONS daemon is running on your database servers at
all times. Start the ONS daemon on a database server by running the
onsctl command:
start
-
Log in to the Oracle WebLogic Server Administration Console.
-
If you have not already done so, in the Change Center of the
Administration Console, click Lock & Edit.
-
In the Domain Structure tree, expand Services, then select Data
Sources.
-
On the Summary of Data Sources page, click New and select GridLink Data
Source.
The Create a New JDBC GridLink Data Source page is displayed.
-
Enter the following information, then click Next.
-
Logical name for the datasource in the Name field. For example,
gridlink.
-
Name for JNDI. For example, jdbc/gridlink.
-
In the Transaction Options page, deselect Supports Global Transactions,
and click Next.
-
Select Enter individual listener information and click Next.
-
Enter the following connection properties:
-
Service Name: Enter the name of
the RAC service in the Service Name field. For example, enter
myService in Service Name.
Note -
The Oracle RAC Service name is defined on the database, and it
is not a fixed name.
-
Host Name: Enter the DNS name
or IP address of the server that hosts the database. For an Oracle
GridLink service-instance connection, this must be the same for each
data source in a given multi data source.
-
Port: Enter the port on which
the database server listens for connections requests.
-
Database User Name: Enter the
database user name. For example, myDataBase.
-
Password: Enter the password.
For example, myPassword1.
Confirm password and click Next.
Tip -
For more information, refer to the Oracle
Fusion Middleware Oracle WebLogic Server Administration Console
Online Help.
The console automatically generates the complete JDBC URL. For
example:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=left)(PORT=1234))(ADDRESS=(PROTOCOL=TCP)(HOST=right)(PORT=1234))(ADDRESS=(PROTOCOL=TCP)(HOST=center)(PORT=1234)))(CONNECT_DATA=(SERVICE_NAME=myService)))
-
On the Test GridLink Database Connection page, review the connection
parameters and click Test All Listeners.
Oracle WebLogic attempts to create a connection from the administration
server to the database. Results from the connection test are displayed at
the top of the page. If the test is unsuccessful, you should correct any
configuration errors and retry the test.
Click Next.
-
In the ONS Client Configuration page, do the following:
-
Select Fan Enabled to subscribe to and process FAN events.
-
In the ONS host and port fields, enter a comma-separated list of
ONS daemon listen addresses and ports for receiving ONS-based FAN
events.
You can use SCAN addresses to access FAN notifications.
-
Click Next.
-
On the Test ONS Client Configuration page, review the connection
parameters and click Test All ONS Nodes.
Click Next.
-
In the Select Targets page, select Dept1_Cluster1 as the target and All
Servers in the cluster.
-
Click Finish.
-
Click Activate Changes.
-
Configure SDP-enabled JDBC drivers for the cluster.
For instructions, see Configuring SDP-Enabled JDBC Drivers for
Dept1_Cluster1.