Instance crashed with ORA-01092 Error

While I was checking a customer environment, I saw that the Repository Database of an Enterprise Manager Cloud Control installation was down. Due to the alert log, there was a hung of processes in the night and the instance was killed by the PMON. Every subsequent startup of the database failed with anĀ ORA-01092 error. In this blog post, I will demonstrate how to analyze a memory issue which can lead to an ORA-01092 error.

Continue reading »