Installing Oracle Database

Oracle Database and Oracle Grid Infrastructure installation software is available on multiple media, and can be installed using several options.

The Oracle Database software is available on installation media, or you can download it from the Oracle Technology Network website, or the Oracle Software Delivery Cloud portal. In most cases, Oracle Universal Installer provides a graphical user interface (GUI) to install the software. However, you can also use Oracle Universal Installer to complete silent mode installations, without using the GUI.

Note:

  • If you plan to use Oracle Restart or Oracle Automatic Storage Management, then you must install Oracle Grid Infrastructure for a standalone server before you install and create the database. Otherwise, you must manually register the database with Oracle Restart. For information about installing Oracle Grid Infrastructure, see

  • You may have to shut down existing Oracle processes before you start the database installation.

  • To install Oracle Database using the silent or response file installation method, without the GUI. It also explains how to clone an existing Oracle home. These methods are useful to perform multiple installations of Oracle Database.

To install the Oracle Database software:

  1. Log in to Windows as an Administrator user.

    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 multiple 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. Navigate to the location of the installation media for Oracle Database 12c Release 2 (12.2), open a command prompt with administrator privileges, and run the setup.exe command.

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

  4. Follow these guidelines to complete the installation:
    • Do not install Oracle Database 12c software into an existing Oracle home.

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

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

  5. When the Configuration Assistant tasks are complete, click Finish, click Exit, then click Yes to exit from Oracle Universal Installer.
  6. 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.

  7. See 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 12c:

Table 6-2 Oracle Universal Installer Windows

Screen Action

Configure Security Updates

Enter your e-mail address, preferably your My Oracle Support 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 password in the My Oracle Support Password field.

Click Next.

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 enables minimal configuration. This option is designed for those who want to quickly set up a database.

  • Server Class: Choose this option if you are installing on a server class system, such as when deploying Oracle in a production data center. This option enables 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 Cloud 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 Node database.

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 you 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 Database Edition

Select Enterprise Edition or Standard Edition 2. Click Next

Specify Oracle Home User

Starting with Oracle Database 12c, Oracle recommends that you use Virtual Account or specify a standard Windows User Account (not an Administrator account) to install and configure the Oracle home. This account is used for running the Windows services for the Oracle home. Do not log in using this account to perform administrative tasks. Select one of the following, then click Next.

  • Use Virtual Account User

    The account is the Oracle Home User for Oracle Database Single Instance and Client installations. The account enables you to install Oracle Database, create, and manage database services without passwords.

  • Use Existing Windows User

    The account can be a Windows Local User, Windows Domain User, Windows Managed Services Account (MSA), or a Windows Group Managed Services Account (gMSA). You must provide both the user name and password for a Windows Local or Domain User. For a Windows MSA, which is a managed domain account, only the user name is required. For a Windows gMSA, which is also a managed domain account, only the user name is required.

  • Create New Windows User

    Provide the user name and password for the Windows Local User that you want Oracle Universal Installer to create. Confirm the password. The new user that is created is denied interactive logon privileges to the Windows computer. However, a Windows administrator can manage this account like any other Windows account.

Select Use Windows Built-in Account if you do not want to specify an Oracle Home User during installation. No user name or password is required and the Windows services for the Oracle home run as the LocalSystem or LocalService.

For Database Server installation, Oracle recommends that you use a standard Windows User Account (instead of Windows Built-in Account) or Virtual Account as the Oracle Home User for enhanced security.

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 must not contain spaces.

Click Next.

Note: This screen is available only with Advanced Installation.

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 ASCII alphanumeric (A-Za-Zz0-9), 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 must contain no more than 128 characters (ASCII alphanumeric (A-Za-Zz0-9), 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 (#).

Select the Create as Container database option to create the database as a multitenant container database (CDB) that can support one pluggable database (PDB). If you want Oracle Universal Installer to create a PDB when it creates the CDB, specify the PDB name in the Pluggable Database Name field.

The PDB name must be unique and must follow the database naming conventions.

To create additional PDBs and to manage PDBs, use Oracle Database Configuration Assistant.

See Also: Oracle Database 2 Day DBA

Specify Configuration Options

Specify the following configuration details, then click Next.

Memory:

Select the Enable Automatic Memory Management option to allow the database to automatically distribute memory between SGA and PGA. If you do not select this option, then the SGA and PGA must be sized manually.

Character Sets:

This option enables you to select the character set used to store and process character data in the database. The choices are:

  • Use Unicode (AL32UTF8): The database character set is AL32UTF8 and the database can process most languages of the world.

  • Use OS character set (WE8MSWN1252): The database character set (WE8MSWN1252) is based on the language of the operating system.

  • Choose from the following list of character sets: This option enables the Select database character set drop down list.

See Also: Oracle Database Globalization Support Guide

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. If you create the database as a CDB with one PDB, then the sample schema is created as a PDB.

Note: By default, Oracle database is configured to include enhanced security settings.

Specify Database Storage Options

Select one of the following, then click Next.

  • File System: Specify the database file location.

  • Oracle Automatic Storage Management.

Specify Management Options

This screen gives you the option to manage your database using Oracle Enterprise Manager Cloud Control. Select Register with Enterprise Manager (EM) Cloud Control and specify the following for Oracle Enterprise Manager Cloud Control configuration, and click Next:

  • OMS Host: This is the system name where the Management repository is running.

  • OMS Port: This is the Oracle Enterprise Manager port number to receive requests from the Management service.

  • EM Admin User Name: This is the user name to log in to Oracle Enterprise Manager.

  • EM Admin Password: This is the password to log in to Oracle Enterprise Manager.

  • Specify password of ASMSNMP user: This is the password for the ASMSNMP user configured in Oracle ASM, required only if you choose Oracle ASM as your database storage option.

Note: Oracle Enterprise Manager Database Express is always installed and configured by default irrespective of whether you register Oracle Enterprise Manager Cloud Control.

Specify Recovery Options

Select Enable Recovery to enable recovery using one of the following options:

  • 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 Automatic Storage Management disk group for the fast recovery area.

    Click Next.

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, and DBSNMP.

If you chose to create the database as a CDB, then Oracle Universal Installer also asks for the PDBADMIN password.

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.

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: for information about the system requirements.

Summary

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

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