Try OpenEdge Now
skip to main content
DataServer for Oracle
Connecting the DataServer : Connecting a schema holder : Connecting a schema holder at startup

Connecting a schema holder at startup

OpenEdge supports connection parameters that you can use to connect the OpenEdge schema holder and the Oracle database. These parameters control how your system connects to a database. When the OpenEdge DataServer for Oracle runs in a remote configuration, your startup command or parameter file must include parameters that control networking options.
The following table describes the connection parameters that relate to the remote DataServer and networking options.
Table 38. Remote DataServer connection parameters
Host Name (-H)
Indicates the name of the host machine in the network.
Service Name (-S)
Indicates the name of the service you are calling. The service you are calling is the broker on the host machine. Use the same name you used when you started the broker.
The following command starts OpenEdge for Windows:
prowin32 schemaholdername -db fill-char -dt ORACLE
-ld oracle-logical-db-name -H hostname -S service-name
-U userID -P password
You can use the previous command to start OpenEdge for Windows in the following situations:
*In single-user mode
*In a remote-DataServer configuration
*With a local schema holder connected
*With an Oracle database connected
The following table describes the parameters required for connecting to a schema holder and an Oracle database.
Table 39. Required connection parameters
User ID (-U)
Supplies the user ID that the OpenEdge DataServer for Oracle uses to log into the Oracle RDBMS.
Oracle allows you to pass the user ID and password as a single string to the -U parameter. If you specify -U userid/password or -U userid/password@service-name, the USERID function returns the password information or the password and service in addition to the user ID.
Password (-P)
Supplies the password that the OpenEdge DataServer for Oracle uses to log into the Oracle RDBMS unless it was specified with the -U parameter.
Physical Database Name (-db)
For OpenEdge databases, the string that follows this parameter is the physical name of the database you want to connect. However, for Oracle databases, this physical database name can be any fill characters. For example, use the logical database name after the -db parameter or any other designation, such as oradb.
Single-user Mode (-1)orRead-only (-RO)
Specifies that a database is used in single-user mode. When you connect the schema holder, you must connect either in single-user mode or as read-only.
Specifies that a schema holder is read-only. Connecting a schema holder as read-only increases processing speed at compile time. It also allows multiple client processes on the same machine to access the schema holder without starting additional server processes.
You can create a parameter file with the required parameters for each database. You can add more startup parameters than the ones listed—these are just the required parameters. For information on how to create a parameter file, see OpenEdge Deployment: Startup Command and Parameter Reference.
The following example commands demonstrate how to start DataServer clients that connect to the schema holder and Oracle database at startup.
* Remote DataServer: Windows client
* Remote DataServer via NameServer: Windows client
* Local DataServer: Windows
* Remote DataServer: UNIX client
* Local DataServer: UNIX
* Connecting a Schema holder and a broker using SSL-enabled Progress Networking