Run PSUB in a RAC Environment

PSUB considerations in a RAC installation:

• In a RAC installation, Oracle recommends installing the Oracle Clinical database server, which includes the PSUB Server, on at least two RAC nodes. If PSUB goes down on one node, or if the node itself goes down, you can start PSUB on the other node with little interruption of service.
• You must start one and only one PSUB service for each database. Oracle Clinical cannot detect if more than one PSUB service is running, so results are unpredictable in that case.
• Create the same directory structure for PSUB files on each computer where PSUB may run. That way you do not have to change the OCL_STATE reference codelist value for the five PSUB directories.

  Note:

  However, you do have to change the OCL_STATE SERVER_NAME value when you start PSUB on a different server.
• If you use NFS to share the files, users will still be able to access files for jobs performed on the other node unless the node itself fails.

PSUB supports the following scenarios in a RAC environment:

• If the database instance on the PSUB server goes down, but its server is still active, PSUB will transparently continue to process jobs for the other database instances in the RAC environment.
• If one PSUB service or server fails, PSUB can be started for that database on another server.
• If another node is added or removed, PSUB continues to work.
• If the PSUB server goes down or is removed, an administrator can manually start the PSUB service on another server with minimum downtime.

In the event of a PSUB failure, current PSUB jobs are affected differently based on their state at the time of PSUB failure:

• SCHEDULED or ENTERED jobs are picked up by the newly started PSUB service.
• SUBMITTED jobs will likely need to be re-submitted.
• STARTED jobs continue to run, regardless of PSUB status.

Note:

There is no notification if a PSUB service fails. In this case, a user's job does not complete and he or she must contact the administrator. The administrator checks the log file, starts PSUB on another node, and changes the SERVER_NAME value in the OCL_STATE reference codelist.

For more information, see Supported Configurations with Oracle Real Application Clusters (RAC).