Documentation Center

Gateway Administrator Guide

Version 5.2 | Published March 01, 2019 ©

Install Database Client

This section describes how to install and test the Oracle Database 11g Client. For further documentation, please see the Oracle Documentation website:

This section has more information about these topics:

Pre-installation

  • If there is an existing Oracle Client installed, create a backup of the tnsnames.ora file

  • Remove any previous or older versions of the client

  • Download the client from Oracle’s web site

  • Click Downloads, and follow the instructions to make sure that the correct Oracle Database Client installation executable is selected.

To install the Oracle client

Note:

The installation procedure below is according to Oracle Client version 10.2.0.1.0. For a reference on another version, see the Oracle web site.

  1. Log on as a member of the Administrators group to the computer on which to install Oracle components. For installations on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.

  2. Double-click the installer (setup.exe).

  3. In the Welcome screen, click Next.

  4. In the Select Installation Type screen, select type Runtime.

  5. In the Specify Home Details screen, click Next

  6. In the Product-Specific Prerequisite Checks screen, click Next.

  7. In the Summary screen, click Next to start the actual installation and configuration.

    Note:

    Do not use the Oracle Net Configuration Assistant (NetCA) unless there are specific client connection configuration needs. Using the NetCA is beyond the scope of this guide.

  8. Click Next.

  9. In the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.

    • Optionally, delete the \temp\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.

    • Restarting the computer also removes the OraInstalldate_time directory.
      See also section Installation, and how To test the installation.

To set the language setting for the Oracle client

  1. Start the Registry Editor (regedit) on the Start menu

    • Click the Run menu option, enter regedit, and click OK

  2. Open the path \HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY...<version>

    images/download/attachments/32279562/installation_vgw_regedit_oraclexe_editnlslang.png

  3. Double-click the registry setting for NLS_LANG.

  4. Edit the string and change it to AMERICAN_AMERICA.AL32UTF8, and click OK

    Note:

    To help give Vizrt’s customers the best possible support, American English is chosen as the default language for log messages.

See Also

To test the installation

  1. Start a command-line tool, and type the following:

    sqlplus userid/password@tnsname

  2. It is also possible, if a TNS name alias is not configured, to use an easyconnect string:

    sqlplus userid/password@hostname/SID

  3. Check that the output is something like the example output below:

    C:>sqlplus pilot/pilot@VIZRTDB SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 24 12:17:19 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production SQL>

    See also section Installation.