- If the SCOTT user is locked or has not been created yet, then unlock/create it
- Go to Application Server Control for your Middle-Tier
- In the Members section, click on "home"
- Select Administration
- Select JDBC Resources
- Under Data Sources, click Create
- Under Data Source Type, select Native Data Source
- Click Continue
- Create Native Data Source:
- as Name, enter ScottDS
- as JNDI Location, enter jdbc/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 Username, enter scott
- check the Use Cleartext Password field
- as Password, enter tiger
- Click Test Connection
- Click Test
- Click Finish
- Restart the OC4J Container