Try OpenEdge Now
skip to main content
DataServer for Oracle
Connecting the DataServer : Starting the local DataServer
 

Starting the local DataServer

Starting the OpenEdge client starts the local DataServer. You include information about the Oracle database, user ID, and password in the startup command.
To start the local DataServer:
1. Set ORACLE_HOME and ORACLE_SID and start an instance for the supporting Oracle database.
2. Set the environment variables in the shell from which you are starting the DataServer. The following table describes how to set them:
For this variable . . .
Set . . .
DSLOGDIR
The pathname to the directory where the DataServer creates the log file, dataserv.lg, to track processes and error messages. By default, the DataServer creates this file in the current directory. (Optional)
ORACLE_HOME
The pathname of the directory where Oracle is installed.
ORACLE_SID
The identifier for the Oracle instance you are accessing.
Note: If you change the values of any environment variables, such as ORACLE_SID or ORACLE_HOME, you must shut down the DataServer processes and restart them.
3. Enter one of the following commands, depending on the platform:
a. For a Local DataServer on UNIX, enter the following command:
pro schema-holder-name -db ora-dbname -dt ORACLE
-ld oracle-logical-db-name -U userid -P password
b. For a Local DataServer in Windows, enter the following command:
prowin32 schema-holder-name -db ora-dbname -dt ORACLE
-ld oracle-logical-db-name -U userid -P password
For example, the following command starts OpenEdge with the DataServer on a UNIX machine, connects a local schema holder oholder in single-user mode, and connects an Oracle database orademo with a user scott and the password tiger:
pro oholder -db oradb -dt ORACLE -ld orademo -U scott -P tiger
For Oracle Networking startup information, see Connecting through Oracle Networking.