1. If the SCOTT user is locked or has not been created yet, then unlock/create it

  2. Open the Administrative console (e.g. https://localhost:9043/ibm/console/logon.jsp)
  3. Expand Resources
  4. Expand JDBC
  5. Click Data sources
  6. In the scope dropdown list, select Cell=donaldCell01
  7. Click New
  8. Click create a new J2C authentication alias
  9. Click New
  10. Click OK
  11. Click Save

  12. Click Data sources
  13. Click New
  14. As Data source name, enter ScottDS
  15. As JNDI name, enter jdbc/ScottDS
  16. From the Component-managed authentication alias and XA recovery authentication alias dropdown, select donaldCellManager01/orcl.scott
  17. Click Next
  18. Check Create new JDBC provider (already checked)
  19. Click Next
  20. From the Database type dropdown, select Oracle
  21. From the Implementation type dropdown, select Connection pool data source
  22. As Name, enter Oracle JDBC Driver 10.2
  23. Click Next
  24. As Directory location, enter D:\ora102db\jdbc\lib
  25. Click Next
  26. As 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)
  27. From the Data store helper class name, select Oracle10g data store helper
  28. Click Next
  29. Click Finish
  30. Click Save

  31. Click the name of the new connection (ScottDS)
  32. Click Test Connection - you should see the message "The test connection operation for data source ScottDS on server dmgr at node donaldCellManager01 was successful."

    If your Oracle Database responds with the error message "Locale not recognized", then add "-Duser.language=en" to the Generic JVM arguments