- Installation Guide
- Installing Oracle Life Sciences Data Hub
- Set Up the Distributed Processing Server
- Start the DP Server
Start the DP Server
To start the DP Server, do the following:
- Log on as the owner of the DP Server Home Directory.
- Run the script by entering the following command for UNIX. Information on the parameters is given below.
./cdr_apps_dpserver.sh
ORACLE_SID DB_HOST DB_PORT RAC_TNS RAC_FLAG FW_ENABLED FW_FREQ FW_POLL
or for Windows:
c
:> cdr_apps_dpserver.cmd
ORACLE_SID DB_HOST DB_PORT RAC_TNS RAC_FLAG FW_ENABLED FW_FREQ FW_POLL
where:
-
ORACLE_SID
is the Oracle SID of the databaseNote:
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 toRAC
if you have a RAC installation. Set toNO-RAC
if you do not.The RAC_FLAG setting determines which input parameter values the script uses when starting the DP Server.
Note:
At the time of publication, Release 3.0 is not certified with RAC.
-
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.
-
-
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 LSHDB adxxxsdb.example.com 20502 NA NO-RAC NO 0 0
where:
-
LSHDB
is the Oracle SID -
adxxxsdb.example.com
is the host -
20502
is the port -
You may enter NA (Not Applicable) or any other value for RAC_TNS.
-
NO-RAC is the setting for RAC_FLAG
-
NO indicates that File Watcher is not enabled; Oracle DMW is not being used.
-
0 FileWatcher Refresh Frequency, since File Watcher is not enabled
-
0 FileWatcher Polling Frequency, since File Watcher is not enabled
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=AP1RAC.example.com)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=AP2RAC.example.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=CDRXXX)))' RAC NO 0 0
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=AP1RAC.example.com)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=AP3RAC.example.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=CDRXXX)))
is the JDBC connection string of the database server -
RAC is the setting for RAC_FLAG
-
NO indicates that File Watcher is not enabled; Oracle DMW is not being used.
-
0 FileWatcher Refresh Frequency, since File Watcher is not enabled
-
0 FileWatcher Polling Frequency, since File Watcher is not enabled
-
- The script prompts you for a password. Enter the password for the cdr_dpserver user.
- Check if the DP server is running:
./checkJSapps.sh SID
Note:
Do not change the value of DB_USER.
Parent topic: Set Up the Distributed Processing Server