Oracle XE 10g Windows Install - Video Walkthrough Tutorial

By M&S Consulting (Kevin) on May 25th, 2009
Filed Under Technical Tips // Tags: ,

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.

YouTube Preview Image

High-Level Steps

  1. Ensure you are logged into Windows as a user with Administrator rights
  2. Add 127.0.0.1 to internet explorer intranet zone (0:40)
  3. Run windows installer (1:32)
  4. Navigate to xe administration web page to validate (5:10)
  5. 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.

Oracle XE Download article

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.

Bookmark and Share

Related Information:

  1. 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...
  2. 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...
  3. 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...
  4. 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....
  5. 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...
  6. 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,...
  7. 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....
  8. Oracle Client Download (10g Windows Client)
    Following is the link to the Oracle 10g Release 2 Client for Windows: http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html As of this writing (in Januray...

3 Responses to “Oracle XE 10g Windows Install - Video Walkthrough Tutorial”

  1. raul
    Aug 25, 2009
    Reply

    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


  2. Raymond
    Sep 08, 2009
    Reply

    Awsome job!! God bless!!


  3. SaintClair
    Apr 16, 2010
    Reply

    Thanks a million for sharing your knowledge. God richly bless YOU and the entire MSConsulting.



Leave a Reply


Archives

Recent Comments

  • Kavitha Muniraj said: Hi, Could you please send a script which checks the status of forms and reports of oracle...
  • Siddharth said: Hey thanks a lot !! Have been lookin all over for this :) My PC may not be able t handle FlashBuilder...
  • Cyrex said: Hey man why I cant install Apex 4? is there anyone can help me.,?
  • sharanabasava said: ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; Sir,I...
  • Huub Vankan said: Thanks for this easy solution. Indeed strange that is does not work in the (x86) folder….

Calendar

July 2010
M T W T F S S
« Jun    
 1234
567891011
12131415161718
19202122232425
262728293031  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service