Installation Guide for Oracle Self-Service E-Billing > Configuring Oracle WebLogic > Process of Configuring Oracle WebLogic for the Command Center Application >
Configuring JDBC Resources for the Command Center
You must configure JDBC resources for the Command Center application deployed with Oracle WebLogic, using the Oracle WebLogic Administration Console. You must configure the following:
- Data sources
- Connection pools
This task is a step in Process of Configuring Oracle WebLogic for the Command Center Application. Configuring Data Sources for the Command Center Domain
You must configure the following data sources for running Oracle Self-Service E-Billing jobs and the reporting application:
- edxAdminDataSource
- edxXMADataSource
- reportDataSource
- edxLoggerDataSource
- edxMessagingDataSource
- edxUserDataSource
To create data sources for the Command Center domain
- Start the newly created Command Center domain, and open the Oracle WebLogic Administration Console in a browser. The default URL
http:// Server_Name : Server_Port /console
where:
- Server_Name is the name of the server with the Command Center domain.
- Server_Port is the port number of the Command Center domain server.
- Log on to the Oracle WebLogic Administration Console, using the user name and password defined when the domain was created.
- Click the Data Sources link under JDBC in the services section.
- Click New to create a new data source.
- Enter the data source name and the JNDI name.
- For each data source, select the database type as Oracle and enter other settings as shown in the following table. Be sure to select the correct version of the driver for your database version, including patches. Click Next.
|
|
|
|
|
edxAdminDataSource |
edx.databasePool |
Oracle Driver (Thin) |
Emulate Two-Phase Commit |
OLTP/Hostname:ListenPort:SID |
edxXMADataSource |
edx.xma.database Pool |
Oracle Driver (Thin XA) |
Not applicable |
OLTP/Hostname:ListenPort:SID |
reportDataSource |
edx.report.databasePool |
Oracle Driver (Thin XA) |
Not applicable |
OLAP/Hostname:ListenPort:SID |
edxLoggerDataSource |
edx.logger.databasePool |
Oracle Driver (Thin) |
Emulate Two-Phase Commit |
OLTP/Hostname:ListenPort:SID |
edxMessagingDataSource |
edx.messaging. databasePool |
Oracle Driver (Thin XA) |
Not applicable |
OLTP/Hostname:ListenPort:SID |
edxUserDataSource |
edx.user.database Pool |
Oracle Driver (Thin) |
Emulate Two-Phase Commit |
OLTP/Hostname:ListenPort:SID |
- Select Supports Global Transactions for all Data Sources, select the corresponding transaction option, then click Next.
- On the Connections Properties page, provide the correct values for the following properties.
|
|
Database Name |
Your Oracle Database Alias Name |
Host Name |
Your Oracle Database Server Host Name |
Port |
Database Server Listening Port |
Database User Name |
Your Oracle Database User Name |
Password |
Your Oracle Database Password |
- Click Test Configuration to test whether the database connection is configured correctly. Click Next.
- Target the data source to the Command Center domain (default is AdminServer), then click Finish.
- Click Activate Changes to save the changes.
Configuring Connection Pools for the Command Center Domain
You must configure connection pools for each JDBC data source you created. To configure the connection pools for Command Center
- Go to the Summary of JDBC Data Sources.
- Click any data source name link.
- On the Connection Pool tab, enter the values for the connection pool settings for each JDBC data source you created.
|
|
Initial Capacity |
5 |
Maximum Capacity |
20 |
Capacity Increment |
5 |
Statement Cache Type |
FIXED |
Statement Cache Size |
300 |
Text Connections on Reserve |
Selected |
Test Frequency |
120 |
Test Table Name |
DUAL |
Shrink Frequency |
15 |
Login Delay |
1 |
|