Progress
DataServer
for ORACLE Guide
Starting the DataServer in the Explorer Administration Framework
The Progress Explorer administration framework administers only the server module (
_orasrv
on NT and UNIX) of the DataServer. After starting the server, start your Progress client as you would in any remote DataServer configuration. The following sections describe how to run the DataServer in the Explorer administration framework on NT and on UNIX. The Explorer administration framework is not supported on Windows.On the NT Host
Use the Progress Explorer tool to run DataServer processes on the NT host. Optionally you can use the command-line technique described in the "On the UNIX Host" section. Follow these steps to start and shut down the DataServer:
- In the Progress Explorer tool, configure the DataServer for ORACLE broker as described in the "Configuring the DataServer in the Explorer Administration Framework" section in Configuring the DataServer."
- From the Progress Explorer’s left pane, select the ORACLE DataServer folder and double-click. The list of existing DataServer brokers for ORACLE appears in the right pane.
- Select the DataServer broker you want to start and right-click. A pop-up menu appears.
- Choose the Start option from the pop-up menu. The Status in the right pane changes to Running for that DataServer broker.
- To edit the ORACLE DataServer broker configuration, select the DataServer broker and right-click. Choose the Properties option from the pop-up menu. See the Progress Explorer online help for more information on editing an ORACLE broker configuration.
- To check the status of an ORACLE DataServer broker, select the DataServer broker and right-click. Choose the Status option from the pop-up menu. See the Progress Explorer online help for more information the various Status tabs.
- To stop the broker, select the DataServer broker and right-click. Choose the Stop option from the pop-up menu. The Status in the right pane changes to Not Running for that DataServer broker.
For more information on using the Progress Explorer tool, see the online help.
On the UNIX Host
Use the Progress Explorer administration framework command-line interface to run DataServer processes on the UNIX host. Follow these steps to start and shut down the DataServer:
- Configure the DataServer for ORACLE broker as described in the "Configuring the DataServer in the Explorer Administration Framework" section in Configuring the DataServer."
- To start the DataServer broker, enter this command at the system prompt on the machine where the broker will run:
where broker-name is the name you gave the broker when you configured it.
You can run the broker from a remote machine. In that case, you specify additional options that identify the remote host:
where broker-name is the name you gave the broker when you configured it; host-name is the name of the host machine on which you want the broker to run; and user-name is the user ID of the system account under which the AdminServer is running. This account can be different from the one that owns the DataServer broker, which in turn can be different from the user profile you use to connect to the ORACLE database.
- To stop the DataServer broker, enter this command at the system prompt on the machine where the broker will run:
You can stop a broker on a remote machine by adding the
-host
and-user
options.You can also use the
oraman
utility to check the status of a broker. See "DataServer Command Line Utilities and Startup Parameters," for a complete description.On the Client
After you have started the broker on the host machine, you can connect your UNIX or Windows client. Use the same parameters that you would use for connecting to the schema holder and ODBC data source in a standard configuration. In addition:
- Include the -Dsrv SVUB,1 parameter. This parameter allows you to connect to the broker administered by the Explorer.
- Set the -S parameter to a service name whose associated port matches the port number assigned to the broker instance that you started in the Explorer. On NT, the Explorer Property Editor, General in the Broker category lists the broker instance’s port number. On UNIX, see the
ubroker.properties
file. Note that this -S setting differs from a standard remote connection where you set the -S parameter to the service that you used when startingprobrkr
.- Set the -H parameter to the name of the machine where the broker instance is running.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |