3 Installing Oracle Database Client

This chapter covers the following topics:

3.1 Installation Considerations for Oracle Database Client

The Oracle Database Client software is available on the Oracle Technology Network (OTN) website. 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 or response file installations, 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 Tasks" before beginning the installation.

Next, consider the following issues:

3.1.1 Installation Consideration on Windows

On Windows, command prompts should be opened with Administrator privileges.

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 installation. 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 and response file 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. If a Windows User Account is used as Oracle Home User, it can only share Oracle Base with other Oracle Homes with the same Windows user account. If Windows Built-in Account is specified as Oracle Home User, it can only share Oracle Base with other client Oracle Homes using Windows Built-in Account.

Oracle Database Client 12c Release 1 (12.1) cannot share Oracle base with Oracle homes from earlier database versions, such as Oracle Database 11g Release 2 (11.2) or earlier.

Caution:

After installing Oracle Database Client 12c or later, do not install older version of databases or clients and share the same Oracle base directory. During the installation of older releases of Oracle Database, ACLs are reset corresponding to older releases. Thus Oracle Database 12c or later services might not be able to access the Oracle base directory and the files in it.

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 Provider for OLE DB

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 12.1.0.1 into an existing Oracle Database 12.1.0.1 home. If you apply a patch set before installing the client, then you must apply the patch set again.

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 12.1.0.1 is installed, then use Oracle Universal Installer to upgrade to release 12.1.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.

  • Oracle Home User for the Oracle Home cannot be changed during the 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) website, 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:

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

  2. Start Windows Explorer.

  3. Right-click the DVD drive letter and choose 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 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.

  5. Insert the DVD labeled Oracle Database 12c 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:

  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.

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

    6. Click Finish.

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

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

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

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

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

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

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

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

    http://www.oracle.com/technetwork/indexes/downloads/index.html

  2. Navigate to the download page for the product that you want to install.

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

    The file sizes are listed next to the filenames.

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

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

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

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

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

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

  9. After you have extracted the required installation files, see 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:

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

    http://edelivery.oracle.com/

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

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

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

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

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

    Note:

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

See Also:

3.2.3.3 Extracting the Installation Files

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

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

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

  1. Create a directory for the installation files on your hard drive. For example:

    d:\install\client
    
  2. 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 or response file installations, 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 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

    • Oracle Services for Microsoft Transaction Server

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:

  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. Navigate to the location of the installation media for Oracle Database Client 12c Release 1 (12.1), 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 platforms.

  3. If you have an existing Oracle Database Client 12c Release 1 (12.1.0.1) or later installed on your system, the Select Installation Mode screen is displayed. Select New Install to install Oracle Database Client software in a new location, or select Upgrade and follow the instructions in "Performing an In-place Oracle Database Client Upgrade" to upgrade an earlier release of Oracle Database Client.

  4. In the Select Installation Type screen, select the type of installation that you want: Instant Client, Administrator, Runtime, or Custom and click Next.

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

  6. Starting with Oracle Database 12c, during installation, you can specify an Oracle Home User associated with the Oracle Database home on the Specify Oracle Home User screen. The Oracle Home user owns all the Windows services run by the Oracle Database software. You can either specify an existing Windows user, or have the installer create the user for you. The Oracle Home user and several database services with the proper Access Control Lists (ACLs) are configured during installation.

    Select Use Windows Built-in Account if you do not specify an Oracle Home User during installation. Then the services for the Oracle home run as the LocalService or LocalSystem user.

    See Also: Oracle Database Platform Guide for Microsoft Windows

    The Oracle Home User is not available if you select Instant Client as the type of installation in step 4.

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

    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.

  8. If you selected Custom as the type of installation in step 4, 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.
  9. In step 8, if you select Oracle Scheduler Agent as one of the components to install, then the Oracle Database Scheduler Agent screen is displayed with the default host name and default port number. Enter the Scheduler Agent Hostname and the Scheduler Agent Port Number. Click Next.

  10. 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.
  11. 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.
  12. The Install Product screen shows the progress of a client installation. After Oracle Database Client is installed, click OK.

  13. If you are performing a Custom installation, and selected Oracle Net Listener from the list of components to install in step 8, then go to "Using Oracle Net Configuration Assistant" for instructions.

  14. 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 8, 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:

  1. In the Welcome screen, click Next.

    Note:

    If you do not select Oracle Home User for installation or Oracle Net Listener as a component, then you can select Perform typical configuration for default network configuration.
  2. In the Listener Configuration, Listener Name screen, enter a Listener name or accept the default value.

    The Oracle Home User Password field appears if you choose to install Oracle home using Oracle Home User. You must provide a password to run Windows services for the listener under the Oracle Home User account. Click Next.

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

  4. In the Listener Configuration, TCP/IP Protocol screen, select the standard port number, or enter a different port number. Click Next.

  5. In the Listener Configuration, More Listeners? screen, select No if you do not want to configure an additional listener, and click Next.

  6. The listener configuration is now complete, click Next to proceed.

    Note:

    If you have more than one listener, then you can select and start a listener from the list provided in the Listener Configuration, Select Listener screen.
  7. In the Naming Methods Configuration screen, select Yes to configure naming methods. Click Next.

  8. In the Naming Methods Configuration, Select Naming Methods screen, select the naming method you want from the Available Naming Methods list, and move it to the Selected Naming Methods list. Click Next.

    Typically, Local Naming is sufficient.

  9. In the Net Service Name Configuration, Service Name screen, enter Service Name, and click Next.

  10. In the Net Service Name Configuration, Select Protocols screen, select the protocol for the database you want to access, and click Next.

  11. In the Net Service Name Configuration, TCP/IP Protocol 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.

  12. In the Net Service Name Configuration, Test screen, click Yes, perform a test to test the database connection. Click Next.

  13. In the Net Service Name Configuration, Connecting screen, 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.

  14. In the Net Service Name Configuration, Net Service Name screen, enter the name of the Net Service Name, and click Next.

  15. Answer the remaining prompts to complete the configuration.

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

Oracle Database Net Services Administrator's Guide

3.3.3 Performing an In-place Oracle Database Client Upgrade

You can perform an in-place upgrade of Oracle Database Client 12c Release 1 (12.1) using the following instructions:

Note:

You can perform an in-place Oracle Database Client upgrade only if you have an existing Oracle Database Client 12c Release 1 (12.1.0.1) or later client home installed on your system.
  1. Perform Steps 1 through 3 listed in "Procedure for Installing Oracle Database Client".

  2. The Select Installation Mode screen is displayed only if you have an existing Oracle Database Client 12c Release 1 (12.1.0.1) or later installed on your system. Select Upgrade to upgrade the existing Oracle Database Client software to the latest version.

  3. Starting with Oracle Database 12c, during installation, you can specify an Oracle Home User associated with the Oracle Database home on the Specify Oracle Home User screen. The Oracle Home user owns all the Windows services run by the Oracle Database software. You can either specify an existing Windows user, or have the installer create the user for you. The Oracle Home user and several database services with the proper Access Control Lists (ACLs) are configured during installation.

    Select Use Windows Built-in Account if you do not specify an Oracle Home User during installation. Then the services for the Oracle home run as the LocalService or LocalSystem user.

    See Also: Oracle Database Platform Guide for Microsoft Windows

    The Oracle Home User is not available if you select Instant Client as the type of installation.

  4. In the Specify Installation Location screen, accept the default Software Location value. If multiple client installations exist on your system, then select the client Oracle home directory path from which you want to upgrade to the latest version. Click Next.

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

  6. The Perform Prerequisite Checks screen verifies if your computer meets the minimum system requirements to install the desired product. Click Next.

  7. Review the information displayed in the Summary screen, and click Install.

  8. The Install Product screen displays the progress of the client upgrade. When the installation completes, click OK.

  9. Review the information in the Finish screen and click Close to exit Oracle Universal Installer.