Skip Headers
Oracle® Database Installation Guide
11g Release 2 (11.2) for Microsoft Windows

E47798-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

4 Installing Oracle Database

You can use 32-bit media for installing Oracle Database on all supported 32-bit operating systems. You can use 64-bit media for installing Oracle Database on all supported 64-bit x64 operating systems. This guide is for both Windows 32-bit and Windows x64. This chapter covers the following topics:

4.1 Preinstallation Considerations for Installing Oracle Database

The Oracle Database software is available on installation media 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 without the GUI by supplying a response file with silent or response file mode.

Note:

Windows Vista, Windows Server 2008, and later versions require Administrator privileges at the command prompt.

Complete 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:

4.1.1 Installation Consideration on Windows Vista, Windows Server 2008, and Later

On Windows Vista, Windows Server 2008, and later versions command prompts should be opened with Administrator privileges.

4.1.2 Performing Multiple Oracle Database Installations

If you must perform multiple installations of Oracle Database, then you may want to use either of the following methods to install Oracle Database:

  • Response files: At each node, you run Oracle Universal Installer from the command line using silent or response file mode and you supply a response file to provide information Oracle Universal Installer needs. The response file is a text file containing the settings you normally enter in the Oracle Universal Installer GUI dialog boxes.

  • Cloning the Oracle home of an existing Oracle Database installation: With this method, you install one instance of Oracle Database, and then clone its Oracle home for each additional installation.

4.1.3 Installing on Systems That Already Have Oracle Components

See Also:

"Upgrade Considerations" before running Oracle Universal Installer

Follow these steps when other components exist on your computer:

  1. Log on as a member of the Administrators group for the computer on which you want 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.

  2. Delete the ORACLE_HOME environment variable if it exists. See the 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.
  3. Back up any databases you must upgrade. Review "Upgrade Considerations" for more information.

See Also:

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

4.1.4 Installing with Minimum Memory Requirements

Installations of Oracle Database on computers with RAM and virtual memory lesser than the minimum required have the following limitations:

  • Computers cannot run Oracle Database Upgrade Assistant, Oracle Database Configuration Assistant, or Oracle Net Services Configuration Assistant during an Oracle Universal Installer installation session.

  • Depending on how many applications run on the computer, you must 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 Oracle Database Configuration Assistant.

Note:

Do not install the database on computer systems that barely meet the minimum memory and virtual memory requirements of 1 GB.

You can install only the database software by selecting the Install Database Software only option provided on the Select Installation Option screen.

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

  • To create a new database, run Oracle Database Configuration Assistant. From the Start menu, select All 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, select All Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Database Upgrade Assistant.

4.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.

  • Oracle Automatic Storage Management

    In previous releases, Oracle Automatic Storage Management (Oracle ASM) was installed as part of the Oracle Database installation. With Oracle Database 11g Release 2 (11.2), Oracle Automatic Storage Management is part of an Oracle Grid Infrastructure installation, either for a cluster, or for a standalone server.

    If you want to upgrade an existing Oracle Automatic Storage Management installation, then you must upgrade Oracle Automatic Storage Management by running an Oracle Grid Infrastructure upgrade. If you do not have Oracle Automatic Storage Management installed and you want to use Oracle Automatic Storage Management as your storage option, then you must complete an Oracle Grid Infrastructure installation before you start your Oracle Database installation.

    See Also:

    "Oracle Grid Infrastructure for a Standalone Server" for information about Oracle Grid Infrastructure for a standalone server
  • Installations on a cluster

    If Oracle Clusterware or Oracle RAC is installed on the system, Oracle Universal Installer displays the Specify Hardware Cluster Installation Mode page. You must select Local Installation , unless you want to install Oracle RAC.

4.2.1 Selecting the Database Character Set

Oracle Database uses the database character set for:

  • Data stored in SQL character datatypes (CHAR, VARCHAR2, CLOB, and LONG).

  • Identifiers such as table names, column names, and PL/SQL variables.

  • Stored SQL and PL/SQL source code, including text literals embedded in this code.

Once a database is created, changing its character set is usually very expensive in terms of time and resources. Such operation may require converting all character data by exporting the whole database and importing it back. Therefore, it is important that you carefully select the database character set at installation time.

Oracle recommends Unicode AL32UTF8 as the database character set. Unicode is the universal character set that supports most of the currently spoken languages of the world. It also supports many historical scripts (alphabets). Unicode is the native encoding of many technologies, including Java, XML, XHTML, ECMAScript, LDAP. Unicode is ideally suited for databases supporting the Internet and the global economy.

As AL32UTF8 is a multibyte character set, database operations on character data may be slightly slower when compared to single-byte database character sets, such as WE8MSWIN1252. Storage space requirements for text in most languages that use characters outside of the ASCII repertoire are higher in AL32UTF8 compared to legacy character sets supporting the language. The increase in storage space concerns only character data and only data that is not in English. The universality and flexibility of Unicode usually outweighs these additional costs.

Legacy character sets should be considered when compatibility, storage requirements, or performance of text processing is critical and the database supports only a single group of languages. The database character set to be selected in such case is the character set of most clients connecting to this database.

The default character set suggested or used by Oracle Universal Installer and Database Configuration Assistant in this release is based on the language configuration of the operating system.

For most languages, the default character set is one of the Microsoft Windows character sets, for example WE8MSWIN1252. It is noteworthy that the same default is used by the database installation process on UNIX-based platforms. This results from the assumption that most clients connecting to the database run under the Microsoft Windows operating system. As the database should be able to store all characters coming from the clients and Microsoft Windows character sets have richer character repertoire than the corresponding ISO 8859 character sets, the Microsoft Windows character sets are usually the better choice. For example, the EE8MSWIN1250 character set supports the Euro currency symbol and various smart quote characters, while the corresponding EE8ISO8859P2 character set does not support them. In any case, Oracle converts the data between the database character set and the client character sets, which are declared by the NLS_LANG settings.

The list of database character sets that is presented to you for selection by Oracle Universal Installer contains only the recommended character sets. Even though Oracle Database supports many more character sets, they are either deprecated or they are binary subsets of another recommended character set. For example, WE8DEC is a deprecated character set and US7ASCII and WE8ISO8859P1 are both binary subsets of WE8MSWIN1252.

If, for compatibility reasons, you must create a database in one of the non-recommended character sets, choose the Advanced database configuration option. Database Configuration Assistant in the interactive mode gives you the opportunity to select any of the database character sets supported on Windows.

Caution:

AL32UTF8 is the Oracle Database character set that is appropriate for XMLType data. It is equivalent to the IANA registered standard UTF-8 encoding, which supports all valid XML characters.

Do not confuse Oracle Database database character set UTF8 (no hyphen) with database character set AL32UTF8 or with character encoding UTF-8. Database character set UTF8 has been superseded by AL32UTF8. Do not use UTF8 for XML data. UTF8 supports only Unicode version 3.0 and earlier; it does not support all valid XML characters. AL32UTF8 has no such limitation.

Using database character set UTF8 for XML data could cause an irrecoverable error or affect security negatively. If a character that is not supported by the database character set appears in an input-document element name, a replacement character (usually a question mark) is substituted for it. This terminates parsing and raises an exception.

4.2.2 Using an Oracle Automatic Storage Management Disk Group

This section is optional and describes how to identify disk groups and determine the free disk space that they contain. You can store either database or recovery files in an existing Oracle Automatic Storage Management disk group that you created during the Oracle Grid Infrastructure installation.

Note:

The Oracle Automatic Storage Management instance that manages the existing disk group runs in a different Oracle home directory.

To determine whether an existing Oracle Automatic Storage Management disk group exists, or to determine whether there is sufficient disk space in a disk group, use the following procedure:

  1. In the Services Control Panel, ensure that the OracleASMService+ASM service has started.

  2. Open command prompt and temporarily set the ORACLE_SID environment variable to specify the appropriate value for the Oracle Automatic Storage Management instance.

    For example, if the Oracle Automatic Storage Management SID, which is named +ASM, is located in the asm directory, you would enter the following setting:

    DRIVE_LETTER:\>set ORACLE_SID=+ASM
    
  3. Connect to the Oracle Automatic Storage Management instance as the SYS user with the SYSASM privilege and start the instance if necessary:

    DRIVE_LETTER:\>sqlplus /nolog
    SQL> CONNECT SYS as SYSASM
    Enter password: SYS_password 
    SQL> STARTUP
    
  4. Enter the following command to view the existing disk groups, their redundancy level, and the amount of free disk space in each one:

    SQL> SELECT NAME,TYPE,TOTAL_MB,FREE_MB FROM V$ASM_DISKGROUP;
    
  5. From the output, identify a disk group with the appropriate redundancy level and note the free space that it contains.

  6. If necessary, install, or identify the additional disk devices required to meet the storage requirements listed in the previous section.

    Note:

    If you are adding devices to an existing disk group, then Oracle recommends that you use devices that have the same size and performance characteristics as the existing devices in that disk group.

4.3 Accessing the Installation Software

The Oracle Database software is available on installation media or you can download it from the Oracle Technology Network Web site, or Oracle Software Cloud Web site. To install the software from the hard disk, you must either download it and unpack it, or copy it from the installation media, if you have it.

You can access and install Oracle Database by using one of the following methods:

4.3.1 Installing from a Remote DVD Drive

If the computer where you want to install Oracle Database does not have a DVD drive, you can perform the installation from a remote DVD drive. You must complete the following steps:

4.3.1.1 Step 1: On the Remote Computer, Share the DVD Drive

The remote DVD drive must allow shared access. To set this up, perform these steps on the remote computer that has the DVD drive:

  1. Log in to the remote computer as an Administrator user.

  2. Start Windows Explorer.

  3. Right-click the DVD drive letter and select Sharing (or Sharing and Security).

  4. Click the Sharing tab and do the following:

    1. Select Share this folder.

    2. In Share name, give it a share name such as dvd. You use this name when you map the DVD drive on the local computer in step d of the next section.

    3. Click Permissions. You need at least read permission for the user who accesses the drive to install Oracle Database.

    4. Click OK when you are finished.

  5. Insert the Oracle Database installation media into the DVD drive.

4.3.1.2 Step 2: On the Local Computer, Map the DVD Drive

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

  1. Map the remote 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 box.

    3. Select a drive letter to use for the remote DVD drive.

    4. In Folder, enter the location of the remote DVD drive using the following format:

      \\remote_hostname\share_name
      

      where:

      • remote_hostname is the name of the remote computer with the DVD drive.

      • share_name is the share name that you entered in step 4 of the previous procedure. For example:

        \\computer2\dvd
        
    5. If you must connect to the remote computer as a different user, click different user name, and enter the user name.

    6. Click Finish.

  2. Run Oracle Universal Installer from the mapped DVD drive.

  3. Go to the "Installing the Oracle Database Software" section.

4.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 runs 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 DVD to a hard drive, you can install the software from the hard drive.

  • You can insert the DVD into a drive on your local computer, and install the software from the DVD.

4.3.2.1 Installing on Remote Computers from a Hard Drive

If you have copied the contents of the Oracle Database DVD to a hard drive, you can install the software from the hard drive.

To install the software on a remote computer from a hard drive:

  1. Ensure that the remote access software is installed and running on the remote and local computers.

  2. Share the hard drive that contains the Oracle Database DVD.

  3. On the remote computer, map a drive letter to the shared hard drive. You use the remote access software to do this on the remote computer.

  4. Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared hard drive.

  5. Go to the "Installing the Oracle Database Software" section.

4.3.2.2 Installing on Remote Computers from a Remote DVD Drive

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

To install the software on a remote computer from a remote DVD drive:

  1. Ensure that the remote access software is installed and running on the remote and local computers.

  2. On the local computer, share the DVD drive.

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

    These steps are described in the "Installing from a Remote DVD Drive" section.

  3. Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared DVD drive.

  4. Go to the "Installing the Oracle Database Software" section.

4.3.3 Downloading Oracle Software

You can download the trial version of the installation files from the Oracle Technology Network (OTN) or Oracle Software Delivery Cloud Web site and extract them on your hard disk. Ensure that you completely review and understand the terms of the license. Most downloads include the Development License. This section contains the following topics:

4.3.3.1 Downloading the Installation Archive Files from Oracle Technology Network

To download the installation archive files from Oracle Technology Network:

  1. Use any browser to access the software download page from Oracle Technology Network:

    http://www.oracle.com/technetwork/indexes/downloads/index.html
    
  2. Navigate to the download page for the product to install.

  3. On the download page, identify the required disk space by adding the file sizes for each required file.

    The file sizes are listed next to the file names.

  4. Select a file system with enough free space to store and expand the archive files.

    In most cases, the available disk space must be at least twice the size of all of the archive files.

  5. On the file system that you selected in step 4, create a parent directory for each product, for example OraDB11g, to hold the installation directories.

  6. Download all of the installation archive files to the directory that you created in step 5.

  7. Verify that the files you downloaded are the same size as the corresponding files on Oracle Technology Network. Also, verify the checksums are the same as noted on Oracle Technology Network.

  8. Extract the files in each directory that you just created.

  9. After you have extracted the required installation files, see Section 4.5, "Installing the Oracle Database Software."

4.3.3.2 Downloading the Software from Oracle Software Delivery Cloud

You can download the software from Oracle Software Delivery Cloud as Media Packs. A Media Pack is an electronic version of the software that is also available to Oracle customers on CD-ROM or DVD. To download the Media Pack:

  1. Use any browser to access the Oracle Software Delivery Cloud Web site:

    http://edelivery.oracle.com/
    
  2. Complete the Export Validation process by entering information (name, company, e-mail address, and country) in the online form.

  3. In the Media Pack Search page, specify the Product Pack and Platform to identify the Media Pack you want to download. If you do not know the name of the Product Pack, you can search for it using the License List.

  4. Optionally, select the relevant product to download from the Results list.

  5. In the search results page, click Readme to download and review the Readme file for download instructions and product information.

  6. After you review the Readme, choose the appropriate Media Pack from the search results to download the individual zip files. Follow the Download Notes instructions in this page. Once you download and extract the contents of the required zip files, proceed with the installation of the software.

    Note:

    Print the page with the list of downloadable files. It contains a list of part numbers and their corresponding descriptions to refer during the installation process.
  7. After you download the files, click View Digest to verify that the MD5 or SHA-1 checksum matches with what is listed in the media download page.

See Also:

4.3.3.3 Extracting the Installation Files

To extract the installation archive files, perform the following steps:

  1. If necessary, change to the directory that contains the downloaded installation archive files.

  2. The Oracle Database software is available as two zip files. Ensure that you extract both the zip files to the same directory.

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

4.3.4 Copying the Oracle Database Software to a Hard Disk

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

  1. Create a directory on your hard drive. For example:

    C:\> mkdir \install
    C:\> mkdir \install\database
    
  2. Copy the contents of the installation media to the directory that you just created.

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

4.4 Database Security Options

During installation, you are prompted to select a database security configuration. The Secure Configuration option configures the database with database auditing options, and password policy and expiration settings.

For new database installations, the default configuration for Oracle Database 11g Release 2 (11.2) includes the Secure Configuration option. If you want to disable these enhanced security controls, then you can uncheck the Assert all new security settings check box in the Specify Configuration Option screen that appears during installation. Oracle Database is then installed with default options for Oracle Database 10g Release 2. After installation, you can change security settings by starting DBCA and modifying security settings. You can enable or disable auditing or password security settings, or revert to a previous security setting.

For database upgrades, the upgraded database retains your existing database security configuration, to ensure compatibility with existing applications. After installation, you can use DBCA to enable or disable the Secure Configuration option for testing.

Note:

  • Oracle strongly recommends configuring your database with the Secure Configuration option either during installation, or after installation using DBCA.

  • If Oracle Database Vault is installed with the database, then do not check for secure configuration as the database is secured.

4.5 Installing the Oracle Database Software

In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install Oracle Database. The instructions in this section explain how to run the Oracle Universal Installer GUI to perform most database installations.

See Also:

To install the Oracle Database software:

  1. Log on as a member of the Administrators group for the computer on which you want 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.

  2. If you are installing Oracle Database on a computer with multple Network Interface Cards or multiple aliases, use System in the Control Panel to create the ORACLE_HOSTNAME system environment variable. Set this variable to point to the host name of the computer on which you are installing Oracle Database.

  3. Insert Oracle Database installation media and navigate to the database directory. Alternatively, navigate to the directory where you downloaded or copied the installation files.

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

  4. Double-click setup.exe to start Oracle Universal Installer.

    Downloading Updates Before Installation

    Starting with Oracle Database 11g Release 2 (11.2.0.2), if you plan to run the installation in a secured data center, then you can download updates before starting the installation by starting Oracle Universal Installer on a system that has Internet access in update download mode. To start Oracle Universal Installer to download updates before installation, enter the following command:

    setup.exe -downloadUpdates
    

    Provide the My Oracle Support user name and password, and provide proxy settings if needed on the Provide My Oracle Support credentials screen. Then, enter the Download location and click Download on the Download software updates screen. If updates are available, then they are downloaded in the location provided. The Finish Updates screen shows the successful download of the updates. Click Close.

    After you download updates, transfer the update file to a directory on the server where you plan to run the installation.

  5. Follow these guidelines to complete the installation:

    • Do not install Oracle Database 11g Release 2 (11.2) software into an existing Oracle home.

    • Follow the instructions displayed in the Oracle Universal Installer screens. If you need additional information, click Help.

      See Also:

      "Unlocking and Resetting User Passwords" for password guidelines
    • 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 the software, see Appendix F for information about troubleshooting.

    • If you chose an installation type that runs Oracle Database Configuration Assistant in interactive mode, then you must provide detailed information about configuring your database and network.

      If you need help when using the Oracle Database Configuration Assistant in interactive mode, click Help on any screen.

      Note:

      If you chose a default installation, Oracle Database Configuration Assistant does not run interactively.
  6. When the Configuration Assistant tasks are complete, click Finish, click Exit, then click Yes to exit from Oracle Universal Installer.

  7. Optionally, delete the OraInstalldate_time directory to remove the temporary files that were created during the installation process. The OraInstalldate_time directory holds about 45 MB of files. This directory is created in the location set by the TEMP environment variable setting.

    Restarting your computer also removes the OraInstalldate_time directory.

  8. See Chapter 5, "Oracle Database Postinstallation Tasks" for information about tasks that you must complete after you have installed Oracle Database.

The following table lists the various screens displayed during an Enterprise Edition installation for Oracle Database 11g Release 2 (11.2):

Table 4-1 Oracle Universal Installer Windows

Screen Action

Configure Security Updates

Enter your e-mail address, preferably your My Oracle Support (formerly OracleMetaLink) e-mail address or user name in the Email field.

You can select the I wish to receive security updates via My Oracle Support check box to receive security updates.

Enter your My Oracle Support (formerly OracleMetaLink) password in the My Oracle Support Password field.

Click Next.

Download Software Updates

Starting with Oracle Database 11g Release 2 (11.2.0.2), you can use the Software Updates feature to dynamically download and apply latest updates. Select one of the following options, and click Next:

  • Use My Oracle Support credentials for download: Select this option to download and apply the latest software updates.

    Click Proxy Settings to configure a proxy for Oracle Universal Installer to use to connect to the Internet. Provide the proxy server information for your site, along with a user account that has access to the local area network through which the server is connecting. Starting with Oracle Database 11g Release 2 (11.2.0.3), you can enter the Proxy Realm information. The proxy realm information is case-sensitive. If you do not have a proxy realm, then you do not need to provide an entry for the Proxy Username, Proxy Password, and Proxy Realm fields.

    Click Test Connection to ensure that your proxy settings are correctly entered, and the installer can download the updates.

  • Use pre-downloaded software updates: Select this option if you have already downloaded software updates using the Oracle Universal installer command setup.exe -downloadUpdates.

  • Skip software updates: Select this option if you do not want to apply any updates.

See Also: "Software Updates Option"

Apply Software Updates

This screen is displayed if you select to download the software updates, or provide the pre-downloaded software updates location.

  • If you selected Use My Oracle Support credentials for download in the previous screen, select Download and apply all updates, and then click Next to apply the updates.

    By default, the download location for software updates is placed in the home directory of the Oracle installation owner you are using to run this installation. If you choose to download the software updates in another location, then click Browse and select a different location on your server.

  • If you selected Use pre-downloaded software updates in the previous screen, select Apply all updates, and then click Next to apply the updates downloaded before starting the installation.

Select Installation Option

Select one of the following installation options, click Next.

  • Create and configure a database: This option creates a new database along with sample schemas.

  • Install database software only: This option installs only the database binaries. To configure database, you must run Oracle Database Configuration Assistant after the software installation.

  • Upgrade an existing database: This option installs the software binaries in a new Oracle home. At the end of the installation, you can upgrade the existing database.

System Class

Select the type of system for installing the database, click Next.

  • Desktop Class: Choose this option if you are installing on a laptop or desktop class system. This option includes a starter database and allows minimal configuration. This option is designed for those who want to get up and running with the database quickly.

  • Server Class: Choose this option if you are installing on a server class system, such as what you would use when deploying Oracle in a production data center. This option allows for more advanced configuration options. Advanced configuration options available using this option include Oracle RAC, Oracle Automatic Storage Management, backup and recovery configuration, integration with Enterprise Manager Grid Control, and more fine-grained memory tuning, among many others.

Grid Installation Options

Select the type of database installation you want to perform, click Next.

  • Single instance database installation: This option installs the database and the listener.

  • Oracle Real Application Clusters database installation: This option installs Oracle Real Application Clusters.

  • Oracle RAC One Node database installation: This option installs Oracle RAC One Noda database.

    Note: Oracle RAC One Node is only supported with Oracle Clusterware.

Select Install Type

Select one of the following, then click Next:

  • Typical Install: This installation method is selected by default. It lets you quickly install Oracle Database using minimal input. It installs the software and optionally creates a general-purpose database using the information that you specify on this screen.

  • Advanced Install: This installation method enables to 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.

Select Product Languages

This option enables you to select the language in which you want to run the product.

Select the product Language from the Available Languages list, transfer it to the Selected Languages list. Click Next.

Select Database Edition

Select Enterprise Edition, Standard Edition, Standard Edition One, or Personal Edition. Click Next

If you click Select Options, then based on your selection you can enable or disable components from the components list. The components available are:

  • Oracle Partitioning

  • Oracle OLAP

  • Oracle Label Security

  • Oracle Data Mining RDBMS Files

  • Oracle Database Vault option

  • Oracle Real Application Testing

  • Oracle Database Extensions for .NET

Click OK to continue.

Click Next.

Note: The Select Options button is enabled only if you select the Enterprise Edition installation type.

Specify Installation Location

The Oracle base path appears by default. You can change the path based on your requirement. Specify Oracle Base, Software Location, and click Next.

The Oracle base directory is a top-level directory for Oracle software installations owned by an Oracle installation owner account. The default Oracle base path is DRIVE_LETTER:\app\user, where user is the user account running the installation. You can change the path based on your requirements.

In the Software Location field, accept the default value or enter the Oracle home directory path in which you want to install Oracle components. The directory path should not contain spaces.

Click Next.

Note: This screen is available only with Advanced Installation.

See Also: "Optimal Flexible Architecture Directory Naming Conventions" for information about directory naming conventions

Select Configuration Type

Select one of the following, click Next:

  • General Purpose / Transaction Processing: This is a starter database designed for general usage or transaction-heavy applications.

  • Data Warehousing: A starter database optimized to run Data Warehousing applications.

See the online Help provided by either Oracle Universal Installer or Oracle Database Configuration Assistant for a description of these preconfigured database types.

Specify Database Identifiers

Specify the following information, then click Next:

Database Naming

Specify the Global Database Name using the following syntax:

database_unique_name.db_domain

where:

  • database_unique_name is the name of the database. It can contain a maximum of 30 characters as long as the first eight characters are unique and begin with an alphabetic character. The characters can include alphanumeric, underscore (_), dollar ($) , and pound (#), no other special characters are permitted in a database name.

  • db_domain is the computer environment used for the database. It should contain no more than 128 characters (alphanumeric, underscore (_), and pound (#)), inclusive of all periods.

Note: Ensure that the combination of database name (first eight unique characters of database unique name), delimiter, and the database domain name does not exceed 128 characters.

For example:

sales.us.example.com

where:

  • database_unique_name is sales

  • db_domain is us.example.com

When you enter the Global Database Name, Oracle Universal Installer automatically populates the SID prefix with the database name. You can change this name in Advanced installation.

Oracle Universal Installer limits the SID to 12 alphanumeric characters and the SID cannot contain underscore (_), dollar ( $), and pound (#).

Specify Configuration Options

Specify the following configuration details, then click Next.

Memory:

Enable Automatic MemoryManagement option is selected by default. This option allows the database to automatically distribute memory between SGA and PGA. If you deselect this option, then the SGA and PGA must be sized manually.

Character Sets:

This option enables you to store the character data in the database in one of the following methods:

  • Use the default: This option uses the operating system language settings.

  • Use Unicode: This option enables you to store multiple language groups.

  • Choose from the following list of character sets: This option enables the Select Database Character Set drop down list.

See Also:

Security:

The Assert all new security settings option is selected by default. The setting includes enabling auditing and using new password profile.

Note: Oracle recommends that you use the default settings.

Sample Schemas:

The Create database with sample schemas option is not selected by default. However, you can select the option, to create the starter database with sample schema.

Specify Management Options

Select one of the following, then click Next:

  • Use an existing Oracle Enterprise Manager Grid Control for database management: This option is useful if you have Oracle Enterprise Manager installed.

  • Use Oracle Enterprise Manager Database Control for database management: This option enables you to manage Oracle Database locally. Optionally, select Enable Email Notifications and then enter the outgoing SMTP server and e-mail address.

    See Also: "Email Notification Options"

    Note: The option to enable e-mail notifications is not available starting with Oracle Database 11g Release 2 (11.2.0.2).

Specify Database Storage Options

Select one of the following, then click Next.

  • File System: Specify the database file location.

  • Oracle Automatic Storage Management: Specify a password for the ASMSNMP user.

Note: Installing Oracle data files on an Oracle ACFS file system is not supported. Oracle recommends that these data files are installed in Oracle ASM disk groups.

See Also: "Using an Oracle Automatic Storage Management Disk Group"

Specify Recovery Options

Select one of the following, then click Next.

  • Do not enable automated backups.

  • Enable automated backups: If you select this option, then the backup job uses a specified recovery area storage.

    Select File System to use a file system directory for the fast recovery area, and then specify the fast recovery area path in the Recovery Area location field.

    Select Oracle Automatic Storage Management to use an Oracle Automatic Storage Management disk group for the fast recovery area.

    Specify your operating system user credentials to perform the backup job.

See Also: "Preparing Disks for an Oracle Automatic Storage Management Installation"

Select ASM Disk Group

This screen is displayed only if you select Oracle Automatic Storage Management as your storage option.

Disk groups are created during the Oracle Grid Infrastructure installation. Disk groups are configured with the SYSASM privilege using asmcmd or SQL create diskgroup commands. An ASM disk group consists of multiple disk partitions.

The table in this screen displays existing disk groups created during the Oracle Grid Infrastructure installation. Select a disk group to use for database file storage.

Specify Schema Passwords

Enter and confirm passwords for the privileged database accounts: SYS, SYSTEM, SYSMAN, and DBSNMP.

Click Next.

Note: Optionally, you can use the same password for all accounts. However, Oracle recommends that you specify a different password for each account. You must remember the passwords that you specify.

See Also: "Unlocking and Resetting User Passwords" for information about password guidelines

Perform Prerequisite Checks

This option checks if the minimum system requirements to perform the database installation are met.

Click Fix & Check Again, if you want the installer to fix the problem and check the system requirements once more.

If you click Check Again, then you can run the prerequisite check again to see if the minimum requirements are met to carry on with the database installation.

To get a list of failed requirements, select Show Failed from the list. To get a list of all the prerequirement checks run by the OUI, select Show All. To get a list of the prerequirement checks that are successful, select Show Succeeded.

Note: Oracle recommends that you use caution in checking the Ignore All option. If you check this option, then Oracle Universal Installer may not confirm that your system can install Oracle Database successfully.

See Also: "Oracle Database Preinstallation Requirements" for information about the system requirements

Summary

Review the information displayed on this screen, and click Install.

Note: Starting with Oracle Database 11g Release 2 (11.2), you can save all the installation steps into a response file by clicking Save Response File. Later, this file can be used for a silent installation.

Install Product

This screen displays the progress of a database installation. It also shows the status information while the product is being installed. Click Next.

This screen then displays the status information for the configuration assistants that configure the software and create a database. When the message is displayed after Database Configuration Assistant process, click OK to continue.

Finish

This screen is shown automatically when all the configuration tools are successful.

Review the Enterprise Manager Database Control URL information displayed in this screen and click Close.


4.6 Cloning an Oracle Home

You can copy an existing Oracle home and then configure it for a new environment. This process is called cloning. If you are performing multiple Oracle Database installations, you may want to use this method to create each new Oracle home, because copying files from an existing Oracle Database installation takes less time than creating a new version of them. This method is also useful if the Oracle home that you are cloning has patches applied to it. When you clone an Oracle home, the new Oracle home has the patch updates.

When you clone Oracle homes using release 11.2 Database Control, you must update the exclude file list. This file list specifies files that need not be included when the source Oracle home is archived because these files are not required for the cloning operation. Do not include the following files in the archive:

  • sqlnet.ora

  • tnsnames.ora

  • listener.ora

Note:

In addition to cloning an Oracle home, you can clone individual Oracle databases, by using Enterprise Manager Database Control. Oracle Database Administrator's Guide covers cloning Oracle databases in detail, and cloning Oracle homes.

This section contains the following topics:

4.6.1 Cloning an Oracle Home

Perform the following steps to clone an Oracle home:

  1. Ensure that the Oracle Database installation whose home you want to clone has been successful.

    You can check the success of the installation by reviewing the installActionsdate_time.log file for the installation session, which is normally located in the C:\Program Files\Oracle\Inventory\logs directory.

    If you have installed patches, you can check their status by running the following commands at a command prompt:

    C:\ORACLE_HOME\OPatch> set ORACLE_HOME=ORACLE_HOME_using_patch
    C:\ORACLE_HOME\OPatch> opatch lsinventory
    
  2. Stop the Oracle-related services on this computer.

    You can stop Oracle services by using one of the following methods:

    • Oracle Administration Assistant for Windows: From the Start menu, select All Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Administrative Assistant for Windows, then Oracle Managed Objects, then Computers, and then machine-name. Select Databases, then right-click global database name, select Stop Service.

      Note:

      Choose Startup/Shutdown Options to control whether a database instance should be stopped along with the service.
    • Microsoft Windows Services utility: From the Start menu, select Control Panel, then Administrative Tools, then Services. Right-click any service that begins with Oracle, and then from the menu, select Stop.

  3. Create a ZIP file with the Oracle home (but not Oracle base) directory, selecting the Save full path info option.

    For example, if the source Oracle installation is in C:\app\username\product\11.2.0\dbhome_1, you zip the dbhome_1 directory, leaving out the admin, flash_recovery_area, and oradata directories that are under 11.2.0. These directories are created in the target installation later on when you create a new database there.

  4. Copy the ZIP file to the root directory of the target computer.

  5. Extract the ZIP file contents, selecting the Use folder names option.

  6. Repeat steps 4 and 5 for each computer where you want to clone the Oracle home, unless the Oracle home is on a shared storage device.

  7. In the source Oracle home, restart the services that you stopped in step 2.

  8. On the target computer, cd to the unzipped Oracle home directory, and perform the following steps:

    1. Remove the *.ora files that are present in unzipped ORACLE_HOME\network\admin directory, such as listener.ora, sqlnet.ora, and tnsnames.ora.

    2. From the clone\bin directory, run clone.pl for the unzipped Oracle home. Use the following syntax:

      C:\ORACLE_HOME\clone\bin>%ORACLE_HOME%\perl\bin\per.exe clone.pl
      ORACLE_HOME="target location" ORACLE_BASE="target Base location"
      -defaultHomeName 
      

      For example:

      C:\ORACLE_HOME\clone\bin> clone.pl 
       ORACLE_HOME="C:\app\username\product\11.2.0\dbhome_1" -defaultHomeName
      ORACLE_BASE="C:\app\username"
      

    Oracle Universal Installer starts, and then records the cloning actions in the cloneActionstimestamp.log file. This log file is normally located in C:\Program Files\Oracle\Inventory\logs.

  9. To configure connection information for the new database, run Net Configuration Assistant.

    To start Net Configuration Assistant, select Start, then All Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, and then Net Configuration Assistant.

  10. To create a new database for the newly cloned Oracle home, run Oracle Database Configuration Assistant.

    To start Oracle Database Configuration Assistant, select Start, then All Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, and then Database Configuration Assistant.

See Also:

4.6.2 Configuring Oracle Configuration Manager in a Cloned Oracle Home

Perform the following steps to configure Oracle Configuration Manager for a cloned Oracle home:

  1. Run the following command from ORACLE_HOME\ccr\state:

    del *.ll*
    
  2. Run the following command from ORACLE_HOME:

    copy ccr\inventory\core.jar ccr\inventory\pending
    
  3. Run these commands from ORACLE_HOME\ccr\bin:

    emSnapshotEnv
    deployPackages
    
  4. If new credentials are needed, run this command from ORACLE_HOME\ccr\bin.

    configCCR
    

If Oracle Configuration Manager was manually configured using setupCCR, then perform the following in the cloned Oracle home:

  1. Delete all the subdirectories of the ORACLE_HOME\ccr\hosts directory to remove the previously configured hosts.

  2. Run the following command from ORACLE_HOME\ccr\bin:

    configCCR -a
    

If you have installed Oracle Configuration Manager in the original Oracle home but have not configured it, then run the following command in the cloned Oracle home to configure it:

setupCCR