Chapter 2 - eiu.edu

Chapter 2

Installation of Oracle Enterprise Edition


The following chapter describes ways to install Oracle, Oracle 9i and
Oracle 10g on Windows platform, as specific examples. Oracle 8i, 9i, and
10g can be downloaded from Oracle Technology Network
(http://otn.oracle.com) and can be installed as personal, standard or
enterprise edition. All three editions will work for the purpose of this
course even though there might be slight difference. Please also note the
description may not be exactly the same due to constant software update.


For students starting Spring 2004, please note the CD that came with
your book does not contain the Oracle 9i or 10g database. Please do not use
it. Instead, download your database software from Oracle Technology Network
(http://otn.oracle.com).


This chapter teaches you how to install a typical Enterprise Edition
Oracle database for Windows. This chapter also explains the steps necessary
for preparing to use the practice exercises in this courseware.





Overview and Planning for Oracle Installation


To successfully install Oracle Enterprise Edition for Windows, you
need to take the time to understand and plan for the installation process.
You should have a good understanding of the products, product options, and
installation options that will be available to you during an installation
session. Once you decide exactly what you are going to install, make sure
that your system meets the necessary requirements to complete the
installation, and that you have all the information that you will need as
you proceed through the installation. The next several sections provide you
with an overview of what you should understand and the information that you
should have available before actually installing Oracle Enterprise Edition
for Windows.






The Focus of This Chapter


When you install Oracle Enterprise Edition on Windows, you can perform
a Typical, Minimal, or Custom installation. This chapter teaches you how to
accomplish a "Typical Installation" of Oracle Enterprise Edition on
Windows. Furthermore, the subsequent sections in this chapter implicitly
focus on performing a "Typical Installation". Should you need help with
other types of installation options, please read your Oracle documentation.








The Oracle Universal Installer


To install Oracle on your computer, you will use the Oracle Universal
Installer (henceforth referred to in this book as "the installer"). The
installer is a Java-based program that looks and operates the same, no
matter what operating system you happen to be using. The installer is the
tool that you use to install various Oracle products onto your computer,
orand subsequently to remove them, if necessary





Installation Choices

The Oracle Universal Installer guides you through an interview phase that
asks you to specify your choices for installation and database creation.
The exact sequence of pages depends on your platform. All platforms include
the following choices: You can install one of the following:
. Oracle Enterprise Edition-Oracle's most full featured
database product providing data management for high-end
applications.
. Oracle Standard Edition-A less-expensive and somewhat
scaled down version of the Oracle database suitable for
workgroup or department level applications
. Custom Install-Allows you to customize the Enterprise
Edition by selecting products to install. Do this if you
want to add a component to your database that would not
normally be installed or prevent certain components from
being installed.

Oracle's Home Location


One of the first things to decide before you install Oracle is where
you want the software and related files to reside on your computer. In
general, you can pick any uncompressed drive or partition on a hard disk of
your computer that has enough at least 720MB of available disk space. The
root directory where you install Oracle is referred to in both the Oracle
documentation and this book as the Oracle home location, and is often
denoted in file and directory specifications as Oracle_Home (or something
similar).



NOTE


Some previous releases of Oracle required you to configure either a
system variable named ORACLE_HOME or your system's PATH variable to
point to the Oracle home location. These steps are not required during
or subsequent to the installation of Oracle Enterprise Edition for
Windows.







The Starter Database


During a Typical installation, the installer will build a starter
database on your computer after all of the software has been installed. The
practice exercises in this chapter assume the presence of the starter
database and use it extensively to help you quickly learn the fundamentals
of working with Oracle


NOTE


If you choose a Minimal or Custom install, a starter database might
not be installed on your system. See your Oracle documentation for
more information.


Before you start an installation, you should pick a name that you will
use for the starter database. If you want your database name to match the
results shown in many of this book's hands-on exercises, you should choose
to name the starter database "oracle."


Additionally, the installer will prompt you to enter the network
location of your computer so that it can configure several network-related
settings, including the starter database's name in the network. In general,
most systems use standard dot notation to indicate the network node and the
domains that encompass the node for your computer. If you are not familiar
with network naming schemes and the network name of your computer, take
sometime to read your Windows NT documentation regarding this topic.


Oracle Documentation


With any type of installation, you will have the option of installing
the Oracle generic documentation set and Windows NT-specific documentation
set on your computer's hard disk. If the necessary disk space is available,
it is I highly recommended that you install the documentation on your hard
disk for ease of use-otherwise, you will have to insert the Oracle CD-ROM
into your computer every time you want to refer to the documentation.


Although this chapter teaches you how to complete a Typical
installation of Oracle Enterprise Edition for Windows NT, you would also be
wise to review the latest Oracle installation documentation available at
http://otn.oracle.com


System Requirements


The following table briefly explains the minimum system requirements
necessary to perform a Typical installation of the copy of Oracle
Enterprise Edition for Windows. Ensure that your system can meet these
requirements before proceeding with the installation steps outlined later
in this chapter.


System Component Requirement


| |Oracle 8i |Oracle 9i |Oracle 10g |
|Operating |Windows NT 4.0, |Windows 2000 |Windows 2000, |
|System |Workstation or Server, | |Windows Server 2003,|
| |Service Pack 3 or | |Windows XP Pro |
| |greater | | |
|Processor |Pentium 166 MHz |Pentium 200 MHz |Pentium 300MHz |
|Web Bbrowser |Support for Java and |Support for Java and |Support for Java and|
| |frames (for |frames (for |frames (for |
| |documentation) |documentation) |documentation) |
|Physical |128MB or more for |128 MB or more (256 |512 MB or more |
|Mmemory (RAM) |Typical installation |Recommended) | |
| |(recommended) | | |
|Virtual Memory|256 MB or more |400 MB or more |1 GB or more |
|Disk space |720MB or more for |140 MB on the System |2.1 GB for the |
| |Typical installation, |Drive |Oracle software and |
| |including documentation|plus 4.5 GB for the |Sample Schema |
| |and starter database |Oracle Home Drive (FAT)|Database |
| |(recommended) | | |
| |Non-compressed drive or|or 2.8 GB for the | |
| |partition |Oracle Home Drive | |
| | |(NTFS) | |
|Temporary |100 MB |200 MB |400 MB |
|working space | | | |
|Monitor |Although Oracle |256 color |256 color |
|settings |documentation states | | |
| |that at least a | | |
| |16-color setting is | | |
| |required, a | | |
| |256-color setting is | | |
| |recommended | | |




Installing Oracle


At this point, you are ready to begin installing Oracle Enterprise
E