Outage category:
Location: Multiple Locations
Status: Open
Resolved Alert:
Initial Symptoms
New connections could not be established against Banner PROD. This manifested in jobs failing in AppWorx and jobsub. Users were getting “service invocation errors” when attempting to connect to AppNav and/or an Admin Page. eVA crashed as well.
Root Cause Analysis
Cause
Error messages indicate 1 or 4 possible issues:
- Network issues
- Server memory
- Database memory
- Not enough user processes allowed on the server
There were no network issues at the time. Network issues would have also impacted existing session but that was not occurring.
Resolution
Monitoring tools indicated that additional CPU could help.
The following changes were made:
- Server memory was increased by 16G
- Four additional CPU were added to the server
- 2000 user processes added for the Oracle user
- Database memory was increase by 5G
- Maximum processes allowed within the database increased from 1500 to 3000.
Prevention
Monitoring.