Create Database Resource in DBAdapter in Oracle SOA11g Part 1

Step 1: Login to console
http://serverhost:7001/console
Step 2: Create Data Source
* Go to Services -> Data Sources

* Click New -> Generic Datasource

Name: mohanserver
JNDI Name: jdbc/mohanserver
Database Type: Oracle
and click Next.

* Select
Database Driver: Oracle's Driver (Thin XA) for Service connections; Verions:9.0.1 and later
and click Next.

* Click Next on Transaction Options screen.

* Enter Database connection properties:
Database Name: xe
Host Name: localhost
Port: 1521
Database User Name: soa (one which is already exist).
Password: soa
and click Next.

* Click Test Configuration. A green font message 'Connection test succeeded' should show up on
the top of the screen.



* Click Next.
* On Select Targets screen, check soa_server1 and click Finish.

Note: Next Steps is continued in Part-2.