Adding and Configuring WebLogic Server Data Sources
When you run the TMS Installer, it sets up a connection or data source, which is used by TMS Reports generation, from the WebLogic Server to the default database.
If you plan to use more than one database, you must create a data source for each additional database.
Note:
In addition, you must modify tnsnames.ora at <ORACLE_HOME>\network\admin and <ORACLE_HOME>\user_projects\domains\FRDomain\config\fmwconfig. Ensure that it contains an entry for each database.
It is recommended to maintain a master tnsnames.ora file and copy it to each location—database and application servers— whenever you add a database.
For more information, see:
- Add Data Sources
- Change Data Source Account Password
- Configure Maximum Connections
- Configure Inactive Connection Timeout
Parent topic: Administration
Add Data Sources
Go through these instructions for one data source at a time.
Parent topic: Adding and Configuring WebLogic Server Data Sources
Change Data Source Account Password
After changing the password for tmsproxy account on the database, you need to update the password of the account on the data source of the WebLogic too.
-
Log in to the WebLogic Server Administration Console at:
http://host:7101/console/login/LoginForm.jsp
-
Select Services, Data Sources, and then select the data source whose password you want to modify.
-
Select the Connection Pool tab, and click Lock & Edit.
-
Scroll down to find the password field and enter the new password.
-
Re-enter the password in the Confirm Password field.
-
Save.
-
Activate your changes.
You must then restart the OPA Server:
- In the same OPA domain WebLogic Server Administration Console, click on Servers, then the Control tab.
- Select managed server <server_name>_OPA_1, and then Shutdown - Force Shutdown now.
- Click Refresh to ensure the State changes to Shutdown.
- Select managed server <server_name>_OPA_1, and then Start.
- Click Refresh to see the State change to Running.
Parent topic: Adding and Configuring WebLogic Server Data Sources
Configure Maximum Connections
By default, the value for the Maximum Capacity parameter for each data source, which determines the maximum number of concurrent connections, is 15.
The value for the Maximum Capacity parameter should be equal to or greater than the maximum number of concurrent users you expect for TMS Reports.
To change this value:
-
Log in to the WebLogic Server Administration Console at:
http://host:7101/console/login/LoginForm.jsp
-
Select Services, Data Sources, then select the data source whose setting you want to modify. For example, DS_1_tms for TMS or DS_1_ops for OPA (TMS reports).
-
Click the Connection Pool tab, and then click Lock & Edit.
-
Scroll down to find the parameter Maximum Capacity.
-
Enter a value as described above.
-
Save.
-
Activate your changes.
You must then restart the OPA Server:
- In the same OPA domain WLS Administration Console, click on Servers, then the Control tab.
- Select the managed server <server_name>_OPA_1, and then Shutdown - Force Shutdown now.
- Click Refresh to ensure the State changes to Shutdown.
- Select the managed server <server_name>_OPA_1, and then Start.
- Click Refresh to see the State change to Running.
Parent topic: Adding and Configuring WebLogic Server Data Sources
Configure Inactive Connection Timeout
To ensure that a connection is available for a user who needs to run a report, change the default setting of the Inactive Connection Timeout of 0 to 5 or a similar value. This is the number of seconds of inactivity that is allowed before the connection is made available to another user. If set to zero, the feature is disabled.
To change this value:
-
Log in to the OPA domain WebLogic Server Administration Console at:
http://host:7101/console/login/LoginForm.jsp
-
Select Data Sources, then select the data source whose setting you want to modify.
-
Click the Connection Pool tab, and then click Lock & Edit.
-
Scroll down to find the parameter Inactive Connection Timeout.
-
Enter a value; for example,
5
. -
Save.
-
Activate your changes.
You must then restart the OPA Server:
- In the same OPA domain WLS Administration Console, click on Servers, then the Control tab.
- Select the managed server <server_name>_OPA_1, and then Shutdown - Force Shutdown now.
- Click Refresh to ensure the State changes to Shutdown.
- Select the managed server <server_name>_OPA_1, and then Start.
- Click Refresh to see the State change to Running.
Parent topic: Adding and Configuring WebLogic Server Data Sources