If you are you using 10.1.3, please refer to "How to create a Data Source in OracleAS 10g 10.1.3".

1. If the SCOTT user is locked or has not been created yet, then unlock/create it
2. Go to Application Server Control for your Middle-Tier
3. In the System Components section, click on "home"
4. Select Administration
5. Select Data Sources
6. Leave the OracleDS entry selected and click Create Like

7. Create Like Data Source:
   • as Name, enter ScottDS
   • as JDBC URL, enter jdbc:oracle:thin:@localhost:1521:ORCL (if your database listener port and SID is not 1521 and ORCL (respectively), then modify the JDBC URL accordingly)
   • as Schema, enter scott
   • as Username, enter scott
   • check the Use Cleartext Password field
   • as Password, enter tiger
   • JNDI Locations:
     • as Location, enter jdbc/ScottCoreDS
     • as Transactional(XA) Location, enter jdbc/xa/ScottXADS
     • as EJB Location, enter jdbc/ScottDS

8. Click Create
9. Click Yes to restart the OC4J Container
10. When you get a confirmation that "home" has been restarted, click OK