Installing Client Access Express Download

-->

If Microsoft Excel was installed on your PC before Client Access Express, the Client Access Express setup program automatically installs the Microsoft Excel add-in when you choose to install Data transfer Excel Add-in support. This support is installed during a typical and full installation but may not have been installed in a custom or 5250.

APPLIES TO: SQL Server (Windows only) Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

This article explains how to install SQL Server with the Installation Wizard. It applies to SQL Server 2016 (13.x) and SQL Server 2017 (14.x).

This article provides a step-by-step procedure for installing a new instance of SQL Server by using the SQL Server Setup Installation Wizard. The Installation Wizard provides a single feature tree for installation of all SQL Server components so that you don't have to install them individually. To install the SQL Server components individually, see Install SQL Server.

For other ways to install SQL Server, see:

Get the installation media

The download location for SQL Server depends on the edition:

SQL Server Enterprise, Standard, and Express Editions are licensed for production use. For the Enterprise and Standard Editions, contact your software vendor for the installation media. You can find purchasing information and a directory of Microsoft partners on the Microsoft purchasing website.
The latest free edition.

Prerequisites

Installing Client Access Express Download

Before you install SQL Server, review Planning a SQL Server installation.

Note

For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share.

Install patch requirement

Microsoft has identified a problem with the Microsoft Visual C++ 2013 runtime binaries that are installed as a prerequisite by SQL Server 2016 and 2017. An update is available to fix this problem. If this update to the Visual C++ runtime binaries isn't installed, SQL Server may experience stability issues in certain scenarios. Before you install SQL Server, follow the instructions in the SQL Server release notes to see if your computer requires a patch for the Visual C++ runtime binaries.

This is not applicable to SQL Server 2019 (15.x).

To install SQL Server 2016 and 2017

Insert the SQL Server installation media. From the root folder, double-click Setup.exe. To install from a network share, locate the root folder on the share, and then double-click Setup.exe.
The Installation Wizard runs the SQL Server Installation Center. To create a new installation of SQL Server, select Installation in the left navigation area, and then select New SQL Server standalone installation or add features to an existing installation.
On the Product Key page, select an option to indicate whether you're installing a free edition of SQL Server or a production version that has a PID key. For more information, see Editions and supported features of SQL Server 2017.
To continue, select Next.
On the License Terms page, review the license agreement. If you agree, select the I accept the license terms check box, and then select Next.
Note
SQL Server transmits information about your installation experience, as well as other usage and performance data to help Microsoft improve the product. To learn more about SQL Server data processing and privacy controls, see the privacy statement and Configure SQL Server to send feedback to Microsoft.
In the Global Rules page, Setup will automatically advance to the Product Updates page if there are no rule errors.
The Microsoft Update page will appear next if the Microsoft Update check box in Control Panel > All Control Panel Items > Windows Update > Change settings isn't selected. Selecting the Microsoft Update check box changes the computer settings to include the latest updates for all Microsoft products when you scan for Windows updates.
On the Product Updates page, the latest available SQL Server product updates are displayed. If no product updates are discovered, Setup doesn't display this page and automatically advances to the Install Setup Files page.
On the Install Setup Files page, Setup provides the progress of downloading, extracting, and installing the Setup files. If an update for Setup is found and you specify to include it, that update will also be installed. If no update is found, Setup will automatically advance.
On the Install Rules page, Setup checks for potential problems that might occur while running Setup. If failures occur, select an item in the Status column for more information. Otherwise, select Next.
If this is the first installation of SQL Server on the machine, Setup skips the Installation Type page and goes directly to the Feature Selection page. If SQL Server is already installed on the system, you can use the Installation Type page to select either to perform a new installation or to add features to an existing installation. To continue, select Next.
On the Feature Selection page, select the components for your installation. For example, to install a new instance of SQL Server Database Engine, select Database Engine Services.
A description for each component group appears in the Feature description pane after you select the feature name. You can select any combination of check boxes. For more information, see Editions and components of SQL Server 2016 or Editions and components of SQL Server 2017.
The prerequisites for the selected features are displayed in the Prerequisites for selected features pane. Setup installs the prerequisites that aren't already installed during the installation step described later in this procedure.
You can also specify a custom directory for shared components by using the field at the bottom of the Feature Selection page. To change the installation path for shared components, either update the path in the field at the bottom of the dialog box or select Browse to go to an installation directory. The default installation path is C:Program FilesMicrosoft SQL Servernnn.
Note
The path specified for the shared components must be an absolute path. The folder must not be compressed or encrypted. Mapped drives aren't supported.
SQL Server uses two directories for shared features:
- Shared feature directory
- Shared feature directory (x86)
Note
The path specified for each of the above options must be different.
The Feature Rules page automatically advances if all rules pass.
On the Instance Configuration page, specify whether to install a default instance or a named instance. For more information, see Instance configuration.
- Instance ID: By default, the instance name is used as the instance ID. This ID is used to identify the installation directories and registry keys for your instance of SQL Server. The same behavior occurs for default instances and named instances. For a default instance, the instance name and instance ID are MSSQLSERVER. To use a nondefault instance ID, specify a different value in the Instance ID text box.
  Note
  Typical standalone instances of SQL Server, whether default or named instances, don't use a nondefault value for the instance ID.
  All SQL Server service packs and upgrades apply to every component of an instance of SQL Server.
- Installed instances: The grid shows the instances of SQL Server that are on the computer where Setup is running. If a default instance is already installed on the computer, you must install a named instance of SQL Server.
The workflow for the rest of the installation depends on the features that you've specified for your installation. Depending on your selections, you might not see all the pages.
Selecting to install the Polybase feature will add the PolyBase Configuration page to the SQL Server setup, displayed after the Instance Configuration page. PolyBase requires the Oracle JRE 7 Update 51 (at least), and if this hasn't already been installed, your installation will be blocked. On the Polybase Configuration page, you can choose to use the SQL Server as a standalone Polybase-enabled instance, or you can use this SQL Server as part of a PolyBase scale-out group. If you choose to use the scale-out group, you will need to specify a port range of up to 6 or more ports.
Use the Server Configuration - Service Accounts page to specify the logon accounts for SQL Server services. The actual services that you configure on this page depend on the features that you selected to install. For more information about configuration settings, see Installation Wizard help.
You can assign the same logon account to all SQL Server services, or you can configure each service account individually. You can also specify whether services start automatically, start manually, or are disabled. We recommend you configure service accounts individually to provide the least privileges for each service. Make sure SQL Server services are granted the minimum permissions they must have to complete their tasks. For more information, see Configure Windows service accounts and permissions.
To specify the same logon account for all service accounts in this instance of SQL Server, provide the credentials in the fields at the bottom of the page.
Important
Do not use a blank password. Use a strong password.
Note
Starting with SQL Server 2016 (13.x), select the Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service check box to allow the SQL Server Database Engine service account to use database instant file initialization.
Use the Server Configuration - Collation page to specify non-default collations for the Database Engine and Analysis Services.
The default installation setting is determined by the operating system (OS) locale. The server-level collation can either be changed during setup, or by changing the OS locale before installation. The default collation is set to the oldest available version that is associated with each specific locale. This is due to backwards compatibility reasons. Therefore, this is not always the recommended collation. To take full advantage of SQL Server features, change the default installation settings to use Windows collations. For example, for the OS locale English (United States) (code page 1252), the default collation during setup is SQL_Latin1_General_CP1_CI_AS and can be changed to its closest Windows collation counterpart Latin1_General_100_CI_AS_SC.
For more information, see Collations and Unicode support.
Use the Database Engine Configuration - Server Configuration page to specify the following options:
- Security Mode: Select Windows Authentication or Mixed Mode Authentication for your instance of SQL Server. If you select Mixed Mode Authentication, you must provide a strong password for the built-in SQL Server system administrator account.
  After a device establishes a successful connection to SQL Server, the security mechanism is the same for both Windows authentication and mixed mode authentication. For more information, see Database Engine Configuration - Server Configuration page.
- SQL Server Administrators: You must specify at least one system administrator for the instance of SQL Server. To add the account under which SQL Server Setup is running, select Add Current User. To add or remove accounts from the list of system administrators, select Add or Remove, and then edit the list of users, groups, or computers that have administrator privileges for the instance of SQL Server.
Use the Database Engine Configuration - Data Directories page to specify nondefault installation directories. To install to the default directories, select Next.
Important
If you specify nondefault installation directories, ensure that the installation folders are unique to this instance of SQL Server. None of the directories in this dialog box should be shared with directories from other instances of SQL Server.
For more information, see Database Engine Configuration - Data Directories page.
Use the Database Engine Configuration - TempDB page to configure the file size, number of files, nondefault installation directories, and file-growth settings for tempdb. For more information, see Database Engine Configuration - TempDB page.
Use the Database Engine Configuration - FILESTREAM page to enable FILESTREAM for your instance of SQL Server. For more information, see Database Engine Configuration - FILESTREAM page.
Use the Analysis Services Configuration - Account Provisioning page to specify the server mode and the users or accounts that have administrator permissions for Analysis Services. The server mode determines which memory and storage subsystems are used on the server. Different solution types run in different server modes. If you plan to run multidimensional cube databases on the server, select the default server mode option, Multidimensional and Data Mining.
You must specify at least one system administrator for Analysis Services:
- To add the account under which SQL Server Setup is running, select Add Current User.
- To add or remove accounts from the list of system administrators, select Add or Remove, and then edit the list of users, groups, or computers that have administrator privileges for Analysis Services.
For more information about server mode and administrator permissions, see Analysis Services Configuration - Account Provisioning page.
When you're finished editing the list, select OK. Verify the list of administrators in the configuration dialog box. After the list is complete, select Next.
Use the Analysis Services Configuration - Data Directories page to specify nondefault installation directories. To install to the default directories, select Next.
Important
When installing SQL Server, if you specify the same directory path for INSTANCEDIR and SQLUSERDBDIR, SQL Server Agent and Full Text Search won't start due to missing permissions.
If you specify nondefault installation directories, ensure that the installation folders are unique to this instance of SQL Server. None of the directories in this dialog box should be shared with directories from other instances of SQL Server.
For more information, see Analysis Services Configuration - Data Directories page.
Use the Distributed Replay Controller Configuration page to specify the users you want to grant administrative permissions to for the Distributed Replay controller service. Users that have administrative permissions have unlimited access to the Distributed Replay controller service.
- To grant access permissions for the Distributed Replay controller service to the user who's running SQL Server Setup, select the Add Current User button.
- To grant access permissions for the Distributed Replay controller service to other users, select the Add button.
- To remove access permissions from the Distributed Replay controller service, select the Remove button.
- To continue, select Next.
Use the Distributed Replay Client Configuration page to specify the users you want to grant administrative permissions to for the Distributed Replay client service. Users that have administrative permissions have unlimited access to the Distributed Replay client service.
- Controller Name is optional. The default value is <blank>. Enter the name of the controller that the client computer will communicate with for the Distributed Replay client service:
  - If you've already set up a controller, enter the name of the controller while configuring each client.
  - If you haven't yet set up a controller, you can leave the controller name blank. However, you must manually enter the controller name in the client configuration file.
- Specify the Working Directory for the Distributed Replay client service. The default working directory is <drive letter>:Program FilesMicrosoftSQL ServerDReplayClientWorkingDir.
- Specify the Result Directory for the Distributed Replay client service. The default result directory is <drive letter>:Program FilesMicrosoftSQL ServerDReplayClientResultDir.
- To continue, select Next.
The Ready to Install page shows a tree view of the installation options that you specified during Setup. On this page, Setup indicates whether the Product Update feature is enabled or disabled and the final update version.
To continue, select Install. SQL Server Setup first installs the required prerequisites for the selected features, then it installs the selected features.
During installation, the Installation Progress page provides status updates so that you can monitor the installation progress as Setup continues.
After installation, the Complete page provides a link to the summary log file for the installation and other important notes.
Important
Make sure you read the message from the Installation Wizard when you've finished with Setup. For more information, see View and read SQL Server Setup log files.
To complete the SQL Server installation process, select Close.
If you're instructed to restart the computer, do so now.

To install SQL Server 2019

Insert the SQL Server installation media. From the root folder, double-click Setup.exe. To install from a network share, locate the root folder on the share, and then double-click Setup.exe.
The Installation Wizard runs the SQL Server Installation Center. To create a new installation of SQL Server, select Installation in the left navigation area, and then select New SQL Server standalone installation or add features to an existing installation.
On the Product Key page, select an option to indicate whether you're installing a free edition of SQL Server or a production version that has a PID key. For more information, see Editions and supported features of SQL Server 2017.
To continue, select Next.
On the License Terms page, review the license agreement. If you agree, select the I accept the license terms and privacy statement check box, and then select Next.
Note
If an Enterprise Server/CAL license Product Key is entered, and the machine has more than 20 physical cores, or 40 logical cores when Hyper-Threading is enabled, a warning is shown during setup. You can still continue setup by selecting the Check this box to acknowledge this limitation or click Back/Cancel to enter an Enterprise Core product license that supports the operating system maximum check box, or click Back and enter a License Key that supports the operating system maximum number of processors.
Note
SQL Server transmits information about your installation experience, as well as other usage and performance data to help Microsoft improve the product. To learn more about SQL Server data processing and privacy controls, see the privacy statement and Configure SQL Server to send feedback to Microsoft.
In the Global Rules page, Setup will automatically advance to the Product Updates page if there are no rule errors.
The Microsoft Update page will appear next if the Microsoft Update check box in Control Panel > All Control Panel Items > Windows Update > Change settings isn't selected. Selecting the Microsoft Update check box changes the computer settings to include the latest updates for all Microsoft products when you scan for Windows updates.
On the Product Updates page, the latest available SQL Server product updates are displayed. If no product updates are discovered, Setup doesn't display this page and automatically advances to the Install Setup Files page.
On the Install Setup Files page, Setup provides the progress of downloading, extracting, and installing the Setup files. If an update for Setup is found and you specify to include it, that update will also be installed. If no update is found, Setup will automatically advance.
On the Install Rules page, Setup checks for potential problems that might occur while running Setup. If failures occur, select an item in the Status column for more information. Otherwise, select Next.
If this is the first installation of SQL Server on the machine, Setup skips the Installation Type page and goes directly to the Feature Selection page. If SQL Server is already installed on the system, you can use the Installation Type page to select either to perform a new installation or to add features to an existing installation. To continue, select Next.
On the Feature Selection page, select the components for your installation. For example, to install a new instance of SQL Server Database Engine, select Database Engine Services.
A description for each component group appears in the Feature description pane after you select the feature name. You can select any combination of check boxes. For more information, see Editions and components of SQL Server 2016 or Editions and components of SQL Server 2017.
The prerequisites for the selected features are displayed in the Prerequisites for selected features pane. Setup installs the prerequisites that aren't already installed during the installation step described later in this procedure.
You can also specify a custom directory for shared components by using the field at the bottom of the Feature Selection page. To change the installation path for shared components, either update the path in the field at the bottom of the dialog box or select Browse to go to an installation directory. The default installation path is C:Program FilesMicrosoft SQL Servernnn.
Note
The path specified for the shared components must be an absolute path. The folder must not be compressed or encrypted. Mapped drives aren't supported.
SQL Server uses two directories for shared features:
- Shared feature directory
- Shared feature directory (x86)
Note
The path specified for each of the above options must be different.
The Feature Rules page automatically advances if all rules pass.
On the Instance Configuration page, specify whether to install a default instance or a named instance. For more information, see Instance configuration.
- Instance ID: By default, the instance name is used as the instance ID. This ID is used to identify the installation directories and registry keys for your instance of SQL Server. The same behavior occurs for default instances and named instances. For a default instance, the instance name and instance ID are MSSQLSERVER. To use a nondefault instance ID, specify a different value in the Instance ID text box.
  Note
  Typical standalone instances of SQL Server, whether default or named instances, don't use a nondefault value for the instance ID.
  All SQL Server service packs and upgrades apply to every component of an instance of SQL Server.
- Installed instances: The grid shows the instances of SQL Server that are on the computer where Setup is running. If a default instance is already installed on the computer, you must install a named instance of SQL Server.
The workflow for the rest of the installation depends on the features that you've specified for your installation. Depending on your selections, you might not see all the pages.
Starting with SQL Server 2019 (15.x), Polybase no longer requires that Oracle JRE 7 Update 51 (at least) be pre-installed on the computer prior to installing the feature. Selecting to install the Polybase feature will add the Java Install Location page to the SQL Server setup displayed after the Instance Configuration page. On the Java Install Location page, you can choose to install the Azul Zulu Open JRE included with the SQL Server 2019 (15.x) installation, or provide a location of a different JRE or JDK that has already been installed on the computer.
Starting with SQL Server 2019 (15.x), Java has been added with Language Extensions. Selecting to install the Java feature will add the Java Install Location page to the SQL Server setup dialog window, displayed after the Instance Configuration page. On the Java Install Location page, you can choose to install the Zulu Open JRE included with the SQL Server 2019 (15.x) installation, or provide a location of a different JRE or JDK that has already been installed on the computer.
Use the Server Configuration - Service Accounts page to specify the logon accounts for SQL Server services. The actual services that you configure on this page depend on the features that you selected to install. For more information about configuration settings, see Installation Wizard help.
You can assign the same logon account to all SQL Server services, or you can configure each service account individually. You can also specify whether services start automatically, start manually, or are disabled. We recommend you configure service accounts individually to provide the least privileges for each service. Make sure SQL Server services are granted the minimum permissions they must have to complete their tasks. For more information, see Configure Windows service accounts and permissions.
To specify the same logon account for all service accounts in this instance of SQL Server, provide the credentials in the fields at the bottom of the page.
Important
Do not use a blank password. Use a strong password.
Note
Starting with SQL Server 2016 (13.x), select the Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service check box to allow the SQL Server Database Engine service account to use database instant file initialization.
Use the Server Configuration - Collation page to specify nondefault collations for the Database Engine and Analysis Services. For more information, see Collations and Unicode support.
Use the Database Engine Configuration - Server Configuration page to specify the following options:
- Security Mode: Select Windows Authentication or Mixed Mode Authentication for your instance of SQL Server. If you select Mixed Mode Authentication, you must provide a strong password for the built-in SQL Server system administrator account.
  After a device establishes a successful connection to SQL Server, the security mechanism is the same for both Windows authentication and mixed mode authentication. For more information, see Database Engine Configuration - Server Configuration page.
- SQL Server Administrators: You must specify at least one system administrator for the instance of SQL Server. To add the account under which SQL Server Setup is running, select Add Current User. To add or remove accounts from the list of system administrators, select Add or Remove, and then edit the list of users, groups, or computers that have administrator privileges for the instance of SQL Server.
Use the Database Engine Configuration - Data Directories page to specify nondefault installation directories. To install to the default directories, select Next.
Important
If you specify nondefault installation directories, ensure that the installation folders are unique to this instance of SQL Server. None of the directories in this dialog box should be shared with directories from other instances of SQL Server.
For more information, see Database Engine Configuration - Data Directories page.
Use the Database Engine Configuration - TempDB page to configure the file size, number of files, nondefault installation directories, and file-growth settings for tempdb. For more information, see Database Engine Configuration - TempDB page.
Use the Database Engine Configuration - MaxDOP page to specify your max degree of parallelism. This setting determines how many processors a single statement can use during execution. The recommended value is automatically calculated during installation.
Note
This page is only available in Setup starting with SQL Server 2019 (15.x).
For more information, see the Database Engine Configuration - MaxDOP page.
Use the Database Engine Configuration - Memory page to specify the min server memory and max server memory values that this instance of SQL Server will use after startup. You can use the default values, use the calculated recommended values, or manually specify your own values after you've chosen the Recommended option.
Note
This page is only available in Setup starting with SQL Server 2019 (15.x).
For more information, see the Database Engine Configuration - Memory page.
Use the Database Engine Configuration - FILESTREAM page to enable FILESTREAM for your instance of SQL Server. For more information, see Database Engine Configuration - FILESTREAM page.
Use the Analysis Services Configuration - Account Provisioning page to specify the server mode and the users or accounts that have administrator permissions for Analysis Services. The server mode determines which memory and storage subsystems are used on the server. Different solution types run in different server modes. If you plan to run multidimensional cube databases on the server, select the default server mode option, Multidimensional and Data Mining.
You must specify at least one system administrator for Analysis Services:
- To add the account under which SQL Server Setup is running, select Add Current User.
- To add or remove accounts from the list of system administrators, select Add or Remove, and then edit the list of users, groups, or computers that have administrator privileges for Analysis Services.
For more information about server mode and administrator permissions, see Analysis Services Configuration - Account Provisioning page.
When you're finished editing the list, select OK. Verify the list of administrators in the configuration dialog box. After the list is complete, select Next.
Use the Analysis Services Configuration - Data Directories page to specify nondefault installation directories. To install to the default directories, select Next.
Important
When installing SQL Server, if you specify the same directory path for INSTANCEDIR and SQLUSERDBDIR, SQL Server Agent and Full Text Search won't start due to missing permissions.
If you specify nondefault installation directories, ensure that the installation folders are unique to this instance of SQL Server. None of the directories in this dialog box should be shared with directories from other instances of SQL Server.
For more information, see Analysis Services Configuration - Data Directories page.
Use the Distributed Replay Controller Configuration page to specify the users you want to grant administrative permissions to for the Distributed Replay controller service. Users that have administrative permissions have unlimited access to the Distributed Replay controller service.
- To grant access permissions for the Distributed Replay controller service to the user who's running SQL Server Setup, select the Add Current User button.
- To grant access permissions for the Distributed Replay controller service to other users, select the Add button.
- To remove access permissions from the Distributed Replay controller service, select the Remove button.
- To continue, select Next.
Use the Distributed Replay Client Configuration page to specify the users you want to grant administrative permissions to for the Distributed Replay client service. Users that have administrative permissions have unlimited access to the Distributed Replay client service.
- Controller Name is optional. The default value is <blank>. Enter the name of the controller that the client computer will communicate with for the Distributed Replay client service:
  - If you've already set up a controller, enter the name of the controller while configuring each client.
  - If you haven't yet set up a controller, you can leave the controller name blank. However, you must manually enter the controller name in the client configuration file.
- Specify the Working Directory for the Distributed Replay client service. The default working directory is <drive letter>:Program FilesMicrosoftSQL ServerDReplayClientWorkingDir.
- Specify the Result Directory for the Distributed Replay client service. The default result directory is <drive letter>:Program FilesMicrosoftSQL ServerDReplayClientResultDir.
- To continue, select Next.
The Ready to Install page shows a tree view of the installation options that you specified during Setup. On this page, Setup indicates whether the Product Update feature is enabled or disabled and the final update version.
To continue, select Install. SQL Server Setup first installs the required prerequisites for the selected features, then it installs the selected features.
During installation, the Installation Progress page provides status updates so that you can monitor the installation progress as Setup continues.
After installation, the Complete page provides a link to the summary log file for the installation and other important notes.
Important
Make sure you read the message from the Installation Wizard when you've finished with Setup. For more information, see View and read SQL Server Setup log files.
To complete the SQL Server installation process, select Close.
If you're instructed to restart the computer, do so now.

Next steps

Configure your new SQL Server installation.

To reduce the attackable surface area of a system, SQL Server selectively installs and enables key services and features. For more information, see Surface area configuration.

3.1 Preinstallation Considerations Before Installing Oracle Database Client

The Oracle Database Client software is available on the Oracle Technology Network (OTN) Web site. In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install the software. However, you can also use Oracle Universal Installer to complete silent-mode installations using response files, without using the GUI.

Review the information in Chapter 1, 'Oracle Database Client Installation Overview' and complete the tasks listed in Chapter 2, 'Oracle Database Client Preinstallation Requirements' before beginning the installation.

Next, consider the following issues:

3.1.1 Installation Consideration on Windows Vista and Later

On Windows Vista, Windows Server 2008, Windows Server 2008 R2, Windows 7, Windows 8, Windows 8.1, Windows Server 2012, and Windows Server 2012 R2, command prompts should be opened with Administrator privileges.

See Also:

'Managing User Accounts with User Account Control'

3.1.2 Installing Oracle Database Client Installations in Silent or Response File Mode

If you need to perform multiple installations of Oracle Database Client, you may want to use silent or response file mode, with response files. In these modes, at each computer, you run Oracle Universal Installer from the command line using a response file. The response file is a text file containing the settings you normally enter in the Oracle Universal Installer GUI dialog boxes. This method lets you quickly perform multiple installations using similar settings for each computer.

See Also:

Appendix B, 'Installing Oracle Database Client Using Response Files' for instructions on performing silent or response file mode installations

3.1.3 Creating the Oracle Base Directory

If you install Oracle Database Client on a computer with no other Oracle software installed, Oracle Universal Installer creates an Oracle base directory for you. If Oracle software is already installed, one or more Oracle base directories already exist. In the latter case, Oracle Universal Installer offers you a choice of Oracle base directories into which you can install Oracle Database Client.

You are not required to create an Oracle base directory before installation, but you can do so if you want.

Note:

You can choose to create a new Oracle base directory, even if other Oracle base directories exist on the system.

3.1.4 Installing Oracle Database Client into Multiple Oracle Homes

You can install all Oracle components in multiple Oracle homes on the same computer. However, some components can only support one active instance at a time. This means that the current (latest) installation renders the previous one inactive. These components are:

Oracle Administration Assistant for Windows
Oracle Counters for Windows Performance Monitor
Oracle Objects for OLE on Windows 32-bit
Oracle Provider for OLE DB

Note:

Oracle Objects for OLE is not supported on Windows x64.

3.1.5 Installing Oracle Database Client on a System with an Existing Oracle Software

Oracle Database Client can be installed in the same Oracle Database home if both products are at the same release level. For example, you can install Oracle Database Client 10g Release 2 (10.2) into an existing Oracle Database 10g Release 2 (10.2) home. If you apply a patch set before installing the client, then you must apply the patch set again. Oracle Universal Installer will prompt you for an Oracle home directory, whether you have other Oracle software installed on the computer or not. You cannot install products from one release of Oracle Database Client into an Oracle home directory of a different release. For example, you cannot install Oracle Database 11g release 1 (11.1) software into an existing Oracle9i Oracle home directory.

You can install this release more than once on the same system as long as each installation is installed in a separate Oracle home directory.

3.1.6 Updating the Existing Software with the Current Version

Use the In-Place Upgrade feature to upgrade an existing client installation to the latest release by installing the new client software into an existing client home with the same installation type. For example, if release 11.2.0.1 is installed, then use Oracle Universal Installer to upgrade to release 11.2.0.2.

Consider the following before selecting this option:

This upgrade is only possible in a client home and not in any other Oracle home that contains non-client installations, such as Database installations.
This upgrade does not delete files in the client home that are commonly updated by other users. For example, configuration data files.
This upgrade cannot be performed if processes associated with the Oracle Database Client home are running.

This functionality is available starting with Oracle Database 11g Release 2 (11.2.0.2).

See Also:

'Performing an In-place Oracle Database Client Upgrade'

3.2 Accessing the Installation Software

The Oracle Database Client software is available on installation media or you can download it from the Oracle Technology Network (OTN) Web site, or Oracle Software Delivery 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 Client by using the following scenarios:

3.2.1 Installing from a Remote DVD Drive

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

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

Log in to the remote computer as an Administrator user.
Start Windows Explorer.
Right-click the DVD drive letter and choose Sharing (or Sharing and Security).
Click the Sharing tab and do the following:
1. Select Share this folder.
2. In Share name, give it a share name such as dvd. You will 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 will be accessing it to install Oracle Database.
4. Click OK when you are finished.
Insert the DVD labeled Oracle Database 11g Release 2 (11.2) into the DVD drive.

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

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.
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:
  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
5. If you need to connect to the remote computer as a different user, click different user name, and enter the username.
6. Click Finish.
Run Oracle Universal Installer from the mapped DVD drive.
Go to the 'Installing the Oracle Database Client Software' section.

3.2.2 Installing on Remote Computers Through Remote Access Software

If you want to install and run Oracle Database Client on a remote computer (that is, the remote computer has the hard drive and will run Oracle Database Client 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 Client on the remote computer in one of two ways:

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

3.2.2.1 Installing on Remote Computers from a Hard Drive

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

The steps that must complete are:

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

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

The steps that you need to complete are:

Make sure that the remote access software is installed and running on the remote and local computers.
On the local computer, share the DVD drive.
On the remote computer, map a drive letter to the shared DVD drive. You would use the remote access software to do this on the remote computer.
These steps are described in the 'Installing from a Remote DVD Drive' section.
Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared DVD drive.
Go to Section 3.3, 'Installing the Oracle Database Client Software.'

3.2.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. Make sure that you completely review and understand the terms of the license. Most downloads include the Development License. This section contains the following topics:

3.2.3.1 Downloading the Installation Archive Files from OTN

To download the installation archive files from Oracle Technology Network:

Use any browser to access the software download page from Oracle Technology Network:
Navigate to the download page for the product that you want to install.
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 filenames.
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 the archive files.
On the file system that you selected in step 4, create a parent directory for each product, for example OraDBClient11g, to hold the installation directories.
Download all of the installation archive files to the directories that you created in step 5.
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.
Extract the files in each directory that you just created.
After you have extracted the required installation files, see the 'Installing the Oracle Database Client Software' section.

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

Use any browser to access the Oracle Software Delivery Cloud Web site:
Complete the Export Validation process by entering information (name, company, e-mail address, and country) in the online form.
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.
Optionally, select the relevant product to download from the Results list.
In the search results page, click Readme to download and review the Readme file for download instructions and product information.
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 that you may need to refer during the installation process.
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:

My Oracle Support note 549617.1 for information on how to verify the integrity of a software download at
Frequently Asked Questions section on the Oracle Software Delivery Cloud Web site for more information about Media Packs

3.2.3.3 Extracting the Installation Files

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

If necessary, change to the directory that contains the downloaded installation archive files.
The Oracle Database software is available as a zip file. Ensure that you extract the zip file to the same directory.
When you have extracted all of the required installation files, see 'Installing the Oracle Database Client Software' section .

3.2.4 Copying the Oracle Database Client Software to a Hard Disk

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

Create a directory for the installation files on your hard drive. For example:
Copy the contents of the installation media to the directory that you just created.

When you have copied the required installation files, see the 'Installing the Oracle Database Client Software' section.

3.3 Installing the Oracle Database Client Software

This section covers the following topics:

3.3.1 Guidelines for Installing Oracle Database Client

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

As you install Oracle Database Client, follow these guidelines:

See Also:

Appendix B, 'Installing Oracle Database Client Using Response Files' for information about silent or response file mode installations

Do not use Oracle Universal Installer from an earlier Oracle product release to install components from this release.
Use the same installation media to install Oracle Database Client on all supported Windows platforms.
If you reinstall Oracle software into an Oracle home directory where Oracle Database Client is already installed, you must reinstall any components that were installed before you began the reinstallation.
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 during installation, click Help or see Appendix D, 'Troubleshooting the Oracle Database Client Installation' for advice.
Products not installed by default, in case of Custom installation:
- Oracle Connection Manager
- Oracle Net Listener
- Oracle Scheduler Agent
- Intel dh61ww ram support. Oracle Services for Microsoft Transaction Server
- Oracle Counters for Windows Performance Monitor

3.3.2 Procedure for Installing Oracle Database Client

Use Oracle Universal Installer to install the Oracle Database Client software.

To install Oracle Database Client perform the following steps:

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.
Insert the Oracle Database Client installation media and navigate to the client 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 platforms.
Double-click setup.exe to start Oracle Universal Installer.
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, enter the following command:
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.
See Also:
- Oracle Universal Installer and OPatch User's Guide for information about response file formats
If you have an existing Oracle Database Client 11g Release 2 (11.2) installed on your system, the Select Installation Mode screen is displayed. Select New Install to install Oracle Database Client software in to a new location.
Starting with Oracle Database 11g Release 2 (11.2.0.2), if you want to upgrade an earlier release of Oracle Database Client, then select Upgrade and follow the instructions in 'Performing an In-place Oracle Database Client Upgrade'
In the Select Installation Type screen, select the type of installation that you want: Instant Client, Administrator, Runtime, or Custom and click Next.
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. In the Download Software Updates screen, select one of the following options, and click Next:
- Use My Oracle Support credentials for download 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 to apply previously downloaded software updates.
  Drivers inland ma3303 driver. I have reconnected the cable as before - connecting the cable to the laptop first then connect to the printer.
- Skip software updates if you do not want to apply any updates.
The Apply Software Updates screen is displayed if you select to download the software updates or provide the pre-downloaded software downloads location. If you selected Use My Oracle Support credentials for download in the previous screen, then select Download and apply all updates, and click Next. If you selected Use pre-downloaded software updates, then select Apply all updates, and click Next.
The Select Product Languages screen 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.
This screen is not displayed if you select Instant Client as the type of installation in step 5.
In the Specify Installation Location screen, enter the following details:
Oracle Base: This path appears by default. You can change the path based on your requirement.
The Oracle Base section is not displayed if you select Instant Client as the type of installation in step 5.
In the Software Location section, 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.
If you selected Custom as the type of installation in step 5, then the Available Product Components screen is displayed. Select the products that you want to install and click Next.
Note:
Starting with Oracle Database 11g Release 2 (11.2), you can install Oracle Connection Manager, Oracle Net Listener, and Oracle Scheduler Agent using the Custom install option.
In step 10, if you select Oracle Scheduler Agent as one of the components that you want to install, then the Oracle Database Scheduler Agent screen is displayed. The Scheduler Agent Host Name, and the Scheduler Agent Port Number is displayed by default. Click Next.
The Perform Prerequisite Checks screen verifies if your computer meets the minimum system requirements to install the desired product. Click Next.
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 is able to install Oracle Database successfully.
Review the information displayed in the Summary 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.
The Install Product screen shows the progress of a client installation. After Oracle Database Client is installed, click OK.
If you are performing a Custom installation, and selected Oracle Net Listener from the list of components to install in step 10, then go to 'Using Oracle Net Configuration Assistant' for instructions.
In the Finish screen, click Close to exit Oracle Universal Installer.

Using Oracle Net Configuration Assistant

During a Custom Oracle Database Client installation, if you select Oracle Net Listener from the list of components to install in step 10, then Oracle Universal Installer automatically starts Oracle Net Configuration Assistant as part of the Oracle Database Client installation. Perform the following to configure the listener and naming methods using Oracle Net Configuration Assistant:

In the Welcome screen, click Next.
In the Listener Configuration screen, enter a Listener name or accept the default value. Click Next.
In the Listener Configuration, Select Protocol screen, select one or more protocols from the Available Protocols list, and move it to the Selected Protocols list. Click Next.
In the Listener Configuration, TCP/IP Protocol screen, select the standard port number, or enter a different port number. Click Next.
Select No if you do not want to configure an additional listener, and click Next.
The listener configuration is now complete, click Next to proceed.
In the Naming Methods Configuration screen, select Yes to configure naming methods. Click Next.
In the Naming Methods Configuration screen, select the naming method you want from the list of Available Naming Methods and then click Next.
Typically, Local Naming is sufficient.
In the Net Service Name Configuration screen, enter Service Name, and click Next.
In the Net Service Name Configuration screen, select the protocol for the database you want to access, and click Next.
In the Net Service Name Configuration screen, enter the Host name of the computer where the Oracle database is installed. Use the standard port number, or specify a different port number, and click Next.
In the Net Service Name Configuration, Test screen, click Yes to test the database connection. Click Next.
In most cases, the test fails only because the default user name and password Oracle Universal Installer supplies in the dialog box do not match the user name and password for the target database. Click Change Login, reenter the user name and password, and then click OK.
In the Connecting screen, click Next.
In the Net Service Name screen, enter the name of the Net Service Name, and click Next.
Answer the remaining prompts to complete the configuration.
In the Finish screen, click Close, to exit from Oracle Universal Installer.

You can also run Oracle Net Configuration Assistant after the installation in standalone mode to configure the listener, naming methods, net service names, and directory server usage.

To start Oracle Net Configuration Assistant in standalone mode, select Programs from the Start menu, and then select Oracle -HOME_NAME. Next, select Configuration and Migration Tools, and then Oracle Net Configuration Assistant.

See Also:

'Using Oracle Net Configuration Assistant to Configure Network Components' in Oracle Database Net Services Administrator's Guide

3.3.3 Performing an In-place Oracle Database Client Upgrade

Starting with Oracle Database 11g Release 2 (11.2.0.2) you can perform an in-place upgrade of Oracle Database Client 11g Release 2 (11.2) using the following instructions:

Note:

You can perform an in-place Oracle Database Client upgrade only if you have an existing Oracle Database Client 11g Release 2 (11.2.0.1) or later client home installed on your system.

Perform Steps 1 through 3 listed in 'Procedure for Installing Oracle Database Client'.
The Select Installation Mode screen is displayed only if you have an existing Oracle Database Client 11g Release 2 (11.2.0.1) or later installed on your system, . Select Upgrade to upgrade the existing Oracle Database Client software to the latest version.
In the Specify Installation Location screen, accept the default Software Location 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.
In the Download Software Updates screen, select one of the following options, and click Next:
- Use My Oracle Support credentials for download
- Use pre-downloaded software updates
- Skip software updates
See Step 6 in 'Procedure for Installing Oracle Database Client' for more information about the options in the Download Software Updates screen.
The Apply Software Updates screen is displayed if you select to download the software updates or provide the pre-downloaded software updates location. Select either Download and apply all updates or Apply all updates, as applicable, and click Next.
See Step 7 in 'Procedure for Installing Oracle Database Client' for more information about the options in the Apply Software Updates screen.
The Select Product Languages screen 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.
The Perform Prerequisite Checks screen verifies if your computer meets the minimum system requirements to install the desired product. Click Next.
Review the information displayed in the Summary screen, and click Install.
The Install Product screen displays the progress of the client upgrade.
Review the information in the Finish screen and click Close to exit Oracle Universal Installer.

See Also: