This section contains the following topics:
For information about the initial installation of Oracle Warehouse Builder or the Distributed Processing Server, see "Installing the Oracle Life Sciences Data Hub" in the Oracle Life Sciences Data Hub Installation Guide. See Chapter 1, "Setting Up Services" for information about the Distributed Processing (DP) Server.
Note:
During its development, the Oracle Life Sciences Data Hub (Oracle LSH) was known internally as CDR. Therefore many Oracle LSH-related directories, files, scripts, parameters, and so on are named CDR or contain the stringcdr
. Please think of CDR as a synonym for Oracle LSH.This section contains the following topics:
The Oracle LSH Distributed Processing (DP) Server passes jobs—executions of user-defined Programs and Data Marts and internal Oracle LSH jobs requiring XML Publisher—to the external engines that process them. You must install and start the DP Server on every computer where you have a processing engine installed. See Chapter 1, "Setting Up Services" for further information.
You must then start the service on the computer where it is required. The scripts required for starting, checking, and stopping the DP Server are provided with Oracle LSH. See "Setting Up the Distributed Processing Server" and the Oracle Life Sciences Data Hub Installation Guide for instructions for copying them to the DP Server home directory in each location.
Login Name You must log in as cdr_dpserver. This user is created by the post-installation job. Your company should have changed the default password. See "Run the Post-Installation Programs" in the chapter on installing Oracle LSH in the Oracle Life Sciences Data Hub Installation Guide for further information.
To start the service, do the following:
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 LSH in the Oracle Life Sciences Data Hub Installation Guide.
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).
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
The script prompts you for a password. Enter the password for the cdr_dpserver user.
Note:
Do not change the value of DB_USER.After you have installed and started the service, use the script checkJSapps to check that it is running. Enter the ORACLE_SID as a parameter value.
Log on as cdr_dpserver.
Run the script checkJSapps.sh (or cdr_apps_dpserver.bat) by entering the following command:
checkJSapps
Oracle_SID
For example:
./checkJSapps
abc123
where abc123 is the SID.
Note:
The Oracle SID is case-sensitive.To stop the service, do the following:
Log on as cdr_dpserver.
Run the script stopJSapps.sh by entering the following command:
stopJSapps.sh
Oracle_SID DPService_Name
where:
Oracle_SID
is the Oracle SID of the database
Note:
The Oracle SID is case-sensitive.DPService_Name
is the Service Location name for the computer where the DP Server is running.
The Oracle Warehouse Builder (OWB) service is required to run any Oracle LSH job and to install Work Areas. The OWB service is started automatically by the Oracle LSH database startup kit during installation.
Note:
The OWB server's log files are located in the directory $OWB_HOME/owb/log. If you have problems with a Work Area installation, the log file may help you diagnose the problem.To stop the OWB service do the following:
Change directory to $OWB_HOME/owb/rtp/sql
Log into SQL using the CDR_RTREPOS username and the password you set up when you installed OWB (see "Installing Oracle Warehouse Builder" in the Oracle Life Sciences Data Hub Installation Guide).
Note:
If you have upgraded to OWB 11.2.0.1 you must log in as OWBSYS instead of CDR_RTREPOS.At the SQL prompt, enter:
@stop_service.sql
When the system displays the words "Not Available" the service is stopped.
To start the OWB service do the following:
Change directory to $OWB_HOME/owb/rtp/sql
Log into SQL using the CDR_RTREPOS username and the password you set up when you installed OWB (see "Installing Oracle Warehouse Builder" in the Oracle Life Sciences Data Hub Installation Guide).
Note:
If you have upgraded to OWB 11.2.0.1 you must log in as OWBSYS instead of CDR_RTREPOS.At the SQL prompt, enter:
@start_service.sql
When the system displays the word "Available" the service has been restarted.
A job queue is required on the database to pass jobs from Oracle LSH to OWB. The job queue is enabled by the Oracle LSH post-installation concurrent processing job. You must explicitly start it using the instructions below.
Note:
The scripts are located in $cdr/patch/115/sql/.This section includes the following topics:
To start the job queue, connect as apps
and run this script:
begin cdr_exe_job_queues.start_jobq_process_disabled; end; / commit;
You can stop and disable the job queue by connecting as apps
and running this script:
begin cdr_exe_job_queues.stop_processing_queues; end; / commit;
After you have started the job queue (or it has been started during installation) you must enable the job queue by connecting as apps
and running a script as follows:
begin cdr_exe_job_queues.start_jobq_process_enabled; end; / commit;
This section contains the following topics:
If you plan to use message-triggered job submission, you must start a job queue on the database to pass jobs to Oracle LSH from XML messages from external systems. See "Using Message-Triggered Submission from External Systems" in the Oracle Life Sciences Data Hub Application Developer's Guide.
Log on as the APPS user and enter the following to start the queue:
begin cdr_exe_msg_queues_admin.start_processing_queues; cdr_exe_msg_queues_admin.enable_job_processing_queue; end;
Log on as the APPS user and enter the following to stop the queue:
begin cdr_exe_msg_queues_admin.stop_processing_queues; end;