Database Reference
In-Depth Information
worthwhile to test and ensure that the data source is working properly by per-
forming the following steps:
1.
Log in to the Oracle WebLogic Administrator Console.
2.
Click on
Data Sources
.
3.
Click on the data source name (for example,
SOADataSource)
.
4.
Navigate to
Monitoring
|
Testing
.
5.
Select the radio button and click on the
Test Data Source
button.
6.
If the connection is working (that is, the data source is able to access the
database at the host, port, database name, username, and password), the
following message will appear on the top of the page:
Test of [DataSource] on server [soa_server] was successful
.
Monitoring from the console may involve too many navigation steps and be cum-
bersome at times. You may want to consider creating scripts that can be ex-
ecuted on the go to obtain the health of all the data sources running on the infra-
structure. For proactive monitoring purposes, you may even create a cron job to
regularly check your data source statistics, since any failure of the data source
will eventually lead to the failure of the entire infrastructure.
