Oracle XE 10g Windows Install - Video Walkthrough Tutorial
Filed Under Technical Tips // Tags: oracle xe, video training
This tutorial article is meant to provide a visual guide to the process of installing Oracle express edition (XE) onto a Windows XP Professional computer. The video below contains the actual tutorial, while this document provides additional information and clickable links to the required software.
High-Level Steps
- Ensure you are logged into Windows as a user with Administrator rights
- Add 127.0.0.1 to internet explorer intranet zone (0:40)
- Run windows installer (1:32)
- Navigate to xe administration web page to validate (5:10)
- Optionally enable HTTP access from remote machines (5:53)
The times in parenthesis are the approximate start times for that step in the video.
Note: The password we are using in this tutorial is “Consult1ng” (without the quotes), which we use in subsequent videos and tutorials.
Notes and Helpful Resources
You need to have a computer running either Windows XP Professional or Server 2003. Oracle XE will run on XP Home with some modifications and minor loss of features. XE can also be installed to many *nix platforms.
Hardware requirements: For the Windows installation, you need at least 512 MB or RAM, and 1.6 GB of free hard disk.
Software Download and Links
Following is the link to the download page for the XE software: Oracle XE Download
On this page you will see 3 downloads. You do need to be a member of the OTN (Oracle Technology Network), but that is free.
- OracleXE.exe: This is the server file for Western Languages
- **OracleXEUniv.exe: This is the Unicode server edition
- OracleXEClient: This is the client software package.
**This tutorial uses the OracleXEUniv.exe version. The Oracle client will only need to be installed on any remote machine that needs to connect to your XE database (not needed on the machine where you are actually installing the database).
Additional Oracle XE Documentation can be downloaded, including the ‘Installation Guide for Microsoft Windows‘ which is what this tutorial video is based off of.
Useful Hints
Before starting the installation, take a moment and determine a few of the following, it will help you later on.
- Password desired for SYS and SYSTEM.
- Any potential users, and what level of authority they may need.
- Installation space available on the computer.
- Potential add-ons (APEX, etc) to the base install.
- Is access going to be needed by other computers.
- Is secure communication from other computers required.
Note: Setting up XE with secure communication (HTTPS) is beyond the scope of this tutorial. We plan to create another guide for that soon, though, so check back or subscribe to our blog feeds.
Related Information:
- Install Oracle Apex 3.2 on XE and XP Pro - Video Walkthrough Tutorial This tutorial is a supplment to the install video linked to below. It takes you through the process of installing...
- APEX 3.2 Tutorial Preparation and OEHR Sample Data - Video Walkthrough This tutorial video and article is meant to help you setup your APEX installation so you can proceed through the...
- Oracle Express Edition (XE) 10g Windows Download The following are links to the download page for Oracle Database 10g Release 2 (10.2.0.1) Express Edition (XE) for Microsoft...
- Oracle APEX Advanced Tutorial 1 - Creating a Tabular Form - Video Walkthrough This tutorial is designed to walk you through section 2 of the Oracle APEX Advanced Tutorial, Creating a Tabular Form....
- Oracle APEX Tutorial 3 - Drilldown Report Part 1- Video Training This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a drilldown report...
- Oracle APEX Tutorial 8 - Up and Downloading Files - Part 1 - Video Training Reports and data entry constitue the bulk of what most of these tutorials cover, and what many businesses need. However,...
- BPA 10.1.3.4 Windows Install with XE I have just had a heck of a time with installing BPA (Architect) Evaluation on a Windows Server 2003 machine....
- Oracle APEX Tutorial 9 - JavaScript - Video Training JavaScript is everywhere on the Internet today. Even if you don't realize it, this handy little scripting tool has become...

Aug 25, 2009
i tried this out and
installation process did not report any visible errors.
however, when i launched the application express homepage, i could not connect to the webpage.
i searched from the forums and found out that the installation logs could be used to diagnose the problem.
my cloneDBCreation.log has this entry.
SQL> Create controlfile reuse set database “XE”
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 16
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 Datafile
8 ‘C:\oraclexe\oradata\XE\system.dbf’,
9 ‘C:\oraclexe\oradata\XE\undo.dbf’,
10 ‘C:\oraclexe\oradata\XE\sysaux.dbf’,
11 ‘C:\oraclexe\oradata\XE\users.dbf’
12 LOGFILE
13 GROUP 1 SIZE 51200K,
14 GROUP 2 SIZE 51200K,
15 RESETLOGS;
Create controlfile reuse set database “XE”
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file ‘C:\oraclexe\oradata\XE\sysaux.dbf’
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
how could this file be missing?
i just ran the installation straight from the installer OracleXEUniv.exe 211,849KB download.
help please.
tnx
raul
Sep 08, 2009
Awsome job!! God bless!!