Archived: Oracle Database Express Edition (XE) Installation

JDBC for Oracle - Herong's Tutorial Examples

∟Archived: Oracle Database Express Edition (XE) Installation

This section describes how to download, install, and start Oracle Database 11g/10g Express Edition (XE).

Oracle offers free releases called Oracle Database Express Edition (XE), which are great starter databases for any Java JDBC developers who wants to try it on their own system.

Here is what I did to download and install Oracle Database 11g Express Edition on my Windows XP computer:

1. Go to Oracle Express Edition Website at https://www.oracle.com/database/technologies/appdev/xe.html.

2. Click on "Downloads" and select "Oracle Database Express Edition 11g Release 2 for Windows x32" to start the download.

3. Save the downloaded file, OracleXE112_Win32.zip (216,933,372 bytes), to \temp folder.

4. Unzip the downloaded file to \temp\oracle folder.

5. Double click the \temp\oracle\DISK1\setup.exe. The installation wizard starts. Follow instructions given by the wizard to continue.

6. Enter "HerongY@ng" as admin password, and select \local\oraclexe as the installation destination folder. You should see the following on the confirmation screen:

Destination Folder: C:\local\orablexe\
Oracle Home: C:\local\orablexe\app\oracle\product\11.2.0\server\
Oracle Base:C:\local\orablexe\
Port for 'Oracle Database Listener': 1521
Port for 'Oracle Services for Microsoft Transaction Server': 2030
Port for 'Oracle HTTP Listener': 8080

7. Click "Next" to finish the installation.

To start Oracle XE server, Click on Start > All Programs > Oracle Database 11g Express Edition > Start Database.

To stop Oracle XE server, Click on Start > All Programs > Oracle Database 11g Express Edition > Stop Database.

Here is what I did to download and install Oracle Database 10g Express Edition on my Windows XP computer:

1. Go to the Oracle Express Edition page.

2. Download the Oracle Database 10g Express Edition (Universal) - Multi-byte Unicode database for all language deployment, with the Database Homepage user interface available in the following languages: Brazilian Portuguese, Chinese (Simplified and Traditional), English, French, German, Italian, Japanese, Korean and Spanish.

3. Save the download file, OracleXEUniv.exe (216,933,372 bytes), to a temporary directory.

4. Double click on OracleXEUniv.exe. Follow the installation wizard to finish the installation. Remember to change the destination directory, set the SYTEM password and take some notes like:

SYSTEM password: Yang
Destination Folder: C:\local\oraclexe\
Port for 'Oracle Database Listener': 1521
Port for 'Oracle Services for Microsoft Transaction Server': 2030
Port for HTTP Listener: 8080