Progress
DataServer
for ORACLE Guide


Configuring the DataServer on the NT Host

Before you can run the DataServer modules on the NT host, you must set environment variables. The Progress ProControl utility provides a graphical interface that allows you to manage and configure the DataServer host environment. If you do not choose to use ProControl and want to set environment variables manually, see Table 3–2.

If you have not used ProControl before, see the Progress Database Administration Guide and Reference or the ProControl online help for security issues. For example, depending on whether a drive is configured as FAT or not, you must specify in the NT Services utility which account users will use to log on.

Follow these steps on the NT host to use ProControl to configure the DataServer modules:

  1. Access ProControl by double-clicking its icon in the NT Control Panel. The ProControl dialog box opens.
  2. Choose Detail. Tabbed folders appear.
  3. Choose the Options tab and activate the DataServer Page toggle.
  4. Choose OK and choose Detail on the ProControl main window. The DataServers tab appears.
  5. Choose the DataServers tab and choose Insert to add an entry for the broker. The General and Environment tabs appear.
  6. Enter the appropriate information in the following fields in the General folder:
    • Identifiers — Provide a unique name to identify the broker. The name must be unique to the host. The identifier can be up to 30 characters long. For example, you might name it orabroker.
    • Executable Name — Specify the broker executable. By default, the _probrkr executable displays. If you want to use a customized executable that you built using the PROBUILD utility, specify it here.
    • Working Directory — Specify the directory that the broker uses, for example, to create the dataserv.lg file.
    • NOTE: Only one broker can run in a directory at a time. If you want to run multiple brokers, run each in a separate directory.

    • Service Name — Specify the value for the Service Name (-S) startup parameter. Look in your install-path\system32\drivers\etc\services file for an available service that the broker can use.
    • Network Protocol — Specify TCP for the Network (-N) startup parameter.
  7. Activate the Auto Start toggle if you want the broker to start automatically when you boot the host machine. To start the broker automatically, you must also use the NT Services utility to set the Progress ProService utility to start automatically.
  8. Choose the Environment tab in the DataServers folder and set the required variables as described in Table 3–2.
  9. Table 3–2: DataServer for ORACLE Environment Variables 
    Variable
    Value
    ORACLE_HOME
    The pathname of the directory where you installed ORACLE.
    ORACLE_SID
    The identifier for the ORACLE instance you are accessing.
    ORASRV
    The name of the executable (including the path) of the ORACLE DataServer. If you are not using the default DataServer executable, _orasrv, set ORASRV to point to the appropriate executable.

  10. Choose OK.
  11. Start the broker by choosing Start on the DataServers folder.

Once the broker is running, you can build the schema holder for the ORACLE database. See the "Creating a Schema Holder" section for instructions.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095