[AWA] WP memory usage increases over time after upgrade Oracle database
book
Article ID: 145127
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation EngineCA Automic One AutomationCA Automic Operations ManagerCA Automic Oracle
Issue/Introduction
After upgrading of Oracle database, AE processes consume memory without releasing. - Oracle database was upgraded from 12.1 to 12.2 - Since then system processes (CP & WP) occupied more and more memory overtime until server's RAM is exhausted - Upgrading AE from 12.2.1HF4 to 12.3.1 and the issue still persists. - Another environment with original AE 12.2.1HF4 works normally.
Cause
Analysis from R&D: - If AE core is still the same, the only change to the environment was the new Oracle version, then the cause must be an issue with Oracle client.
Environment
Release : 12.3
Component : AUTOMATION ENGINE
Resolution
Upgrade to corresponding oracle client and the issue does not appear anymore.