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

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

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

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Oracle Express Edition Installation on Windows

 Oracle JDBC Drivers

 Oracle - Reference Implementation of JdbcRowSet

 Oracle - PreparedStatement

 Oracle - JBDC CallableStatement

 Oracle CLOB (Character Large Object) - TEXT

 Oracle BLOB (Binary Large Object) - BLOB

Archived Tutorials

 Archived: Downloading and Installing JDK on Windows

 Archived: Java SE 8 Installation

 Archived: Java SE 1.6 Update 2 Installation

 Archived: JDK 1.6 Documentation Installation

Archived: Oracle Database Express Edition (XE) Installation

 Archived: Accessing Oracle Server through Web Interface

 Archived: Creating Oracle Database Users

 Archived: SQL*Plus - Oracle Command Line Interface

 Archived: JDBC Thin Client-Side Driver Installation

 References

 Full Version in PDF/EPUB