Error Message :
ORA-03113: end-of-file on communication channel
After upgrading the Applications Managers Oracle installation to 126.96.36.199, HISTORY_PURGE Job aborts when it attempts to delete records created after the upgrade.
Job's output file displays the below error or similar:
Root Cause: This issue is related to a change made in Oracle version 188.8.131.52.
Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Oracle has recommended that the '_optimizer_unnest_all_subqueries' parameter be set to false at the session level as a workaround to the issue. Please contact Oracle for additional information regarding this parameter.
Fix Status: No Fix
The Oracle parameter '_optimizer_unnest_all_subqueries' can be set to specifically apply to the HISTORY_PURGE Job by editing the Automation Engine's $AW_HOME/sql/deljhist.sql script.
Please contact Automic Support for the SQL statement.