Set Up Parameterized Submissions

The Parameterized Submission process (PSUB) schedules and runs jobs, reports, and batch processing for Oracle Clinical. In order to support using Oracle Real Application Clusters (RAC), the implementation of PSUB changed in Oracle Clinical 5.0. See the 5.0.1 Installation Guide for more information.

You must start one PSUB service for each Oracle Clinical database on the same server as the database.

For more information, see:

• Create Directories and Enter Values in OCL_STATE Local Reference Codelist
  
• Enable Users to Submit PSUB Jobs
  
• Set Up Active Directory
  
• Start the PSUB Service
  
• Customize the PSUB Service (Optional)
  
• Test the PSUB Installation
  

Create Directories and Enter Values in OCL_STATE Local Reference Codelist

1. Create several directories on the PSUB server.
2. Enter paths of the new directories in the OCL_STATE local reference codelist, with a few related values.
   See the "Setting Up Batch Job File Viewing" section of the "Setting Up File and Image Viewing" chapter of the Oracle Clinical Administrator's Guide for more information.

Note:

See Integrate SAS (Optional) for information about new OCL_STATE settings related to SAS configuration.

Enable Users to Submit PSUB Jobs

Beginning in Release 5.0, PSUB users no longer need:

• their own OS account
• a user name beginning with OPS$
• their own directory for PSUB outputs under their own OS account home. (Instead PSUB outputs are stored temporarily in a user specific directory under PSUB root folder specified inPSUB_LOGS_DIR entry of the OCL_STATE local reference codelist. Then they are uploaded into database and can be viewed.)

New Users

To add new users:

1. Use the ocl_add_user.sql script, indicating which new users need to run PSUB jobs.

   See the Oracle Clinical Administrator's Guide for more information.

Existing Users

If you are upgrading from a pre-5.0 version of Oracle Clinical, to give users who need to run PSUB jobs access to the opapps account:

1. Use the migration script oclupg50migrateusers.sql.
   See the Oracle Clinical Administrator's Guide for more information.

PSUB Administrator User

You can give a user the role RXC_VWJOBS (new in 5.0) to allow him or her to:

• View all users' jobs
• View the output from those jobs.
• Stop any job.

The following scripts can grant this role to a user:

• ocl_add_user—Use this script for new users.
• ocl_grant_revoke_rxc_vwjobs.sql—Use this script for existing users. (This script can also be used to revoke the role.)

See the Oracle Clinical Administrator's Guide for more information.

Set Up Active Directory

If you are running PSUB on a Windows server that is a primary domain controller running Active Directory:

1. Add the PSUB account (typically opapps) to the domain.
2. Reassign the following domain user privileges to the PSUB account, through the domain controller security policy and the domain security policy:
   • Load and unload device drivers
   • Act as part of operating system
   • Increase Quotas
   • Log on as a Service
   • Replace a process-level token

Start the PSUB Service

The Installer automatically installs the PSUB service on the database server. You must start it using on set of instructions below.

Instructions for stopping PSUB manually are included in the Oracle Clinical Administrator's Guide.

To start the PSUB service manually on Windows:

1. Log in as opapps. (You set up the PSUB service to start as the opapps user, but in Windows you can start the service when logged on as another user.)
2. Set the PSUB service parameters:
   1. In the Start menu, navigate to Administrative Tools, then Services.
   2. From the list of services in the Services dialog box, double-click the name of the database for this service. It is in this form:

      PSUB Service database

   3. Enter values for the Log On parameters:

      database code_environment [verbose | noverbose] value-of-RXC_ROOT wallet_alias

      For example: prod 54 verbose c:\\opapps\\oc\\54 <wallet_alias>

      where prod is the connect string for the database instance to which the PSUB service connects;

      where 54 is the name of the code environment;

      where wallet_alias is the name of the Wallet specified during installation.

      Note:

      If your entry requires a backslash (\), you must enter two (\\). Alternatively, you can enter the path using single forward slashes, for example, c:/opapps/oc/54.
3. Click Start.
4. Exit from the Services dialog box.
5. Check the PSUB service log file in <RXC_ROOT>\log for any warning or error messages.

Customize the PSUB Service (Optional)

1. Customize the PSUB service as follows:
   • Automatic Startup — By default, the PSUB service does not start automatically when you restart a server computer. However, you can configure the PSUB service to start automatically.
   • Job Numbering — You can change Oracle Clinical's default job numbering algorithm.

For more information about managing and customizing the PSUB service, see the Oracle Clinical Administrator's Guide.

Test the PSUB Installation

To test your PSUB installation:

1. Open Oracle Clinical.
2. Submit a 3GL job such as Batch Validation or a PL/SQL job such as Study Unfreeze.
3. Verify that Oracle Clinical creates the log and output files by clicking on the View log and View output buttons.

If you encounter problems or errors, review the messages in the PSUB log files created in the following directory:

%RXC_ROOT%\log