Oracle Database 11g XE Installation Steps

This article will discuss the Oracle Database 11g XE installation process on Windows 32bit operating system. Oracle Database 11g XE can be installed on Windows or linux operating systems. The installer can be downloaded from the Oracle website (www.oracle.com). For Windows operating system available 32bit and 64bit installer while for Linux operating system available 64bit installer. Before performing the installation of Oracle Database XE 11g R2 make sure the computer has a minimum specification which are 1GHz processor clock speed, 512MB RAM, and 2GB free space on the hard disk.

Here are the steps to install Oracle Database XE 11g:

1.       Download the Oracle DB 11g Express Edition installer from http://www.oracle.com/technetwork/products/express-edition/downloads/index.html. Select the installer for Windows x32.

2.       Extract the zip compression file in windows explorer then run the installer file (setup.exe)

The Preparing to Install page will appear, wait until the loading process completed

3.       After the InstallShield Wizard form appears, click the Next button at the bottom of the form

4.       Next, look at the License Agreement page, read carefully the contents of the rules set by Oracle. If you agree select the radio button I accept the terms in the license agreement then click Next.

Specify the installation location of Oracle Database XE (e.g. c: \ oraclexe \) then click Next button. If you want to change the installation location press the Browse button.

On the Specify Database Passwords page, set the password for SYS and SYSTEM users. SYS and SYSTEM users on Oracle databases are the highest-level privileges to perform management operations on Oracle Database. When finished enter the password click the Next button.

On the Summary page will be shown the location of Oracle Home and Oracle Base from Oracle Database 11g XE which has been successfully installed along with the list of ports used. Oracle Home is the main location (root) of Oracle products being installed, while Oracle Base is a location consisting of one or more Oracle Home. By default the Database Listener port is 1521 and the HTTP Listener port is 8080, both ports are important to keep in mind. The Database Listener port serves as an intermediary of database interaction with the client when the database on the server computer is accessed from the client computer (remote access).The HTTP Listener port is the port that is invoked when we interact with the Oracle DB XE 11g via the web browser. Click the Install button to begin the installation process.

After the installation completed, click the Finish button at the bottom of the form.

The installation process is now completed, check whether Oracle Database XE 11g is working or not. To check that the Oracle DB 11g XE is working and operate, login to SQLPlus by entering the SYSTEM as username and your defined password (the password that inputted on installation process) at the command prompt (cmd). Type the command SQLPLUS system / admin1 (system is the username that will login while admin1 is the password that has been set at the time of installation). The following illustrations verify whether the  Oracle DB XE 11g is successfully installed, if figure 1.9 found that means your Oracle Database XE has been operating properly. Next we will call SQL> symbols as sql prompt.

Thank You, Bobsis