Start the Distributed Processing Server

To start the Distributed Proecssing Server, do the following:

  1. Log on as the owner of the Distributed Proecssing Server Home Directory.
  2. 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 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 Distributed Proecssing 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.

    • 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

  3. The script prompts you for a password. Enter the password for the cdr_dpserver user.
  4. Check if the DP server is running:
    ./checkJSapps.sh SID

Note:

Do not change the value of DB_USER.