SOA Datasource Configuration

1. Open the Web Logic Server (WLS) console (http://soa-as-vip.soa-{deployment-environment}.com:7002/console) and login using an admin account
2. On the left navigation bar, click Services > JDBC > Data Sources.
3. In the data source table, click New.
4. Enter the data source information
5.1 Name: jdbc/dart_application_csvc/dart_application_csvc
5.2 JNDI Name: jdbc/dart_application_csvc/dart_application_csvc
5.3 Database Type: Oracle
5.4 Check the Database driver is the  correct driver: Oracle’s Driver (Thin) for Instance connections
6. Click Next
7. Untick the Supports Global Transactions checkbox.
8. Click Next
9. Enter the database information based on the database configuration details table in 4.1.
10.1 Database Name: Relevant environment database SID (Column SID in the table)
10.2 Host name: Relevant environment database host name (Column Host in the table)
10.3 Port: Relevant environment database port number (Column Port in the table)
10.4 Database user name: DART_APP_CSVC
10.5 Database user password: Consult DBA for details
11. Click Next
12. Check the entered details and then click Test Configuration. Confirm success message at top of page.
13. Click Next
15. Select the target cluster (soa_cluster) where the SOA component is running.
15. Click Finish