Documentation Center

Installing the Oracle Client

Complete this procedure to install Oracle client software.

About this task

Before installing the Contenta software, you must configure the Microsoft SQL server 32‐bit ODBC data source.

Procedure

  1. Follow the instructions provided by Oracle to install the Oracle client software.
  2. In response to Type of Installation, click Administrator.
  3. After the Oracle Client installation is complete, if your Oracle client runs on a different machine than your Oracle server, use the Oracle Net8 Assistant to edit the tnsnames.ora file.

    The tnsnames.ora file contains the information needed for the Oracle client workstation to connect with the Oracle server and database. Ask your system administrator for the connect data: service name, host name, port number, and SID. The following table describes the data that you must provide.

    Net8 AssistantDescription
    Add New Service

    Service name is user defined—note however, if the sqlnet.ora file defines a default extension, the extension must be used in the service name.

    Do not specify a name that contains a hyphen.

    ProtocolTCP/IP
    Host NameName of database server; this is the server on which Oracle is installed.
    Port NumberUse the Oracle default port number unless otherwise instructed by your DBA.
    Service NameName of the Contenta Oracle instance or service (SID).

    The information provided in the Oracle Net8 Assistant is written to the tnsnames.ora file in the Oracle_home<...> network/admin directory path.

    The following is an example of the entry in the tnsnames.ora file for Contenta connectivity to the Oracle service.

    The example uses the SID, phoenix, as the service name for the Oracle server, rosie.
    PHOENIX =
       (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = rosie)(PORT = 1521))
          (CONNECT_DATA =
             (SERVER = DEDICATED)
             (SERVICE_NAME = phoenix)
            )
    )
  4. Alternatively, if your Oracle client runs on the same machine as your Oracle server, copy tnsnames.ora from the dbhome_1\network\admin\ subfolder of your Oracle home directory to its client_1\network\admin\ subfolder. For example, you would copy from

    e:\app\oracle\product\11.2.0\dbhome_1\network\admin\ to

    e:\app\oracle\product\11.2.0\client_1\network\admin\

  5. Obtain and install the Oracle patches required for this Contenta release.

    When you have completed installing and configuring the Oracle Client, test connectivity before continuing.

  6. If you are installing an Administrator client, continue with the steps for Configuring the Oracle ODBC Data Source for Windows 32-bit.