3 Installing Oracle Database

The Oracle Database software is available on disk (CD-ROM or DVD-ROM) or you can download it from the Oracle Technology Network (OTN) Web site. In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install the software. However, you can also use Oracle Universal Installer to complete non-interactive installations, without using the GUI.

This chapter describes how to install Oracle Database from the installation media or from a hard disk using Oracle Universal Installer. To install the software from a hard disk, you must either download it from OTN and unpack it, or copy it from the discs, if you have them.

This chapter contains these topics:

Before You Install Oracle Database
Reviewing Component-Specific Installation Guidelines
Installing With the Minimum Memory Requirements
Downloading Oracle Software from the OTN Web Site
Copying the Oracle Database Software to a Hard Disk
Installing the Oracle Database Software

See Also:

Chapter 1, " Oracle Database Installation Overview"
Chapter 2, " Oracle Database Preinstallation Requirements"
Appendix C, " Oracle Database Advanced Installation Topics" for information about noninteractive installations

3.1 Before You Install Oracle Database

Perform the following tasks before installing Oracle Database:

Review and satisfy applicable system and component requirements in Chapter 2, " Oracle Database Preinstallation Requirements" and "Reviewing Component-Specific Installation Guidelines" before running Oracle Universal Installer. Refer to "Installing With the Minimum Memory Requirements" if your system only meets the minimal memory requirements.

See Also:

"Upgrade Considerations" before running Oracle Universal Installer
"Pre-Installation Tasks for Installing RAC on Windows-Based Systems" in Oracle Real Application Clusters Installation and Configuration Guide before running Oracle Universal Installer

Log on as a member of the Administrators group to the computer on which to install Oracle components. Log on as a member of the Domain Administrators group if you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC).
Delete the ORACLE_HOME environment variable if it exists. Refer to your Microsoft online help for more information about deleting environment variables.

Note:
The ORACLE_HOME environment variable is automatically set in the registry. Manually setting this variable prevents installation.
Back up any databases to upgrade. Review "Upgrade Considerations".
If you are installing in an existing Oracle Database 10g release 1 (10.1) home, then stop all Oracle services. If any Oracle services (their names begin with "Ora") exist and have the status Started, then stop them. In particular, ensure that all Oracle listener services are stopped.

See Also:
Your Microsoft online help for more information about stopping services
Continue to the "Reviewing Component-Specific Installation Guidelines" section.

3.2 Installing With the Minimum Memory Requirements

Installations of Oracle Database on computers with 256 MB of RAM and 500 MB of virtual memory have the following limitations:

Computers with 256 MB of memory are not able to run Oracle Database Upgrade Assistant, Database Configuration Assistant, or Oracle Net Services Configuration Assistant during an Oracle Universal Installer installation session.
Depending on how many applications are running on the computer, you may need to further increase the paging file size or reduce the size of the System Global Area (SGA) if you run out of virtual memory. Note that if temporary files and the paging file are both stored on the same physical drive, then a situation can occur where the space requirements for one can limit the size of another. If your system has limited free space, then first install the Oracle Database software. After the installation is finished, create a database with Database Configuration Assistant.

On computer systems that barely meet the minimum memory and virtual memory requirements, 256 MB and 200 MB respectively, do not install the database. Follow these guidelines:

Select Basic Installation and deselect Create Starter Database.
Select Advanced Installation, select Do not create a starter database from the Select Database Configuration screen.
Select Advanced Installation, select the Custom installation type from the Select Installation Type screen, and select No on the Create Database screen when prompted to create the database.
Cancel Database Configuration Assistant from the Configuration Assistants screen.

After installation, run the appropriate configuration assistant for your needs:

To create a new database, run Database Configuration Assistant from the Start Menu. Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Configuration Assistant.
To upgrade an existing database, run Oracle Database Upgrade Assistant from the Start Menu. Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Upgrade Assistant.

3.3 Reviewing Component-Specific Installation Guidelines

Review the following guidelines before starting Oracle Universal Installer:

Oracle Universal Installer

Do not use Oracle Universal Installer from an earlier Oracle release to install components from this release.
Installations on a Cluster

Note:
Installing Oracle Real Application Clusters is not covered in this guide. Installation instructions are located in Oracle Real Application Clusters Installation and Configuration Guide.

If Oracle Cluster Ready Services (CRS) and Oracle Real Application Clusters (RAC) are already installed on the system, Oracle Universal Installer displays the Specify Hardware Cluster Installation Mode screen. You must select Local Installation on this screen, unless you want to install Oracle Real Application Clusters.
Oracle Connection Manager

To install Oracle Connection Manager, choose Advanced Installation and then the Custom installation type.
Oracle Counters for Windows Performance Monitor

To install Oracle Counters for Windows Performance Monitor, choose Advanced Installation and then the Custom installation type.
Oracle Label Security

To install the Oracle Label Security option, choose Advanced Installation and then the Custom installation type.

To configure Oracle Label Security to use Oracle Internet Directory, choose the Oracle Internet Directory option when running Database Configuration Assistant.

Note:
If you are installing Oracle Label Security in an existing Oracle home, then shut down each database in the Oracle home.
Oracle Procedural Gateways

To install Oracle Procedural Gateways, choose Advanced Installation and then the Custom installation type.
Oracle Transparent Gateways

To install Oracle Transparent Gateways, choose Advanced Installation and then the Custom installation type.
Reinstalling Oracle Software

If you reinstall Oracle software into an Oracle home directory where Oracle Database is already installed, you must also reinstall any components, such as Oracle Partitioning, that were installed before you began the reinstallation.

3.4 Downloading Oracle Software from the OTN Web Site

This section describes how to download the installation files from OTN and extract them on your hard disk.

To download the installation files:

Use any browser to access the software download page on OTN:
```
http://otn.oracle.com/software/
```
Navigate to each of the download pages for the product that you want to install.
On each download page, identify the required disk space by adding the file sizes for each required file. The file sizes are listed next to the filenames.
Select a file system with enough free space to store and expand the files. In most cases, the available disk space must be at least twice the size of each compressed file.
On the file system that you just selected, create a parent directory for each product you plan to install, for example OraDB10g, to hold the installation directories.
Download all of the installation files to the directories that you just created.
Verify that the files you downloaded are the same size as the corresponding files on OTN.
Extract the files in each directory that you just created.

When you have extracted all of the required installation files, see the "Installing the Oracle Database Software" section.

3.5 Copying the Oracle Database Software to a Hard Disk

To copy the contents of the installation media to a hard disk:

Create a directory on your hard drive. For example:
```
d:\install\Disk1
```
Copy the contents of the installation media to the directory that you just created.
Continue to the "Installing the Oracle Database Software" section.

When you have copied all of the required installation files, see the "Installing the Oracle Database Software" section.

3.6 Installing the Oracle Database Software

Note:

Use the same installation media to install Oracle Database on all supported Windows platforms.

Start Oracle Universal Installer and install the software, as follows:

Insert the CD labeled Oracle Database 10g Release 1 (10.1) Disk 1 of 1 or navigate to the directory you created for the downloaded or copied installation files.

When installing from a hard disk, double-click setup.exe located in the directory you created for the downloaded or copied installation files.

When installing from the installation media, the Autorun screen automatically appears. If the Autorun screen does not appear, then:
1. Click Start > Run.
2. Enter the following:
```
DRIVE_LETTER:\autorun\autorun.exe
```
  The Autorun screen appears. Click Install/Deinstall Products from the Autorun screen.
The Welcome screen appears. Table 3-1 lists the recommended action for each screen.
Use the following guidelines to complete the installation:
- Follow the instructions displayed in the Oracle Universal Installer screens. If you need additional information, click Help.
- Do not install Oracle Database 10g release 1 (10.1) software into an existing Oracle home that contains Oracle9i or earlier software.
- If you install Oracle Database 10g release 1 (10.1) in an Oracle home directory that already contains Oracle Database 10g release 1 (10.1) client software, the listener is not created. To create the listener, install and run Oracle Net Configuration Assistant. If the Administrator client is installed before Oracle Database, then Oracle Net Configuration Assistant is already installed.
- When prompted for the SYS, SYSTEM, SYSMAN, and DBSNMP passwords, Oracle recommends that the passwords you specify:
  - Are at least four characters long
  - Are not the same as the usernames
  - Have at least one alphabetic, one numeric, and one punctuation mark character
  - Are not simple or obvious words, such as welcome, account, database, or user
  Note:
  You must remember the passwords that you specify.
- Do not modify the Java Runtime Environment (JRE) except by using a patch provided by Oracle Support Services. Oracle Universal Installer automatically installs the Oracle-supplied version of the JRE. This version is required to run Oracle Universal Installer and several Oracle assistants.
- If you encounter errors while installing or linking the software, see Appendix F for information about troubleshooting.
- If you chose an installation type that runs Database Configuration Assistant and Oracle Net Configuration Assistant in interactive mode, you must provide detailed information about configuring your database and network.
  
  If you need assistance when using the Database Configuration Assistant or Oracle Net Configuration Assistant in interactive mode, click Help on any screen.
  
  Note:
  If you chose a default installation, Database Configuration Assistant and Oracle Net Configuration Assistant run non-interactively.
When all of the configuration tools have finished, click Exit, then click Yes to exit from Oracle Universal Installer.
When Oracle Enterprise Manager Database Control opens a Web browser, enter a username and password.

You can log in as SYS, SYSTEM, or SYSMAN. If you log in as SYS, then you must connect AS SYSDBA. Enter the password you specified for the account during installation.
Optionally, delete the \temp\OraInstalldate_time directory if you want to remove the temporary files that were created during the installation process. The OraInstalldate_time directory holds about 45 MB of files.

Restarting your computer also removes the OraInstalldate_time directory.
See Chapter 4, "Oracle Database Postinstallation Tasks" for information about tasks that you must complete after you have installed the software.

Table 3-1 Oracle Universal Installer Screens

Screen	Recommended Action
Welcome	Select Basic Installation or Advanced Installation. Select Basic Installation installation method if you want to quickly install Oracle Database. This installation method requires minimal user input. It installs the software and optionally creates a general-purpose database using the information that you specify on this screen. Click Next.
Specify File Locations	In the Destination section, accept the default values or enter the Oracle home name and directory path in which to install Oracle components. The directory path should not contain spaces. Click Next.
Select Installation Type	Select Enterprise Edition, Standard Edition, Personal Edition, or Custom. Click Next.
Select Database Configuration	Select the database configuration that best meets your needs. See the online help provided by either Oracle Universal Installer or Database Configuration Assistant for a description of these preconfigured database types. Click Next.
Specify Database Configuration Options	Specify the following information, then click Next: Global Database Name Specify a name for the database, followed by the domain name of the system: sales.your_domain.com The value that you specify, up to the first period, is also used for the SID value. Select Database Character Set Accept the default value, which is based on your system locale, or if you need to support more than one language, click Help for more information about the supported character sets. Create database with example schemas Choose this option to create the `EXAMPLE` tablespace that contains the Sample Schemas (optional, but recommended).
Select Database Management Option	Accept the default values, then click Next. Note: You can enable e-mail notifications after you have installed the software.
Specify Database File Storage Option	Select the File System option and specify the database file location, then click Next. Specify database file location: Accept the default location or specify a new file location.
Specify Backup and Recovery Options	Accept the default values, then click Next. Note: You can enable automated backups after you have installed the software.
Specify Database Schema Passwords	Enter and confirm passwords for all of the privileged database accounts, then click Next. Note: Oracle recommends that you specify a different password for each account. You must remember the passwords that you specify.
Summary	Review the information displayed, then click Install.
Install	The Install screen displays status information while the product is being installed.
Configuration Assistants	The Configuration Assistants screen displays status information for the configuration assistants that configure the software and create a database. After Database Configuration Assistant finishes, review the information on the screen. Make a note of the following information: Enterprise Manager URL Database creation logfiles location Global Database Name System Identifier (SID) Server parameter filename and location Click OK to continue or click Password Management to unlock accounts and set passwords.
End of Installation	The configuration assistants configure several Web-based applications, including Oracle Enterprise Manager Database Control. This screen displays the URLs configured for these applications. Make a note of the URLs used. The port numbers used in these URLs are also recorded in the following file: ORACLE_BASE\ORACLE_HOME\install\portlist.ini To exit from Oracle Universal Installer, click Exit, then click Yes. Oracle Enterprise Manager Database Control displays in a Web browser.