After upgrading to Oracle 11.2.0.4, HISTORY_PURGE Job aborts with ORA-03113 error.

book

Article ID: 87783

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Error Message :
ORA-03113: end-of-file on communication channel

After upgrading the Applications Managers Oracle installation to 11.2.0.4, HISTORY_PURGE Job aborts when it attempts to delete records created after the upgrade.

Job's output file displays the below error or similar:

 
ERROR at line 3: 
ORA-03113: end-of-file on communication channel 
Process ID: 28295 
Session ID: 495 Serial number: 6189

 

 
 
 

Cause

Cause type:
Configuration
Root Cause: This issue is related to a change made in Oracle version 11.2.0.4.

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

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

Fix Version(s):
N/A

Additional Information

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