Automation Guide Application testing Testing with databases Oracle Database Testing with Oracle on Windows machines Oracle Database Enterprise Edition

 Installing and configuring Oracle Database Enterprise on client machines

Installing and configuring Oracle Database Enterprise on client machines

This topic describes the steps required for installing and configuring Oracle Database Enterprise on client machines.

1. On your local client machines, download and install Oracle Database Client.

   1. You can download Oracle Database Client at http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

   2. During installation, it is highly recommended that you do the installation type of Administrator, which enables applications to connect to an Oracle database on the local system or on a remote system. It also provides tools that let you administer an Oracle database.

   • Oracle 11g Release 2: Learn more.
     
     

   • Oracle 12c Release 2: Learn more.
     
     

2. After Oracle Database Client’s installation, configure the following network components via Oracle Net Configuration Assistant.

   1. Open Oracle Net Configuration Assistant.

      • Oracle 11g Release 2: Learn more.
      • Oracle 12c Release 2: Learn more.

   2. Configure the following network components.

      Table 1. Configuration options in the Welcome page

      Option	Description
      Listener configuration	Click to create modify, delete, or rename a listener.
      Local Net Service Name configuration	Click to create, modify, delete, rename, or test connectivity of a connect descriptor stored in a local tnsnames.ora file.

      For detailed instructions:

      • Oracle 11g Release 2: Please read the Using Oracle Net Configuration Assistant section.
      • Oracle 12c Release 2: Read here

      1. Listener configuration:
         
         

      2. Local Net Service Name configuration:
         
         

3. Add an Oracle data source via ODBC Data Source Administrator.

   1. On your local machines, open the ODBC Data Source Administrator dialog box.

   2. In the ODBC Data Source Administrator dialog box, select the System DSN tab, and then click the Add button to add an Oracle data source.

      For detailed instructions, read Configuring the Data Source > To configure or add an Oracle data source at here.
      
      

      Notes: 
      If there are no options in the TNS Service Name drop-down, you can add a system environment variable with following value.

      set TNS_ADMIN=%ORACLE HOME%\network\admin
      

   The new Oracle data source now appears in the ODBC Data Source Administrator dialog box, under the System DSN tab.