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.

Table 38. Remote DataServer connection parameters
Parameter	Description
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.

prowin32 schemaholdername -db fill-char -dt ORACLE
-ld oracle-logical-db-name -H hostname -S service-name
-U userID -P password

Table 39. Required connection parameters
Parameter	Description
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.