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. |