Oracle SWAT - ECMEA 1

Lab 1: Installation of Oracle JDeveloper and Oracle Database XE

(15 minutes)

Objectives

At the end of this exercise, you will have the following products installed and configured:

1. Oracle Database XE 2. Oracle JDeveloper

Overview

In order to start using Oracle ADF you need to install Oracle JDeveloper the development

tool of choice for Oracle Fusion Middleware products.

We also need an Oracle database and the sample HR schema that comes with it in order

to complete the labs.

Detailed Instructions

Step 1 : Installing Oracle Database XE

1- If you have an Oracle Database with the HR schema already installed, then you dont need to install Oracle XE, if you dont then please continue.

2- Run the database installer by executing OracleXE.exe under the following folder : Workshop/Resources/Products/

3- Follow the installation wizard until you reach the Specify Database Passwords screen, please use welcome1 as the password for the database.

Oracle SWAT - ECMEA 2

4- Complete the installation. 5- By default Oracle XE will use port 1521 , however if you have another database

already installed, the installer will ask you to specify another port:

Step 2 : Installing Oracle JDeveloper

1- Run the installer of Oracle JDev by executing OracleJDev.exe under the following folder : Workshop/Resources/Products/

2- Follow the installation wizard and complete the Installation.

Step 3 : Creating the DB Connection to the HR Schema

1- Before creating the connection to the HR schema we need first to unlock the schema:

a. Open the command line window b. Connect to the database using : sqlplus system/welcome1 c. Unlock the HR schema : alter user hr identified by hr account unlock; d. The HR schema is now unlocked and we can connect to it using the

username/password hr/hr

2- Go to the start menu and start JDeveloper

Oracle SWAT - ECMEA 3

3- From the Select Role window keep the default and click OK.

4- Open the database navigator:

5- Create new Connection

6- We will connect to the HR schema :