Starting the Distributed Processing Server Service

You can start the Distributed Processing Server Service by following the steps in this procedure.

1. If you have not already edited the script cdr_apps_dpserver.sh (or cdr_apps_dpserver.cmd), do so. See "Edit the DP Server Start Script" in the chapter on installing Oracle Life Sciences Data Hub in the Oracle Life Sciences Data Hub Installation Guide.
2. Log on as cdr_dpserver.

   This user is created when you run the post-installation job (see the "Run the Post-Installation Programs" in the chapter on installing Oracle LSH in the Oracle Life Sciences Data Hub Installation Guide).

3. Run the script cdr_apps_dpserver.sh (or cdr_apps_dpserver.bat) by entering the following command:

   ./cdr_apps_dpserver.sh ORACLE_SID DB_HOST DB_PORT RAC_TNS RAC_FLAG

   where:

   • ORACLE_SID is the Oracle SID of the database

     Note:

     The Oracle SID is case-sensitive.
   • DB_HOST is the name of the computer where the Oracle_SID resides
   • DB_PORT is the SQL*Net Listener port for the Oracle_SID
   • RAC_TNS is the JDBC connection string of the database server
   • RAC_FLAG indicates whether you are using an Oracle RAC (Real Application Cluster) database installation. Set to RAC if you have a RAC installation. Set to NO-RAC if you do not.

     The RAC_FLAG setting determines which input parameter values the script uses when starting the DP Server.

     • If RAC_FLAG is set to RAC, the script uses only the value for RAC_TNS.

     • If RAC_FLAG is set to NO-RAC, the script uses the values for ORACLE_SID, DB_HOST, and DB_PORT.

     In either case, it does not matter what value you enter for the unused parameters. See examples below.

   • FW_ENABLED Set to Yes to start the File Watcher Service or No if you are not using Oracle DMW.
   • FW_FREQ (Applies only to Oracle DMW customers.) Refresh frequency in seconds. This value specifies the minimum interval between requests to the database to check if there is a new set of Watcher Configurations. This value cannot be set lower than 60 seconds. A high setting will result in a delay between the user's addition or adjustment of a Watcher Configuration in Oracle DMW and the changes' taking effect in file detection behavior.
   • FW_POLL (Applies only to Oracle DMW customers.) Polling frequency in seconds. The polling frequency represents the minimum interval at which a File Watcher Service may run to detect if there are any files in the watched location that should be loaded into Oracle DMW. The minimum value permitted is 60 seconds.

   NO-RAC Example when RAC_FLAG is set to NO-RAC:

   ./cdr_apps_dpserver.sh abc123 ab123cd.example.com 1234 NA NO-RAC

   where:

   • abc123 is the Oracle SID
   • ab123cd.example.com is the host
   • 1234 is the port
   • You may enter NA (Not Applicable) or any other value for RAC_TNS.
   • NO-RAC is the setting for RAC_FLAG

   RAC Example when RAC_FLAG is set to RAC:

   ./cdr_apps_dpserver.sh NA NA NA 'jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ab123cd.example.com)(PORT=1234))(ADDRESS=(PROTOCOL=tcp)(HOST=ef456ghRAC.example.com)(PORT=5678)))(CONNECT_DATA=(SERVICE_NAME=CDRXXX)))' RAC

   where:

   • You may enter NA (Not Applicable) or any other value for ORACLE_SID.
   • You may enter NA (Not Applicable) or any other value for DB_PORT.
   • You may enter NA (Not Applicable) or any other value for DB_HOST.
   • jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ab123cd.example.com)(PORT=1234))(ADDRESS=(PROTOCOL=tcp)(HOST=ef456ghRAC.example.com)(PORT=5678)))(CONNECT_DATA=(SERVICE_NAME=CDRXXX)))is the JDBC connection string of the database server
   • RAC is the setting for RAC_FLAG
4. The script prompts you for a password. Enter the password for the cdr_dpserver user.

Note:

Do not change the value of DB_USER.