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 noninteractive installations, without using the GUI.

This chapter contains these topics:

Preinstallation Considerations Before Installing Oracle Database
Reviewing Component-Specific Installation Guidelines
Accessing the Installation Software
Installing the Oracle Database Software

3.1 Preinstallation Considerations Before Installing Oracle Database

Review and satisfy the requirements described in Chapter 2, "Oracle Database Preinstallation Requirements" and "Reviewing Component-Specific Installation Guidelines" before you begin the installation.

Next, consider the following issues:

Performing Multiple Oracle Database Installations
Installing onto Systems That Already Have Oracle Components
Installing with Minimum Memory Requirements

3.1.1 Performing Multiple Oracle Database Installations

If you need to perform multiple installations of Oracle Database, you may want to use noninteractive mode. In noninteractive mode, at each node, you run Oracle Universal Installer from the command line using a response file. The response file is a text file containing the settings you normally enter in the Oracle Universal Installer GUI dialog boxes.

See Also:

"Installing Oracle Components in Noninteractive Mode" for instructions on performing noninteractive installations

3.1.2 Installing onto Systems That Already Have Oracle Components

See Also:

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

Follow these steps:

Log on as a member of the Administrators group to the computer on which to install Oracle components.

If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.
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 you need to upgrade. Review "Upgrade Considerations".
If you are installing in an existing Oracle Database 10g release 1 (10.1) home, 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

3.1.3 Installing with Minimum Memory Requirements

Installations of Oracle Database on computers with 1BG of RAM and 512 MB of virtual memory have the following limitations:

Computers with 256 MB of memory cannot 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. If temporary files and the paging file are both stored on the same physical drive, the space requirements for one may limit the size of another. If your system has limited free space, 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 500 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 Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Database Configuration Assistant.
To upgrade an existing database, run Oracle Database Upgrade Assistant. From the Start menu, choose Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Database Upgrade Assistant.

3.2 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

See Also:
Oracle Real Application Clusters Installation and Configuration Guide for information on installing Oracle Real Application Clusters

If Oracle Cluster Ready Services (CRS) and Oracle Real Application Clusters 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.
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.3 Accessing the Installation Software

The Oracle Database Client software is available on compact disc (CD-ROM or DVD-ROM) or you can download it from the Oracle Technology Network (OTN) Web site. You can access and install Oracle Database Client by using the following scenarios:

Installing from a Remote CD-ROM or DVD Drive
Installing on Remote Computers Through Remote Access Software
Downloading Oracle Software from the Oracle Technology Network Web Site
Copying the Oracle Database Software to a Hard Disk

3.3.1 Installing from a Remote CD-ROM or DVD Drive

If the computer where you want to install Oracle Database does not have a CD-ROM or DVD drive, you can perform the installation from a remote CD-ROM or DVD drive. Complete the following steps:

On the Remote Computer, Share the CD-ROM or DVD Drive
On the Local Computer, Map the CD-ROM or DVD Drive

3.3.1.1 On the Remote Computer, Share the CD-ROM or DVD Drive

The remote CD-ROM or DVD drive that you want to use must allow shared access. To set this up, perform these steps on the remote computer that has the CD-ROM or DVD drive:

Log in to the remote computer as an Administrator user.
Start Windows Explorer.
For both Windows 2003 and Windows XP, right-click the CD-ROM or DVD drive letter and choose Sharing and Security.
Click the Sharing tab and do the following:
1. Select Share this folder.
2. In Share name, give it a share name such as cdrom or dvd. You will use this name when you map the CD-ROM or DVD drive on the local computer. See step d under step 1 of the next procedure.
3. Click Permissions. You need at least "read" permission for the user who will be accessing it to install Oracle Database.
4. Click OK when you are finished.
For a CD-ROM, insert the CD labeled Oracle Database 10g Release 1 (10.1) Disk 1 of 1 into the CD-ROM drive.

For a DVD, insert the Oracle Database DVD into the DVD drive.

3.3.1.2 On the Local Computer, Map the CD-ROM or DVD Drive

Perform these steps on the local computer to map a remote CD-ROM or DVD drive and to run Oracle Universal Installer from the mapped drive:

Map the remote CD-ROM or DVD drive.
1. Start Windows Explorer on the local computer.
2. From the Tools menu, select Map Network Drive to display the Map Network Drive dialog.
3. Select a drive letter to use for the remote CD-ROM or DVD drive.
4. In Folder, enter the location of the remote CD-ROM or DVD drive using the following format:
```
\\remote_hostname\share_name
```
  where:
  - remote_hostname is the name of the remote computer with the CD-ROM or DVD drive.
  - share_name is the share name that you entered in step 4 of the previous procedure. For example
```
\\computer2\cdrom
```
5. If you need to connect to the remote computer as a different user, click different user name, and enter the username.
6. Click Finish.
Run Oracle Universal Installer from the mapped CD-ROM or DVD drive.
Go to the "Installing the Oracle Database Software" section.

3.3.2 Installing on Remote Computers Through Remote Access Software

If you want to install and run Oracle Database on a remote computer (that is, the remote computer has the hard drive and will run Oracle Database components), but you do not have physical access to the computer, you still can perform the installation on the remote computer if it is running remote access software such as VNC or Symantec pcAnywhere. You also need the remote access software running on your local computer.

You can install Oracle Database on the remote computer in one of two ways:

If you have copied the contents of the Oracle Database CD-ROM or DVD to a hard drive, you can install from the hard drive.
You can insert the CD-ROM or DVD into a drive on your local computer, and install from the CD-ROM or DVD.

3.3.2.1 Installing from a Hard Drive

If you have copied the contents of the Oracle Database CD-ROM or DVD to a hard drive, you can install from the hard drive.

The steps that you have to complete are:

Make sure that the remote access software is installed and running on the remote and local computers.
Share the hard drive that contains the Oracle Database CD-ROM or DVD.
On the remote computer, map a drive letter to the shared hard drive. You would use the remote access software to do this on the remote computer.
Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared hard drive.
Go to the "Installing the Oracle Database Software" section.

3.3.2.2 Installing from a Remote CD-ROM or DVD Drive

You can insert the CD-ROM or DVD into a drive on your local computer, and install from the CD-ROM or DVD.

The steps that you need to complete are:

Make sure that the remote access software is installed and running on the remote and local computers.
On the local computer, share the CD-ROM or DVD drive.

On the remote computer, map a drive letter to the shared CD-ROM or DVD drive. You would use the remote access software to do this on the remote computer.

These steps are described in the "Installing from a Remote CD-ROM or DVD Drive" section.
Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared CD-ROM or DVD drive.
Go to the "Installing the Oracle Database Software" section.

3.3.3 Downloading Oracle Software from the Oracle Technology Network Web Site

You can download the installation files from the Oracle Technology Network (OTN) and extract them on your hard disk.

To download the installation files:

Use any browser to access the Oracle Technology Network software download page:
```
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 Oracle Technology Network.
Extract the files in each directory that you just created.
After you have extracted the required installation files, go to the "Installing the Oracle Database Software" section.

3.3.4 Copying the Oracle Database Software to a Hard Disk

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

Create two directories at the same level on your hard drive with the names Disk1 and Disk2.

You must use these names. For example:
```
d:\install\Disk1
d:\install\Disk2
```
Copy the contents of each component CD-ROM to the appropriate directory.
After you have copied all of the required installation files, continue to the "Installing the Oracle Database Software" section.

3.4 Installing the Oracle Database Software

In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install Oracle Database. However, you can also use Oracle Universal Installer to complete noninteractive installations, without using the GUI. This method is particularly useful if you need to perform multiple installations of Oracle Client.

See Also:

Appendix B, "Oracle Database Advanced Installation Topics" for information on noninteractive installations and other advanced installation topics

To install the Oracle Database software:

Log on as a member of the Administrators group to the computer on which to install Oracle components.

If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.
Insert the CD labeled Oracle Database 10g Release 1 (10.1) Disk 1 of 1 or navigate to the directory where you downloaded or copied the installation files.

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

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

When installing from the installation media, the Autorun screen automatically appears. If the Autorun screen does not appear, then:
1. From the Start menu, select Run.
2. Enter the following:
```
DRIVE_LETTER:\autorun\autorun.exe
```
  In the Autorun screen, choose Install/Deinstall Products.
In the Welcome screen, select either Basic Installation or Advanced Installation, and then answer the prompts as needed.

See Also:
"Oracle Database Installation Methods" for more information on the Basic and Advanced installation methods

The subsequent screens that appear, which are listed in Table 3-1, depend on the installation method you have chosen.
Follow these guidelines to complete the installation:
- 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 after the installation. If the Administrator client is installed before Oracle Database, Oracle Net Configuration Assistant is already installed.
- Follow the instructions displayed in the Oracle Universal Installer screens. If you need additional information, click Help.
- 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 E 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 Oracle Database.

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. Advanced Installation lets you perform more complex installations, such as creating individual passwords for different accounts, creating specific types of starter databases (for example, for transaction processing or data warehouse systems), using different language groups, specifying e-mail notifications, and so on. 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. Make sure that the name you give your database is no more than eight characters long. This name can only contain the following characters: Alphabetic characters Numbers Underscores (_) Pound sign (#) Dollar sign ($) 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.