Batch System Behavior With TAF Configured

The following table summarizes PeopleSoft batch system behavior during RAC or Data Guard failover when TAF is configured.

PeopleSoft Batch System Scenario Behavior

Process Scheduler

Oracle reconnects and reconstructs the session on a surviving node. The Process Scheduler fails over with no administration intervention required.

Application Engine job submitted just before primary instance failure

Oracle reconnects and reconstructs the session on a surviving node but Application Engine job may fail and appear in the PeopleSoft Process Monitor with a status of No Success. These jobs will need to be resubmitted manually.

If the Application Engine job was not in an open-transaction and was performing only SELECT statements, it will fail over and complete successfully.

Application Engine submitted during or just after primary instance failure

Oracle reconnects and reconstructs the session on a surviving node, the Application Engine job is then submitted on the new primary database and completes successfully.

COBOL jobs before, during, or after primary instance failure

The COBOL jobs will not complete successfully on the surviving node.

Manual intervention is required to restart the COBOL jobs.

SQR jobs submitted just before or during primary instance failure

Oracle reconnects and reconstructs the session on a surviving node but SQR may fail and appear in the PeopleSoft Process Monitor with a status of No Success. These jobs will need to be resubmitted manually.

If the SQR job was not in an open-transaction nor executing DMLs and was performing only SELECT statements, it will fail over and complete successfully.

SQR jobs submitted just after primary instance failure.

Oracle reconnects and reconstructs the session on a surviving node, the SQR job is then submitted on the new primary database and completes successfully.

nVision reports

The behavior is the same as COBOL

PSQUERY, Tree Viewer, BI Publisher Query Report Viewer

Will fail over and complete successfully.