Symptom
Failing smoketest and errors on failing database transactions
Impact
Unstable environment and degradation of service quality across the whole NRP service landscape
Root cause
The underlying Oracle database ran out of resources due to a high amount of sessions.
This increase in load was introduced by four new servers that has been added to a staging environment and naturally increased the amount of sessions open at a given time.
Resolution
The allocated dedicated memory for the database was raised to account for the extra load.
Actions
No further actions will be taken
It was expected to that the database could to handle this increase in sessions.
The database was recently migrated to a new Exadata setup. Due to unforeseen behaviour of resource allocation on the new setup it, was discovered that the allocation of memory was not dedicated but shared amongst several databases.
This has been rectified with the raise of dedicated memory as the resolution.
Reference: INC0014346
Event started at: 08:00
Event ended at: 09:37