“Oracle Database 11g Express Edition” – Installation on Windows

Background

A week ago today, DH called me to speak about an interoperability problem he was facing accessing data on an Oracle DB from SQL Server.

The tool he was using is Microsoft’s Business Intelligence Development ( BIDs)

We tried to debug the problem over phone and email.

Did not get far and so I ended up connecting remotely to his machine and found a workaround using Microsoft Linked Server.

The problem was vexing enough and I wanted to reproduce locally in our Lab environment.

And, so here we go downloading and installing a Light version of the Oracle DB Engine, Oracle Express.

Download

Overview

To download please visit Oracle’s Express Edition Overview page here.

The current version is Express Edition 11g Release 2.

Download

Image

Textual

  1. Oracle Database Express Edition 11g Release 2 for Windows x64
  2. Oracle Database Express Edition 11g Release 2 for Windows x32
  3. Oracle Database Express Edition 11g Release 2 for Linux x64

 

Installation

Image

Welcome

License Agreement

Choose Destination Location

Original

Revised

Explanation
  1. Changed destination folder from C:\Oraclexe to D:\Oraclexe
  2. Space Required to 631124 K ( 630 MB)

 

Specify Database Passwords

Original

Revised

Explanation
  1. Enter password for the System Account
    • Btw, the system accounts are
      • SYS
      • SYSTEM

Summary

Image

Explanation
  1. Oracle Database Listener :- 1521
  2. Oracle Services for Microsoft Transaction Server :- 2030
  3. Oracle HTTP Listener :- 8080

Complete

Image

3 thoughts on ““Oracle Database 11g Express Edition” – Installation on Windows

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s