E-AE: Read-Only Application Engine Process Abends Sporadically with "ORA-03114: Not Connected To ORACLE" On Active Data Guard Configuration (Doc ID 1643133.1)

Last updated on AUGUST 28, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 to 8.53 [Release 8.4]
Information in this document applies to any platform.

Symptoms

Application & Version: PT 8.53.11/HRMS 9.1 Bundle 6,

In an Active Data Guard(ADG) configured environment, running Scheduled Query(PSQUERY) using PSAESRV intermittently fails with ORA-03114 error.  When the firewall drops the Database(DB) connection if it has not been used for more than 24 hours.

ERROR
---------------


WHAT WORKS
---------------
Restarting the Process Scheduler fixes the issue.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms