1 Oracle Database Client Installation Overview

This chapter describes the different types of Oracle Database Client installations that you can perform, as well as issues that to consider before you install the software:

1.1 Installation Overview

The Oracle Database Client installation process consists of five steps:

  1. Read the release notes: Read the Oracle Database 11g release 1 (11.1) release notes before you begin the installation. The release notes are available with the platform-specific documentation. The latest version of the release notes is available on Oracle Technology Network at:

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

  2. Plan your installation: This overview chapter describes the installation types that you can use to install Oracle Database Client and issues to consider before you begin.

    You may also want to refer to Appendix A, "Frequently Asked Questions about Installation," in Oracle Database Installation Guide. This appendix advises on the best way to install Oracle products depending on your site's requirements.

    Note:

    If you perform a Custom installation, then ensure that you install only the components covered by your license. You can not install Standard Edition using Custom installation.
  3. Complete preinstallation tasks: Chapter 2 describes preinstallation tasks that you must complete before installing Oracle Database Client.

  4. Install the software: Use the following sections to install Oracle Database Client:

  5. Complete postinstallation tasks: Use the following sections to complete the postinstallation tasks:

    • Chapter 4 describes recommended and required postinstallation tasks.

    • Appendix C provides information on globalization support.

1.2 New Oracle Product Installed with This Release

The following product is installed by default during a Database Client installation for 11g release 1:

1.2.1 Oracle SQL Developer

Oracle SQL Developer is a graphical version of SQL*Plus that gives database developers a convenient way to perform basic tasks. Following are the functions you can perform with Oracle SQL Developer:

  • Browse, create, edit, and delete (drop) database objects

  • Run SQL statements and scripts

  • Create, edit, compile, and debug PL/SQL code

  • Create, edit, and update data

  • Import data, export data, and Data Definition Language (DDL)

  • View and create reports

  • View metadata and data of Microsoft Access, Microsoft SQL Server, and MySQL databases

1.3 Deprecated Components in Oracle Database Client 11g Release 1 (11.1)

The following is a list of components that were part of Oracle Database Client 10g release 2 (10.2), and are not available for installation with Oracle Database Client 11g:

  • iSQL*Plus

  • Oracle Enterprise Manager Java console

  • SQL*Plus Graphic User Interface (sqlplusw.exe)

    The command-line tool still exists.

1.4 Recommended File System

Oracle recommends that you install the database software on NTFS because the NTFS file system provides improved security of the database files, trace files, incident data, and so on, stored in the Oracle home.

See Also:

"File Permissions" in Oracle Database Platform Guide for Microsoft Windows for information about the default permissions when using Oracle Universal Installer and Database Configuration Assistant to install the Oracle Database software

1.5 Managing User Accounts with User Account Control on Windows Vista

To ensure that only trusted applications run on your computer, Windows Vista provides User Account Control. If you have enabled this security feature, then, depending on how you have configured it, Oracle Universal Installer prompts you for either your consent or your credentials when installing Oracle Database. Provide either the consent or your Windows Administrator credentials as appropriate.

You must have Administrator privileges to run some Oracle tools, such as Database Configuration Assistant, Net Configuration Assistant, and OPatch, or to run any tool or application that writes to any directory within the Oracle home. If User Account Control is enabled, and you are logged in as the local Administrator, then you can successfully run each of these commands in the usual way. However, if you are logged in as "a member of the Administrator group," then you must explicitly invoke these tasks with Windows Administrator privileges. All the Oracle shortcuts which require Administrator privileges will be invoked as "Administrator" automatically when we click the shortcuts. However, if you run the above tools from a Windows command prompt, you need to run them from an admin command prompt. OPatch does not have a shortcut and has to be run from an admin command prompt. See "Starting Database Tools on Windows Vista" in Oracle Database Platform Guide for Microsoft Windows for more information.

To start a command prompt window with Windows Administrator privileges:

  1. On your Windows Vista Desktop, create a shortcut for the command prompt window. An icon for that shortcut appears on the Desktop.

  2. Right click the icon for the newly created shortcut, and specify "Run as administrator."

When you open this window, the title bar reads Administrator: Command Prompt. Commands run from within this window are run with Administrator privileges.

1.6 Oracle Database Client Installation Types

You can choose one of the following installation types when installing Oracle Database Client:

  • Instant Client: Installs only the shared libraries required by Oracle Call Interface applications that use the Instant Client feature. This installation type requires much less disk space than the other Oracle Database Client installation types.

    Included in the Instant Client installation is Instant Client Light. You may want to use this version of Instant Client if your applications will generate error messages in American English only. The advantage of using Instant Client Light is that it has a much smaller footprint than regular Instant Client. Hence, your applications use less memory.

  • Administrator: Enables applications to connect to an Oracle database on the local system or on a remote system. It provides tools that let you administer an Oracle database.

  • Runtime: Enables applications to connect to an Oracle database on the local system or on a remote system.

  • Custom: Enables you to select individual components from the list of Administrator and Runtime components.

    Note:

    If you perform a Custom installation, then ensure that you install only the components covered by your license. You can not install Standard Edition using Custom installation.