MODULE OF INSTRUCTION

Oracle Database Installation Guide

Welcome to the second module of this course. For this lesson, we will
discuss the task of Database Administrator, System requirement and
Installation procedure.

Before a student may proceed on the next chapter installing this

software Oracle Database 11g is a prerequisite. Student need to create
an account to www.oracle.com in order to download the 11g database
software, moreover without installing the software may hinder the
student to complete the course due to activity file for manual grading
are included in this course.

Oracle Database 11g

This course used the Oracle Database 11g Express Edition (Oracle
Database XE) is an entry-level, small-footprint database based on the
Oracle Database 11g Release 2 code base. It's free to develop, deploy,
and distribute; fast to download; and simple to administer. At the end
of the lesson the student should be able to:

• Describe his/her role as a database administrator (DBA) and

explain typical tasks and tools.

• Plan an Oracle software installation.

• Install the Oracle database software.

The task of a database administor

The approach for designing, implementing, and maintaining an Oracle

database involves the following tasks:

1. Evaluating the database server hardware

2. Installing the Oracle software
3. Planning the database and security strategy
4. Creating, migrating, and opening the database
5. Backing up the database
6. Enrolling system users and planning for their Oracle
Network access.
7. Implementing the database design
8. Recovering from database failure

Database Management System 2 1

Week 2 Oracle Database 11g Installation Guide

9. Monitoring database performance

Tools for Administering

1. Oracle Universal Installer

2. Database Configuration Assistant
3. Database Upgrade Assistant
4. Oracle Net Manager
5. Oracle Net Configuration Assistant
6. Oracle Enterprise Manager
7. Server Control Utility
8. Recovery Manager
9. SQL*Loader

Consideration guideline when planning to install Oracle Database 11g

• What Oracle software are you installing?

• Does the hardware involved meet the minimum required

specifications?

• Is there a recommended order of installation when multiple

products are involved?

• Are there prerequisite steps that must be performed by

someone other than the DBA?

System Requirements

1. Memory requirements:

 1 GB for the database instance with Oracle Enterprise

 Manager Database Control
 1.5 GB for the ASM instance and Oracle Restart
2. Disk space requirements

 3 GB of swap space (based on 2 GB RAM)

 1 GB of disk space in the /tmp directory
 3.8 GB for the Oracle Database software
 4.5 GB for the Grid Infrastructure software
 1.7 GB for the preconfigured database (optional)
 3.4 GB for the fast recovery area (optional)

2
MODULE OF INSTRUCTION

3. Operating system

Preparing the Operating System

Create the required operating system users and groups:

– Groups:
– oinstall
– dba
Optional groups (if doing separation of duty across multiple users):

– oper
– asmdba
– asmoper
– asmadmin
• Software owner, usually oracle

• Can create multiple users for multiple product installations

Setting environment Variables:

Oracle environment variables:

1. ORACLE_BASE: Base of the Oracle directory structure.

 Recommended to set this before installation.

2. ORACLE_HOME: The environment in which Oracle

products run. Not required before installation if
ORACLE_BASE is set.

3. ORACLE_SID: Not required before installation, but useful

afterwards for ease of interaction with a particular instance

4. NLS_LANG: Optional environment variable that controls

language, territory, and client character set settings

Requirements:

• Adequate temporary space

• 64-bit versus 32-bit issues
• Correct operating system (OS)
• OS patch level

Database Management System 2 3

Week 2 Oracle Database 11g Installation Guide

• System packages
• System and kernel parameters
• X Server permissions
• Sufficient swapping
• ORACLE_HOME status

Installation Guide:

Step 1:

• Download Oracle Database thru www.oracle.com

• Click on License Agreement
• Choose the type of Operating system used.

Step 2:

• If with existing oracle account provide information on the left

side then click sign in
• If a new user click the CREATE ACCOUNT

Step 3:

• Fill up the form with necessary information mark in * are

required field.
• Click Submit

4
MODULE OF INSTRUCTION

Step 3:

• Once the account is created open your email to confirm the

verification code sent by Oracle.

Step 4:

• Verify the link sent by oracle

Step 5:
 Once verified the downloading the Oracle will start

Database Management System 2 5

Week 2 Oracle Database 11g Installation Guide

Step 6:

 When download is completed double click the rar file >

Click on DISK1>followed by setup.exe
 Clicking the setup.exe will automatically extract the file
downloaded file.

6
MODULE OF INSTRUCTION

Step 7:

 Wait the installation wizard to finish extracting the Oracle

Database 11Express Edition

Database Management System 2 7

Week 2 Oracle Database 11g Installation Guide

 Once done click Next

 Accept the license agreement

8
MODULE OF INSTRUCTION

 Choose location where to install the software, or you may use

the default drive.

 Set you global password: suggested is oracle

Note: for uniformity student are required to follow the
suggested username and password in order to follow on the
succeeding examples.

Database Management System 2 9

Week 2 Oracle Database 11g Installation Guide

 Wait the setting to check all the required setting environment

 Click Finish

10
MODULE OF INSTRUCTION

Note:
1. After clicking the finish button, locate the Oracle 11g
Express edition Folder found on the start menu of your
Operating system.
2. Then click the folder, click the PL/SQL Command Line.
3. When the CMD is open try to log-in using the username
and password set during installation.
4. Type in Connect then click enter
5. Then type the password: oracle (note typing the password
is hidden on the screen)
You must have the CONNECTED message. This means you
successfully log-in in Oracle using the PL/SQL command line.

Lesson Summary:
Before preceding with the next Chapters the student should
finished the following:
 Create Oracle Account – www.oracle.com
 Successfully Install Oracle Database 11g Express
Edition
 Able to establish as user Connection at isqlplus using:
CONNECT
USERNAME: SYSTEM (Global Connection to Oracle)
PASSWORD: oracle (password inputted by the student during
installation)

Database Management System 2 11

Week 2 Oracle Database 11g Installation Guide

Glossary
 NLS_LANG: Optional environment variable that controls
language, territory, and client character set settings

 ORACLE_BASE: Base of the Oracle directory structure.

Recommended to set this before installation.

 ORACLE_HOME: The environment in which Oracle

products run. Not required before installation if
ORACLE_BASE is set.

 ORACLE_SID: Not required before installation, but useful

afterwards for ease of interaction with a particular instance

References
Textbook:
 Oracle Database 11g 2nd Edition K Gopalakrishnan (
2012)

References:
 Carlos, Peter (2009). Database Systems
 Connoly, Thomas & Begg, Carolyn (2010). Database
Systems : A practical approach to design,
implementation and management
 Sciore, Edward (2009). Database Design and
Implementation
 Bulusu, Lakshman (2008). Oracle PL/SQL : Expert
Techniques for Developers and Database
Administrators
 Loshin, David (2008). Master Data Management

Other Suggested Readings (e.g. periodicals, articles, websites, IT

applications/software, etc.):
 www.oracle.com
 www.apex.oracle.com
 SQL Tutorial. In ws3schools, Retrieved from
http://www.w3schools.com/sql/default.asp

12
MODULE OF INSTRUCTION

 SQL. In Encyclopedia Britannica, Retrieved from

http://www.britannica.com/EBchecked/topic/569684/S
QL
 Database Administration. In Encyclopedia.com,
Retrieved from
http://www.encyclopedia.com/topic/Database_administ
ration.aspx
 SQL. In Encyclopedia.com, Retrieved from
http://www.encyclopedia.com/topic/SQL.aspxLearning
Icons

Database Management System 2 13