3 Installing Oracle Database

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

3.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 noninteractive mode.

Note:

Windows Vista requires 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:

3.1.1 Installation Consideration on Windows Vista

The installation consideration on Windows Vista is to open a command prompt with Administrator privileges.

3.1.2 Performing Multiple Oracle Database Installations

If you need to perform multiple installations of Oracle Database, 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 noninteractive mode and you supply a response file to provide information Oracle Universal Installer will need. 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.

3.1.3 Installing onto Systems That Already Have Oracle Components

See Also:

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 need to upgrade. Review "Upgrade Considerations".

  4. If you are installing in an existing Oracle Database 11g release 1 (11.1) home, stop all Oracle services making use of this Oracle home.

    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.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 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 Oracle Database Configuration Assistant.

Do not install the database on computer systems that barely meet the minimum memory and virtual memory requirements, 1 GB. Depending on the installation type you choose, 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 Oracle Database Configuration Assistant from the Configuration Assistants 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 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 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

    If Oracle Clusterware or Oracle RAC is 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 RAC.

    See Also:

    Oracle Real Application Clusters Installation Guide for Microsoft Windows, available on the Oracle Clusterware installation media
  • Products not installed by default: select Advanced Installation and then the Custom installation type. These products are:

    • Oracle Label Security

      To configure Oracle Label Security to use Oracle Internet Directory, choose the Oracle Internet Directory option when running Oracle Database Configuration Assistant. If you are installing Oracle Label Security in an existing Oracle home, then shut down each database in the Oracle home.

    • Oracle Database Vault

    • Oracle Connection Manager

    • Oracle COM Automation feature

    • Oracle Windows Interfaces

    • Oracle Counters for Windows Performance Monitor

  • 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 begin the reinstallation.

3.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 already 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. Note that 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 will ever support 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 need to create a database in one of the non-recommended character sets, choose the Custom installation type or choose the Advanced database configuration option. Database Configuration Assistant in the interactive mode will give you the opportunity to select any of the database character sets supported on Windows.

3.2.2 Installing the Sample Schemas

The Sample Schemas are not available in Basic Installation. There are two instances where the Sample Schemas are available:

  • When a new database instance is created with the Database Configuration Assistant, the Sample Schemas can be installed. However, do not select Custom database. Sample Schemas are not available with a custom installation.

  • When a new database instance is created with the Oracle Universal Installer, select either Enterprise Edition or Standard Edition, then select one of the two templates: General Purpose/Transaction Processing or Data Warehouse. The Sample Schemas can be installed. However, if you select the Advanced option on the Select Database Configuration screen, then the Sample Schemas are not available for installation.

See Oracle Database Sample Schemas for information about manually installing the Sample Schemas in an existing database.

3.3 Accessing the Installation Software

The Oracle Database software is available on installation media, or you can download it from the Oracle Technology Network (OTN) Web site. You can access and install Oracle Database by using the following scenarios:

3.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 will need to complete the following steps:

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

The remote 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 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 will use this name when you map the DVD drive on the local computer. Under "Step 2: On the Local Computer, Map the DVD Drive" see Step d under Step 1.

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

    4. Click OK when you are finished.

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

3.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 need to 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.

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

3.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. Make sure 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.

3.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. Make sure 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.

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:

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

    http://www.oracle.com/technetwork/indexes/downloads/index.html
    
  2. Navigate to each of the download pages for the product that you want to install.

  3. 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 file names.

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

  5. On the file system that you just selected, create a parent directory for each product you plan to install, for example OraDB11g, to hold the installation directories.

  6. Download all of the installation files to the directories that you just created.

  7. Verify that the files you downloaded are the same size as the corresponding files 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 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:

  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.

3.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 1 (11.1) includes the Secure Configuration option. If you want to disable these enhanced security controls, then you can check the Disable security settings check box. 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, there is no need to check for secure configuration as the database is secured.

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

Note:

If you run Oracle Universal Installer during the time that Windows Scheduler jobs are running, then you may encounter unexplained installation problems if your Windows Scheduler job is performing cleanup, and temporary files are deleted before the installation is finished. Oracle recommends that you complete installation before the Windows Scheduler jobs are run, or disable Windows Scheduler jobs that perform cleanup of temporary files until after the installation is completed.

See Also:

To install the Oracle Database software:

  1. Log on as a member of the Administrators group to 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.

  5. On the Welcome screen, the Basic Installation is selected by default. If you want to perform an advanced installation, then select 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. The order in which the screens appear depends on the options you select.

  6. Follow these guidelines to complete the installation:

    Note:

    If you perform a Custom installation, then ensure that you install only the components covered by your license. You can not install Standard Edition using Custom installation.
    • Do not install Oracle Database 11g release 1 (11.1) 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 Changing 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 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 Oracle Database Configuration Assistant or Oracle Net Configuration Assistant in interactive mode, click Help on any screen.

      Note:

      If you chose a default installation, Oracle Database Configuration Assistant and Oracle Net Configuration Assistant do not run interactively.
  7. After the configuration assistants have run, click Exit, then click Yes to exit from Oracle Universal Installer.

  8. When Oracle Enterprise Manager Database Control opens in a Web browser, enter the user name and password you created during the installation.

    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.

  9. Optionally, delete the 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. This directory is created in the location set by the TEMP environment variable setting.

    Restarting your computer also removes the OraInstalldate_time directory.

  10. 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 Windows

Window Action

Select a Product to Install

This screen enables you to install any one for the following products:

  • Oracle Database 11g

  • Oracle Client

  • Oracle Clusterware

Click Next.

Select Installation Method

Select one of the following, then click Next:

  • Basic Installation: This installation method, selected by default, 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 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.

Select Installation Type

Select Enterprise Edition, Standard Edition, Personal Edition, or Custom.

You can also specify language translations to be installed by clicking Product Languages.

Click Next.

Note: This screen is available only with Advanced Installation.

Install Location

The Oracle base path appears by default. You can change the path based on your requirement.

In the Software Location section, accept the default values or enter the Oracle home name and 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.

Available Product Components

If you selected Custom for the Installation Type, this screen is displayed. Select the components to be installed from the list and click Next. To learn more about each component, place the mouse over the component name.

Note: This screen is available only with Advanced Installation.

Product-specific Prerequisite Checks

This screen checks that the system meets the minimum requirements for the installation. Correct any errors that Oracle Universal Installer may have found, and then click Next.

Upgrade an Existing Database

This screen is displayed if you have a previous updatable version of Oracle Database or Automatic Storage Management installed. For in-place database installations where Automatic Storage Management is running, Automatic Storage Management is upgraded automatically.

Click Yes if you want to upgrade or No if not. If you click Yes, the Summary screen is displayed.

For more information about upgrades, see Oracle Database Upgrade Guide.

Select Configuration Option

Select one of the following:

  • Create a database: Select this option if you are creating a database of the following types: General Purpose/Transaction processing, and Data warehousing. The Advanced option lets you perform a custom installation.

  • Configure Automatic Storage Management: Select this option to create an Automatic Storage Management instance only. To create an Automatic Storage Management instance, you must provide an Automatic Storage Management SYS Password. After you provide this password, Oracle Universal Installer lets you create an Automatic Storage Management disk group. After you complete this Oracle Universal Installer session, you can run it again to install and configure one or more Oracle databases that will use Automatic Storage Management.

  • Install database Software only: Select this option to install the database software only, but not create a database or configure Automatic Storage Management.

Select Automatic Storage Management Option

If you selected Configure Automatic Storage Management from the Select Configuration Option screen, and if you have Oracle Enterprise Manager 11g Grid Control installed, then this screen is displayed. Select Yes or No, depending on the requirement to use Grid Control to manage Automatic Storage Management. If you select Yes, then select from the list of Enterprise Management agents to use.

Configure Automatic Storage Management

If you selected Configure Automatic Storage Management from the Select Configuration Option screen, this screen is displayed. Enter the disk group name. The disk group list shows both candidate and member disks; you can click Show Candidates or Show All to filter their display. Then, select the redundancy level and member disks for the disk group.

For Redundancy Level, choose one of the following options. If you do not choose a redundancy level, the disk group defaults to normal redundancy.

  • High: With this option, the contents of the disk group are three-way mirrored by default. To create a disk group with high redundancy, you must specify at least three failure groups (a minimum of three devices).

  • Normal: In a normal redundancy level, by default, the data files of the disk group are two-way mirrored and the control files are three-way mirrored. You can choose to create certain files that are three-way mirrored or not mirrored. To create a disk group with normal redundancy, you must specify at least two failure groups (a minimum of two devices) for two-way mirroring.

  • External: If you select this option, Automatic Storage Management does not mirror the contents of the disk group. Choose this redundancy level when the disk group contains devices, such as RAID devices, that provide their own data protection; or the use of the database does not require uninterrupted access to data, for example, in a development environment where you have a suitable backup strategy.

Select Database Configuration

Select the database configuration that best meets the requirements: General Purpose/Transaction Processing, Data Warehouse, or Advanced.

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

Click Next.

Specify Database Configuration Options

Specify the following information, then click Next:

Database Naming

Specify the Global Database Name using the following syntax:

database_name.domain

where:

  • database_name is the name of the database. It can contain no more than 30 characters (alphanumeric, underscore (_), dollar ($) , and pound (#)).

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

For example:

sales.us.mycompany.com

When you enter the Global Database Name, Oracle Universal Installer automatically populates the SID field with the database name, but you can change this SID to another name. The SID can have no more than 64 characters (alphanumeric, dollar ($), and pound (#)).

Specify Database Config Details

Specify the following configuration details, then click Next.

Memory:

Specify the amount of physical memory (RAM) you want to allocate in the Percentage field.

If you install the database software only, then you can click Show Memory Distribution to check the memory usage by the various processes running on the system.

Character Set:

Determine how character data is encoded in the database. The default is based on the operating system language. Select Unicode (AL32UTF8) to store multiple languages.

See Also:

Security

To disable the default enhanced security controls, you can check the Disable security settings check box. Oracle Database is then installed with default options for Oracle Database 10g release 2.

Sample Schema

You can specify if you want to create Oracle Database with or without sample schemas.

See "Installing the Sample Schemas" for information about installing the Sample Schemas.

Select Database Management Option

Select one of the following, then click Next:

  • Use Grid Control for Database Management if you have Oracle Enterprise Manager installed.

  • Use Database Control for Database Management. Optionally, select Enable Email Notifications and then enter the outgoing SMTP server and e-mail address.

Specify Database Storage Option

Select one of the following, then click Next.

  • File System: Specify the database file location.

  • Automatic Storage Management

Specify Backup and Recovery Options

Select one of the following, then click Next.

  • Do not enable Automated backups.

  • Enable Automated Backups: Specify the recovery area storage location and backup job credentials.

Specify Database Schema Passwords

Enter and confirm passwords for the privileged database accounts, then 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 "Unlocking and Changing Passwords" for information on password guidelines.

Privileged Operating System Groups

This screen is displayed only during the first installation of Oracle products on a system. The groups are selected by default.

Click Next.

Oracle Configuration Manager Registration

Enter the Customer Identification Number, the My Oracle Support (formerly OracleMetaLink) User Name, Country code and Click Next. The new screen prompts you to accept the license agreement. Click Accept License Agreement to accept the agreement.

If you decline this agreement, then consider Oracle Configuration Manager is installed but not configured.

Summary

Review the information displayed on this screen.

Click Install.

Install

This screen displays status information while the product is being installed.

Configuration Assistants

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

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


3.6 Installing Automatic Storage Management

Follow the procedures in this section to install and configure Automatic Storage Management, and to install Oracle Database so that it can use Automatic Storage Management. If you do not plan to use Automatic Storage Management, use the procedure in "Installing the Oracle Database Software" to install Oracle Database.

This section covers the following topics:

3.6.1 Step 1: Reviewing Automatic Storage Management Installation Considerations

When you install Automatic Storage Management, follow these guidelines:

  • Before you begin the installation, make sure that you have completed the steps in "Preparing Disk Groups for an Automatic Storage Management Installation" to prepare a disk partition to use for the Automatic Storage Management disk groups.

  • Oracle recommends that you install Automatic Storage Management into its own Oracle home, regardless of whether you plan to have one or multiple database instances. Installing Automatic Storage Management into its own Oracle home helps ensure higher availability and manageability.

    With separate Oracle homes, you can upgrade Automatic Storage Management and databases independently, and you can deinstall database software without impacting the Automatic Storage Management instance.

    If an Automatic Storage Management instance does not already exist and you select the Oracle Universal Installer option to install and configure Automatic Storage Management only, Oracle Universal Installer installs Automatic Storage Management in its own Oracle home.

  • Each computer that has one or more Oracle Database instances that will use Automatic Storage Management must have one Automatic Storage Management instance. For example, if a computer has two Oracle Database instances that use Automatic Storage Management, you only need one Automatic Storage Management instance for that computer, to manage the two database instances that use Automatic Storage Management.

  • When you install Automatic Storage Management, Oracle Database Configuration Assistant creates a separate server parameter file (SPFILE) and password file for the Automatic Storage Management instance.

3.6.2 Step 2: Creating the Automatic Storage Management Instance and Configuring Disk Groups

The following steps explain how to create an Automatic Storage Management instance and a disk group for storing the Oracle database files. You can create multiple disk groups for the Automatic Storage Management instance to manage, if you want. If you plan to use Automatic Storage Management for backup and recovery operations, Oracle recommends that you create a separate disk group for this purpose.

To install an Automatic Storage Management instance and configure its disk groups:

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

  2. Insert Oracle Database installation media and navigate to the database directory. Alternatively, navigate to the directory where you downloaded or copied the installation files. Double-click setup.exe to start Oracle Universal Installer.

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

  3. The Select a Product to Install screen enables you to install any one of the following products:

    • Oracle Database 11g

    • Oracle Client

    • Oracle Clusterware

    See Also:

    "Oracle Universal Installer Windows" for a detailed description of the screens used in this procedure
  4. On the Select Installation Method screen, select Advanced Installation and then click Next.

  5. On the Select Installation Type screen, select either Enterprise Edition, Standard Edition, Personal Edition, or Custom and then click Next.

  6. On the Install Location screen, the Oracle base path appears by default. You can change the path based on your requirement. In the Software Location section, accept the default values or enter an Automatic Storage Management-specific name and directory location for the Automatic Storage Management instance and Click Next.

    For example, you could change name OraDB11g_home1 to OraDB11g_asm and the directory location to the following:

    DRIVE LETTER:\oracle\product\11.1.0\asm
    

    Note:

    You can use OraDB11g_asm to represent a +ASM instance
  7. In the Product-Specific Prerequisite Checks screen, check that the requirements have been met and then click Next.

  8. On the Select Configuration Option screen, select Configure Automatic Storage Management (ASM) and then specify and confirm the Automatic Storage Management SYS password. Then, click Next.

  9. On the Configure Automatic Storage Management screen, enter the following settings:

    Note:

    This screen lets you create the disk groups to use with the Automatic Storage Management instance. You must have an available partition in order to create disk groups.
    • Disk Group Name: Enter a name for the disk group.

    • Redundancy: Select one of the following choices to set the redundancy level for the disks within the disk group. If you do not specify a redundancy level, the disk group defaults to normal redundancy.

      • High: With this option, the contents of the disk group are three-way mirrored by default. To create a disk group with high redundancy, you must specify at least three failure groups (a minimum of three devices).

      • Normal: In a normal redundancy level, by default the data files of the disk group are two-way mirrored and the control files are three-way mirrored. You can choose to create certain files that are three-way mirrored or not mirrored. To create a disk group with normal redundancy, you must specify at least two failure groups (a minimum of two devices) for two-way mirroring.

      • External: : Automatic Storage Management does not mirror the contents of the disk group. Choose this redundancy level when 1) the disk group contains devices, such as RAID devices, that provide their own data protection; or 2) the use of the database does not require uninterrupted access to data, for example, in a development environment where you have a suitable backup strategy.

    • Add Disks: Click Stamp Disks to start the asmtoolg GUI tool. In the asmtool operation dialog box, select Add or change label, and then click Next. From the list, select the disks that you want to use for the disk group. To select multiple disks, hold down the Control key and click to pick individual disks, or hold down the Shift key to select disks in a group. To use a specific prefix for this disk group, select Generate stamps with this prefix and enter a name. Click Next, and in the next window, click Finish.

      After you click Finish, the Configure Automatic Storage Management window returns, with the disks you selected in the Add Disks list. From this list, select the disks you want to include in the disk group. To filter the display of disks, you can select Change Disk Discovery Path and enter a wildcard subset. For example, to list all disks ending with ORCLDISKDATA from 0 to 3, you enter \\.\ORCLDISKDATA[0–3].

  10. Click Next.

  11. On the Install screen, check the installed contents, and then click Install.

  12. To create another disk group for this instance, run Oracle Database Configuration Assistant from the ORACLE_BASE\ORACLE_HOME\bin directory manually, and select the Configure Automatic Storage Management option.

At this stage, subsequent databases that you create are able to use Automatic Storage Management. If you have databases that were created before you installed Automatic Storage Management, you now can migrate them to Automatic Storage Management by using the Enterprise Manager Migrate Database wizard. This wizard is available in Enterprise Manager Grid Control or Database Control. Alternatively, you can use Oracle Database Recovery Manager (RMAN) to perform the migration.

See Also:

  • Enterprise Manager Migrate Database wizard online Help instructions on how to migrate an existing Oracle database to Automatic Storage Management

  • Oracle Database Backup and Recovery User's Guide for information on migrating an existing Oracle database to Automatic Storage Management using Oracle Database Recovery Manager.

3.6.3 Step 3: Installing Oracle Database to Use Automatic Storage Management

After you have created the Automatic Storage Management instance and Automatic Storage Management disk groups, you are ready to create a database instance that can use Automatic Storage Management.

To create a database instance to use with Automatic Storage Management:

  1. Log on as a member of the Administrators group to the computer 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 multi-homed 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. Start Oracle Universal Installer.

  4. The Select a Product to Install screen enables you to install any one of the following products:

    • Oracle Database 11g

    • Oracle Client

    • Oracle Clusterware

  5. On the Select Installation Type screen, select one of the installation types (Enterprise Edition, Standard Edition, Personal Edition, or Custom), and then click Next.

  6. On the Install location screen, the Oracle base path appears by default. You can change the path based on your requirement. In the Software Location section, accept the default values or select a different Oracle home from the home used for Automatic Storage Management.

  7. If you selected the Custom installation type, then select from the products to install.

  8. On the Product-Specific Prerequisite Checks screen, check that the requirements have been met and then click Next.

  9. On the Select Configuration Option screen, select Create a Database.

  10. On the Select Database Configuration screen, select from the database types displayed and click Next.

  11. On the Specify Database Configuration Options screen, enter the following settings and then click Next.

    • Specify the Global Database Name using the following syntax:

      database_name.domain
      

      where:

      • database_name with no more than 30 characters (alphanumeric, underscore (_), dollar ($), and pound (#)).

      • domain name with no more than 128 characters (alphanumeric, underscore (_), and pound (#)), inclusive of all periods.

    • Specify the SID with no more than 64 characters (alphanumeric, dollar ($), and pound (#)).

  12. On the Specify Database Config Details screen, enter the following configuration details, then click Next:

    • Memory

    • Character Sets

    • Security

    • Sample Schema

    See Also:

    "Oracle Universal Installer Windows" for further information about these fields.
  13. On the Select Database Management Option screen, select either Use Grid Control for Database Management if you have Oracle Enterprise Manager installed, or if you do not have Enterprise Manager, select Use Database Control for Database Management. Optionally, select Enable Email Notifications and then enter the outgoing SMTP server and e-mail address. Then, click Next.

    After you complete the installation, you can use either of these utilities to manage the Automatic Storage Management instance.

  14. On the Specify Database Storage Option screen, select Automatic Storage Management (ASM) and click Next.

  15. On the Specify Backup and Recovery Options screen, select the following:

    • Enable Automated Backups: Select this option, and then select Automatic Storage Management.

    • Backup Job Credentials: Enter the user name and password of the person responsible for managing backups.

  16. Click Next.

  17. On the Select Automatic Storage Management Disk Group screen, select the Automatic Storage Management disk group that you created in "Step 2: Creating the Automatic Storage Management Instance and Configuring Disk Groups" for recovery and backups.

    If the Automatic Storage Management disks that you selected do not provide enough space, the Configure Storage Management screen is displayed so that you can select additional disks as needed. As you select the disks, the Required Storage Space area adjusts the sizes displayed. Ideally, the Additional Space Needed value should be a negative number.

  18. Click Next.

  19. On the Specify Database Schema Passwords screen, enter and confirm passwords for the privileged database accounts, then click Next.

  20. On the Oracle Configuration Manager Registration screen, enter the Customer Identification Number, the My Oracle Support (formerly OracleMetaLink) User Name, Country code, and click Next. The new screen prompts you to accept the license agreement. Click Accept license Agreement to accept the agreement. However, if you decline this agreement, then Oracle Configuration Manager is installed but not configured.

  21. On the Summary screen, check that the contents to be installed are correct, and then click Install.

3.6.4 Step 4: Testing the Automatic Storage Management Installation

To test the Automatic Storage Management installation, try logging on to the Automatic Storage Management instance by using SQL*Plus.

Follow these steps:

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

  2. Open a Windows command prompt and temporarily set the ORACLE_HOME and ORACLE_SID to point to your Automatic Storage Management instance.

    For example, if the Automatic Storage Management SID, which is named +ASM, is located in the asm directory under the ORACLE_BASE directory, you would enter commands similar to the following:

    DRIVE_LETTER:\> set ORACLE_SID=+ASM
    DRIVE_LETTER:\> set ORACLE_HOME=ORACLE_BASE\product\11.1.0\asm
    
  3. From the same Windows command prompt session, connect to the Automatic Storage Management instance as the SYS user with 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;
    

See Also:

3.7 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 will have the patch updates.

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, as well as cloning Oracle homes.

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_BASE\ORACLE_HOME\OPatch> set ORACLE_HOME=ORACLE_HOME_using_patch
    c:\ORACLE_BASE\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 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.1.0\db_1, you would zip the db_1 directory, leaving out the admin, flash_recovery_area, and oradata directories that are under 11.1.0. These directories will be 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_BASE\ORACLE_HOME\network\admin directory, such as listener.ora, sqlnet.ora, and tnsnames.ora.

    2. From the oui\bin directory, run Oracle Universal Installer in clone mode for the unzipped Oracle home. Use the following syntax:

      c:\ORACLE_BASE\ORACLE_HOME\oui\bin> setup.exe -silent -clone ORACLE_BASE="target location" ORACLE_HOME="target location" ORACLE_HOME_NAME="unique_name_on node" [-responseFile full_directory_path]
      

      For example:

      c:\ORACLE_BASE\ORACLE_HOME\oui\bin> setup.exe -silent -clone ORACLE_BASE="c:\app\username"  ORACLE_HOME="c:\app\username\product\11.1.0\db_1" ORACLE_HOME_NAME="db_1"
      

      The -responseFile parameter is optional. You can supply clone-time parameters on the command line or by using the response file named on the command line.

    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 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 Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, and then Database Configuration Assistant.

See Also:

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

  1. Run the emSnapshotEnv script from bin directory as follows:

    ORACLE_HOME\ccr\bin\emSnapshotEnv.bat
    
  2. Copy the core.jar into pending directory as follows:

    copy ccr\inventory\core.jar ORACLE_HOME\ccr\inventory\pending
    
  3. Use the following command to remove the previous state files:

    del ORACLE_HOME\ccr\state\*.ll
    
  4. If you have removed the state files, then you must relink the core functions with the following command:

     ORACLE_HOME\ccr\bin\deployPackages
    
  5. Use the following command to rerun Oracle Configuration Manager:

     ORACLE_HOME\ccr\bin\configCCR